'Lost connection to MySQL server' when uploading images (bulkupload.php,PP 4.8d)

[thirty6degrees]

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.

Any ideas?

Thanks,

Ollie
BirdForum

[Chuck S]

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.

[thirty6degrees]

Yep, it's all filled in right, and everything else still works.

It's only happening in this one place, very strange...

[thirty6degrees]

Example error:


MySQL error reported!

Script: bulkupload

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

[thirty6degrees]

Would you be able to look at this if i sent you some more details? What details do you need?

[Chuck S]

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