MySQL Error : Lost connection to MySQL server during query

[TruthElixirX]

Database error in vBulletin 3.8.4:

Invalid SQL:
SELECT p.*,a.albumid,u.username FROM vbpicture p
LEFT JOIN vbalbumpicture a ON (a.pictureid=p.pictureid)
LEFT JOIN vbuser u ON (u.userid=p.userid);

MySQL Error : Lost connection to MySQL server during query
Error Number : 2013
Request Date : Saturday, March 13th 2010 @ 01:30:13 PM
Error Date : Saturday, March 13th 2010 @ 01:30:17 PM
Script : Log in - Ford Truck Club Forum - vBulletin Admin Control Panel
Referrer : Log in - Ford Truck Club Forum - vBulletin Admin Control Panel
IP Address : 68.97.160.247
Username : TheAmplified42
Classname : vB_Database
MySQL Version :

Is there any fix for this?

[Chuck S]

That error points you to your mysql server going down.

Have you tried rerunning the script

[TruthElixirX]

Originally Posted by Chuck S

That error points you to your mysql server going down.

Have you tried rerunning the script

Several times. I tried contacting hosting to see if they had some thing in place to stop a script from executing for too long, the guy I got had no idea what I was talking about.

[Chuck S]

Well lets do a quick search on the internet.

MySQL :: MySQL 3.23, 4.0, 4.1 Reference Manual :: A.5.2.3 Lost connection to MySQL server

These point to server issues with mysql setup

[TruthElixirX]

Originally Posted by Chuck S

Well lets do a quick search on the internet.

MySQL :: MySQL 3.23, 4.0, 4.1 Reference Manual :: A.5.2.3 Lost connection to MySQL server

These point to server issues with mysql setup

We figured as much. Is there any alternative to the default import script?

[Chuck S]

No the import script is what imports the actual images. You might need to contact your web host for a solution since they control the server stuff.

[Luciano]

Have you tried to run the import script AFTER having moved all attachments to the file system? because IF you have many very large images in the database they would all be loaded into memory.
Just a thought...
Luc

[Chuck S]

HMM thats a good one Luc did not think about the database images thing yuck. I hate that vb allows you to do that so inefficient.

[TruthElixirX]

That hadn't even occurred to me. Trying this now.

[Chuck S]

Yes that would be the third thing on that mysql lost the big blob field thing