MySQL-Timout Error on PHPBB-User-Table import

[davadda]

Hi. I have a problem with the impex importer script of vbulletin.
If I try to import the users from my phpbb 2.x forum I'll get a white screen after some time and an email with this error message in it:


Database error in vBulletin 3.6.3:

Invalid SQL:

UPDATE vb_session
SET lastactivity = 1163423099, inforum = 0, inthread = 0, incalendar = 0, badlocation = 0
WHERE sessionhash = '2902cae79ef71bedd4a158cdeca63e49';

MySQL Error : Lost connection to MySQL server during query
Error Number : 2013
Date : Monday, November 13th 2006 @ 02:06:41 PM
Script : xxxx
Referrer : xxxx (http://skinsvb.boxt.de/admincp/index.php?do=nav)
IP Address : xxxx
Username :
Classname : vB_Database


We set the mysql timeout up to 2 hours. After this we'll now don't receive any email, but the import of the useres still crashes with an white screen and no error message.

Does any one have an idea what the problem could be? Thanks for your time.

[Steve Machol]

First try this. Edit newreply.php and add:

define('NOSHUTDOWNFUNC', 1);

after:

define('NOPMPOPUP', 1);

If that doesn't help, then this is a server issue. You need to contact your host about this. See this post for the possible causes of a lost connection error:

http://www.vbulletin.com/forum/showthread.php?s=&postid=310265#post310265