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

My Version of Dolphine is 7.0.9.  My  Mysqld is version 5.1.60. My box is Freebsd 7.4

I just installed the 7.0.9 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).

I tried commentig  the line containing connect_timeout in the php file.

I  then 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]

It looks like a bug, maybe in mysqld or in te php file.  Should I upgrade mysql to 5.5?  What is the highest working version of mysql for Dolphin 7.0.9?

 Any help is appreciated.

 

 

Quote · 2 Jun 2012

Unfortunately I don't think there many people here with experience in Freebsd. In the past any time I've delt with seg faults and core dumps it was a problem with php itself or the actual hardware, but I have zero experience with Freebsd.

 

In the future it would be better to bump the first thread you posted instead of posting the same thing multiple times.

BoonEx Certified Host: Zarconia.net - Fully Supported Shared and Dedicated for Dolphin
Quote · 2 Jun 2012

Thank you for the report, ticket created:

http://www.boonex.com/trac/dolphin/ticket/2795

Rules → http://www.boonex.com/terms
Quote · 3 Jun 2012

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.