[AndrewD]

Originally Posted by tekguru

Hi guys, yesterday I upgraded to the RC 2.29 version with vB 3.6.10 to get around the security token issue.

Two days prior to this the server the site runs on was ugraded (with no issues) to MySQL 5.0.45.

Since these two changes I'm seeing:

1) MySQL errors:

PHP Code:

Database error in vBulletin 3.6.10:

Invalid SQL:

                                        UPDATE vb_session
                                        SET lastactivity = 1209614372, location = '/forums/local_links.php?action=jump&id=164&catid=8', useragent = 'Mozilla/4.0 (compatible; MSIE 7.0; Windows NT 6.0; SU 3.011; SLCC1; .NET CLR 2.0.50727; Media Center PC 5.0; .NET CLR 3.0.04506; InfoPath.2; Zune 2.0; .NET CLR 3.5.21022)'
                                        WHERE sessionhash = '65f940813662b64ba0952843a5cfddd9';

MySQL Error  : MySQL server has gone away Error Number : 2006
Date         : Thursday, May 1st 2008 @ 05:00:38 AM
Script       : http://www.4winmobile.com/forums/local_links.php?action=jump&id=164&catid=8
Referrer     : http://www.4winmobile.com/forums/phone-edition-general/14865-slide2unlock-better-than-default-windows-screen-lock-customisable-too.html
IP Address   : 24.17.203.240
Username     : esamos
Classname    : vB_Database 


I'm not seeing any similar errors from any other part of the system.

These'a similar report on vb.com:
http://www.vbulletin.com/forum/showt...46#post1547346

They suggest increasing the mySql wait_timeout setting, which controls how long the database connection stays open for a script. This would make sense with LDM - the sql that you report is executed right at the end of vbulletin page generation. Particularly if someone has just done a download, then the database connection might have closed down in the meantime.

Originally Posted by tekguru

Also if I try and use the FORUMHOME patches to display the top downloads I get a error on line 20 of the code and the page will not load. Is this because I'm running 3.6.10? I've taken the steps obn removing all addins, and them overwriting the Mod and readding with no changes to the issue. So for the moment we're having to run without these.

Any ideas on either?

I'll test this and post a reply when possible.