-
Database Error
Code:
Database error in vBulletin 3.7.3:
Invalid SQL:
SELECT thread.threadid
FROM thread AS thread
LEFT JOIN forum AS forum ON (forum.forumid = thread.forumid)
LEFT JOIN vault_link AS link ON (link.postid = thread.firstpostid)
WHERE forum.vault_type > 0
AND link.redirect = 1
WHERE thread.forumid IN(95, 96, 15, 35, 19, 30, 33, 69, 71, 78, 1, 53, 40, 41, 44, 58, 59, 84, 60, 67, 72, 73, 4, 20, 49, 43, 47, 51, 2, 31, 28, 65, 93, 3, 18, 17, 26, 27, 39, 61, 68, 70, 5, 29, 75, 76, 77, 11, 24, 25, 46, 10, 34, 52, 62, 74, 82, 12, 54, 55, 56, 94, 6, 21, 22, 23, 38, 63, 85, 8, 37, 9, 32, 36, 13, 86, 87, 88, 89, 90, 91, 92, 64, 14, 66, 16, 79, 80, 81, 83)
AND thread.visible IN (0,1,2)
AND thread.sticky IN (0,1)
AND thread.open <> 10
ORDER BY thread.lastpost DESC
LIMIT 500;
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 'WHERE thread.forumid IN(95, 96, 15, 35, 19, 30, 33, 69, 71, 78, 1, 53, 40, 41, 4' at line 7
Error Number : 1064
Request Date : Wednesday, November 5th 2008 @ 06:03:41 PM
Error Date : Wednesday, November 5th 2008 @ 06:03:41 PM
Script : http://steelsoldiers.com/search.php?do=getdaily
Referrer : http://steelsoldiers.com/showthread.php?t=25178
IP Address : 75.199.15.117
Username : Unregistered
Classname : vB_Database
MySQL Version :
Why am I getting these? It started as soon as I installed the Wiki.... Goes away if I uninstall it.
I am getting several dozen an hour!!
-
ooh ooh... I know how to trigger it!!!
Using the 'new posts' link in the navbar....
-
-
Ok, that fixed that one.... but now I have found another
Code:
Database error in vBulletin 3.7.3:
Invalid SQL:
SELECT
post.*, post.username AS postusername, post.ipaddress AS ip, IF(post.visible = 2, 1, 0) AS isdeleted,
user.*, userfield.*, usertextfield.*,
avatar.avatarpath, NOT ISNULL(customavatar.userid) AS hascustomavatar, customavatar.dateline AS avatardateline,customavatar.width AS avwidth,customavatar.height AS avheight,
editlog.userid AS edit_userid, editlog.username AS edit_username, editlog.dateline AS edit_dateline,
editlog.reason AS edit_reason, editlog.hashistory,
postparsed.pagetext_html, postparsed.hasimages,
sigparsed.signatureparsed, sigparsed.hasimages AS sighasimages,
sigpic.userid AS sigpic, sigpic.dateline AS sigpicdateline, sigpic.width AS sigpicwidth, sigpic.height AS sigpicheight,
IF(displaygroupid=0, user.usergroupid, displaygroupid) AS displaygroupid, infractiongroupid
FROM post AS post
LEFT JOIN user AS user ON(user.userid = post.userid)
LEFT JOIN userfield AS userfield ON(userfield.userid = user.userid)
LEFT JOIN usertextfield AS usertextfield ON(usertextfield.userid = user.userid)
LEFT JOIN avatar AS avatar ON(avatar.avatarid = user.avatarid) LEFT JOIN customavatar AS customavatar ON(customavatar.userid = user.userid)
LEFT JOIN editlog AS editlog ON(editlog.postid = post.postid)
LEFT JOIN postparsed AS postparsed ON(postparsed.postid = post.postid AND postparsed.styleid = 2 AND postparsed.languageid = 1)
LEFT JOIN sigparsed AS sigparsed ON(sigparsed.userid = user.userid AND sigparsed.styleid = 2 AND sigparsed.languageid = 1)
LEFT JOIN sigpic AS sigpic ON(sigpic.userid = post.userid)
WHERE post.threadid = AND post.dateline > 1225913214 AND (post.visible = 1 OR post.postid = 285467)
ORDER BY dateline;
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 'AND post.dateline > 1225913214 AND (post.visible = 1 OR post.postid = 285467)
' at line 27
Error Number : 1064
Request Date : Wednesday, November 5th 2008 @ 10:26:17 PM
Error Date : Wednesday, November 5th 2008 @ 10:26:18 PM
Script : http://www.steelsoldiers.com/newreply.php?do=postreply&t=27330
Referrer : http://www.steelsoldiers.com/showthread.php?t=27330
IP Address : 75.71.164.146
Username : Crash_AF
Classname : vB_Database
MySQL Version :
-
-
Quote:
Originally Posted by
pegasus
This one can be ignored.
No fix for it? Its really annoying in my inbox, and makes it hard to determine between real errors, and these. I am new to VB and still getting things up and going, so I toss errors alot!
:-)