Warning: mysql_query(): Variable 'connect_timeout' is a GLOBAL variabl

We just installed the latest Dolphin on a FreeBSD 7.4 box. Cron keeps sending the following message:

Warning: mysql_query(): Variable 'connect_timeout' is a GLOBAL variable and should be set with SET GLOBAL in ...../public_html/flash/modules/global/inc/db.inc.php on line 51 Segmentation fault (core dumped)

Looks like a bug in the php file.

Any help is appreciated.

ASA2012

Quote · 30 May 2012

Your freebsd box must be running a version of mysql that has not been tested with dolphin.

Try commenting out that line that is causing the error. If you have timeout problems you may have to adjust the connect_timeout from within mysql's configuration on the server directly.

https://www.deanbassett.com
Quote · 30 May 2012

 

Your freebsd box must be running a version of mysql that has not been tested with dolphin.

Try commenting out that line that is causing the error. If you have timeout problems you may have to adjust the connect_timeout from within mysql's configuration on the server directly.

My Dolphine is 7.0.9.  My  Mysqld is version 5.1.3. My box Freebsd 7.4

I  commented  the line containing connect_timeout in the php file.

I did put connect_timeout = 10 (seconds)  in my.cnf, and restarted the mysqld daemon.

Now I get  only "Segmentation fault (core dumped)"  [sent by the cron]

I think it's a bug in the php file!

Quote · 31 May 2012

 

 

Your freebsd box must be running a version of mysql that has not been tested with dolphin.

Try commenting out that line that is causing the error. If you have timeout problems you may have to adjust the connect_timeout from within mysql's configuration on the server directly.

My Dolphine is 7.0.9.  My  Mysqld is version 5.1.3. My box Freebsd 7.4

I  commented  the line containing connect_timeout in the php file.

I did put connect_timeout = 10 (seconds)  in my.cnf, and restarted the mysqld daemon.

Now I get  only "Segmentation fault (core dumped)"  [sent by the cron]

I think it's a bug in the php file!

Seg fault is solved. Was PHP CLI problem. I upgraded PHP to  the latest (PHP 5.4.3). The problem was probably due to library mismatch. PHP 5.4.3 seems to work fine with Dolphin 7.0.9.

However the initial error sent by MYSQL still remains:

Line 51 at ..../public_html/flash/modules/global/inc/db.inc.php causes the follwoing error:

Warning: mysql_query(): Variable 'connect_timeout' is a GLOBAL variable and should be set with SET GLOBAL in /u1/www/morethan1fish/public_html/flash/modules/global/inc/db.inc.php on line 51.

Line 51 is:

mysql_query("SET  @@local.connect_timeout=9000;", $this->rLink);

I have commented this line and there are no other errors except Strict Standards notices generated by PHP.

Anyone else using 7.0.9 on FreeBSD? Any thoughts are appreciated!

 

Quote · 7 Jun 2012
 
 
Below is the legacy version of the Boonex site, maintained for Dolphin.Pro 7.x support.
The new Dolphin solution is powered by UNA Community Management System.