Yes we just suddenly started to receive database errors on our forums when we click on UserCp it goes straight to a database error. I don't know how long it has been going on, it only emails errors when someone clicks on their UserCP so we need some help please.
Here is the error code....
Database error in vBulletin 3.8.7:
Invalid SQL:
SELECT user.username, quote.*, post.threadid, thread.title
FROM quotedatanew As quote
LEFT JOIN post AS post ON(quote.postid = post.postid)
LEFT JOIN thread AS thread ON(post.threadid = thread.threadid)
LEFT JOIN user AS user ON(user.userid = quote.quoter)
WHERE quote.quoted = '82' ORDER BY quote.dateline DESC LIMIT;
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 '' at line 6
Error Number : 1064
Request Date : Tuesday, April 24th 2012 @ 02:47:12 PM
Error Date : Tuesday, April 24th 2012 @ 02:47:12 PM
Script : http://www.justfortodaymeditations.c...ums/usercp.php
Referrer : http://www.justfortodaymeditations.com/forums/
IP Address : 66.231.113.236
Username : cudmolinski
Classname : vB_Database
MySQL Version :
Here is the error code....
Database error in vBulletin 3.8.7:
Invalid SQL:
SELECT user.username, quote.*, post.threadid, thread.title
FROM quotedatanew As quote
LEFT JOIN post AS post ON(quote.postid = post.postid)
LEFT JOIN thread AS thread ON(post.threadid = thread.threadid)
LEFT JOIN user AS user ON(user.userid = quote.quoter)
WHERE quote.quoted = '82' ORDER BY quote.dateline DESC LIMIT;
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 '' at line 6
Error Number : 1064
Request Date : Tuesday, April 24th 2012 @ 02:47:12 PM
Error Date : Tuesday, April 24th 2012 @ 02:47:12 PM
Script : http://www.justfortodaymeditations.c...ums/usercp.php
Referrer : http://www.justfortodaymeditations.com/forums/
IP Address : 66.231.113.236
Username : cudmolinski
Classname : vB_Database
MySQL Version :
Comment