PDA

View Full Version : database error message


geevest.com
10-17-2008, 03:35 PM
i get this database error message from my mail :

Database error in vBulletin 3.7.3:

Invalid SQL:

SELECT
user.username, (user.options & 512) AS invisible, user.usergroupid,
session.userid, session.inforum, session.lastactivity,
IF(displaygroupid=0, user.usergroupid, displaygroupid) AS displaygroupid, infractiongroupid
, user.op_markup
FROM session AS session
LEFT JOIN user AS user ON(user.userid = session.userid)

WHERE session.lastactivity > 1224259053

ORDER BY username ASC;

MySQL Error : MySQL server has gone away
Error Number : 2006
Request Date : Friday, October 17th 2008 @ 12:30:53 PM
Error Date : Friday, October 17th 2008 @ 12:32:01 PM
Script : http://www.mysitename/forum/
Referrer : http://mysitename/forum/login.php?do=login
IP Address : 125.162.67.127
Username : Unregistered
Classname : vB_Database
MySQL Version :


Database error in vBulletin 3.7.3:

Invalid SQL:

SELECT *
FROM thread AS thread
LEFT JOIN force_read_users AS force_read_users ON (thread.threadid = force_read_users.force_read_threadid AND force_read_users.force_read_userid = '47133')
WHERE thread.force_read = '1' AND (thread.force_read_expire_date = '0' OR thread.force_read_expire_date > '1224261119') AND (force_read_usergroups = '' OR force_read_usergroups LIKE '%-2-%') AND (force_read_forums = '') AND force_read_users.force_read_userid IS NULL
ORDER BY force_read_order ASC;

MySQL Error : MySQL server has gone away
Error Number : 2006
Request Date : Friday, October 17th 2008 @ 12:31:59 PM
Error Date : Friday, October 17th 2008 @ 12:33:20 PM
Script : http://mysitename/forum/index.php
Referrer : http://mysitename/forum/showthread.php?t=13815
IP Address : 118.137.70.7
Username : ming2
Classname : vB_Database
MySQL Version :


how i can fixed this? thx

Lynne
10-17-2008, 03:46 PM
This is a server issue. See this: http://www.vbulletin.com/docs/html/troubleshoot_mysql_goneaway and this:
http://www.vbulletin.com/forum/showthread.php?s=&postid=310265#post310265