Database errors after upgrade to 4.2.1

[trailerswanted]

We have ran the upgrade script twice... increased connection time... and these continue to poor in. Can anyone advise how to fix?

Database error in vBulletin 4.2.1: Invalid SQL: SELECT * FROM style WHERE (styleid = 10 AND userselect = 1) OR styleid = 10 ORDER BY styleid ASC LIMIT 1; MySQL Error : MySQL server has gone away Error Number : 2006

[Wayne Luke]

This isn't a connection time issue. What is the wait_timeout on MySQL? It should be at least 120 seconds. Though the query above should be quick and easy to complete. There may be some other underlying issue as well. What version of MySQL are you using? Is your config.php set to use mysql or mysqli? Do you have query logging turned on? As that might give more information.

However when I visit your site, I don't encounter and error and it is up and running. This could have been simply errors created during the upgrade process.

[trailerswanted]

Hey Wayne... I get a number of these every day.

Server Type	Linux	Users to Moderate
Web Server	Apache	Threads to Moderate
PHP	5.2.10	Posts to Moderate
PHP Max Post Size	200.00 MB	Attachments to Moderate
PHP Maximum Upload Size	10.00 MB	Events to
PHP Memory Limit	300.00 MB	Number of Queued E-Mails
MySQL Version	5.0.96-community
MySQL Packet Size	512.00 MB

[trailerswanted]

Wayne... any other ideas on this issue?

[Wayne Luke]

Sorry... When you get the errors, what is the server load like? If it is a busy server and MySQL is overloaded, it can trigger these errors. The error basically means that MySQL closed the connection without returning any results.