View Full Version : 'Lost connection to MySQL server' when uploading images (bulkupload.php,PP 4.8d)
January 30th, 2007, 10:52 AM
Our users are getting problems when uploading images to the gallery, getting various errors on different queries, all 'Lost connection to MySQL server during query'.
We've recently split to two servers, one database and one web, on a local 'network'. MySQL uptime is a couple of weeks, so it's not crashing, and it's not happening anywhere else on the site, only when uploading images, and interestingly at the moment they SEEM to always be related to the user database. Browsing, etc, is fine.
January 30th, 2007, 11:12 AM
Have you ensured you are using all the correct mysql information in the config especially the user database portion?
The error you are describing is one where mysql on the external server can not be connected to which means it is busy or down usually.
January 30th, 2007, 11:25 AM
Yep, it's all filled in right, and everything else still works.
It's only happening in this one place, very strange...
January 30th, 2007, 12:36 PM
MySQL error reported!
Query: SELECT userid,username,email,password,usergroupid,timezon eoffset,salt,membergroupids FROM user WHERE userid='14121'
Result: Lost connection to MySQL server during query
Database handle: Resource id #9
January 30th, 2007, 01:13 PM
Would you be able to look at this if i sent you some more details? What details do you need?
January 30th, 2007, 02:24 PM
There is not much I can do with an error like this
Lost connection to MySQL server during query
This tells me hands down the connection to mysql is being dropped as in the mysql server is going down. This is a server issue. As long as your user database info is correct as it is entered in your vb config file so should it be entered in our config thats all I can really respond to on this. For any real server issues like this you would need to contact your host and ask them what is up with why your mysql is loosing connection
vBulletin® v3.8.1, Copyright ©2000-2014, Jelsoft Enterprises Ltd.