vBulletin

Thank you for visiting. This is our website archive. Please visit our main website by clicking the banner above.
vBulletin FAQ is dedicated to helping the forum owner build, manage and profit from his vBulletin Forum
vBulletin Web Hosting - Free skins and styles for your vBulletin - Search Engine Optimization




vBulletin Database Errors:

NickT'sGTP
01-23-2007, 08:08 PM
I don't know what the hell all this means, can someone enlighten me?

Database error in vBulletin 3.6.4:

Invalid SQL:

SELECT thread.threadid, thread.title, thread.lastpost,
thread.forumid, thread.replycount, thread.lastposter, thread.dateline,
thread.iconid, IF(views<=replycount, replycount+1, views) AS views,
thread.visible, user.username, user.userid, user.usergroupid, IF(displaygroupid=0,
user.usergroupid, displaygroupid) AS displaygroupid
FROM thread AS thread LEFT JOIN user AS user ON (user.username =
thread.lastposter) WHERE NOT ISNULL(thread.threadid) AND
thread.visible!=0 AND thread.forumid NOT IN (0,31,)
ORDER BY lastpost DESC LIMIT 0, 5;

MySQL Error : You have an error in your SQL syntax; check the manual
that corresponds to your MySQL server version for the right syntax to
use near ')
ORDER BY lastpost DESC LIMIT 0, 5' at line 2
Error Number : 1064
Date : Tuesday, January 23rd 2007 @ 04:52:58 PM
Script : http://www.iawbody.com/forum/forumdisplay.php?f=10
Referrer :
IP Address : 74.6.70.82
Username : Unregistered
Classname : vb_database


And this one:

Database error in vBulletin :

Invalid SQL:
SELECT varname, value, datatype FROM setting;

MySQL Error : Can't connect to MySQL server on 'mysql.iawbody.com' (4)
Error Number : 2003
Date : Tuesday, January 23rd 2007 @ 08:42:55 PM
Script : http://iawbody.com/forum/showthread.php?p=2734
Referrer :
IP Address : 74.6.71.162
Username :
Classname : vb_database


Mmmm....kay..... :confused:

Mark Bolyard
01-23-2007, 08:53 PM
Seems to me your MYSQL server was getting ready to fail on the first error, and on the second error, it had already failed. Try restarting your MYSQL, or rebooting your server... or if you are on Shared Hosting, see if you can log into cpanel, view the status of your services, and if any are failing, report it to your host.

Joeychgo
01-23-2007, 09:13 PM
Syntax errors like this are usually caused by custom code. Try uploading the original PHP files for your version. Also try disabling your plugins, especially the last one(s) you ahve installed. Does the problem go away? If so, then you can begin to troubleshoot any custom code that you want to keep.


vBulletin

seo book

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35

EZ Archive Ads Plugin for vBulletin Copyright 2006 Computer Help Forum