PDA

View Full Version : mysql error


leejohn02
31 Aug 2011, 03:02
when i try to edit 1 post and add it to the one above i get this error, its only when i post this thread too

mysql error

Database error in vBulletin 4.1.5:

Invalid SQL:

(SELECT permissions, permissions2, FIND_IN_SET(forumid, '101,5,-1') AS pos, forumid
FROM moderator
WHERE userid = 1 AND forumid IN (101,5,-1)
ORDER BY pos ASC
LIMIT 1)
UNION
(SELECT permissions, permissions2, 0, forumid
FROM moderator
WHERE userid = 1 AND forumid = -1
);

MySQL Error : MySQL server has gone away
Error Number : 2006
Request Date : Wednesday, August 31st 2011 @ 01:59:33 AM
Error Date : Wednesday, August 31st 2011 @ 02:00:04 AM
Script : http://www.pureglitching.com/newthread.php?do=postthread&f=101
Referrer : http://www.pureglitching.com/newthread.php?do=newthread&f=101
IP Address : 86.21.216.84
Username : Glitch_Guru
Classname : vB_Database
MySQL Version :


thread
http://www.pureglitching.com/showthread.php?2022-Item-Config-Setup-Tutorial&p=11597#post11597

can someone please help, cheers

BSMedia
31 Aug 2011, 03:44
Mysql server has gone away errors are usually the result of hosting.

Contact your hosting companies if you are getting the error a lot, or move hosts.

leejohn02
31 Aug 2011, 03:50
i am on a dedicated server, does that mean its something i have to do, im using WHM panel

update removed some of the bb codes within the post and was able to merg them fine, is there a set bb code allowance and if so how do i increase it

Lynne
31 Aug 2011, 18:07
No, there is no set bbcode allowance. That error is a server error and you can modify your server settings so you no longer get that error doing the same action. Probably the wait_timeout mysql value.

See this: https://www.vbulletin.com/docs/html/troubleshoot_mysql_goneaway and this: https://www.vbulletin.com/forum/showthread.php?s=&postid=310265#post310265