invalid SQL: Tag Search errors

[DefenceTalk]

Hi,

Just started getting this error on one of the forums:

Database error in vBulletin 3.7.1:

Invalid SQL:

SELECT tagsearch.tagid, tag.tagtext, COUNT(*) AS searchcount
FROM vb3tagsearch AS tagsearch
INNER JOIN vb3tag AS tag ON (tagsearch.tagid = tag.tagid)
WHERE tagsearch.dateline > 1210095195
GROUP BY tagsearch.tagid, tag.tagtext
ORDER BY searchcount DESC
LIMIT 70;

MySQL Error : MySQL server has gone away
Error Number : 2006
Request Date : Thursday, June 5th 2008 @ 12:33:15 PM
Error Date : Thursday, June 5th 2008 @ 12:34:25 PM
Script : http://www.domain.com/forums/login.php?do=login
Referrer : http://www.domain.com/forums/admincp/thread.php?do=tags
IP Address : 12.22.184.6
Username :
Classname : vB_Database
MySQL Version :
mySQL is running.

Whatsup?

Thanks

[Wayne Luke]

It means that MySQL closed the connection before your query was finished. Make sure that your wait_timeout is set to at least 120 seconds. You can find this under Maintenance -> Diagnostics -> System Information -> MySQL Variables.

If you do not have a dedicated server then you will need to petition your host to increase this value if it is less than 120 seconds. Most queries will not need this but some queries are "delayed" to increase performance and will be run at the end of the queue. This would affect them and can result in this error.

[DefenceTalk]

Thanks, that fixed the issue.