The Arcive of Official vBulletin Modifications Site.It is not a VB3 engine, just a parsed copy! |
|
|
#1
|
|||
|
|||
Help with a database error please
When I click on my forum page I get a database error that read.
Database error in vBulletin 4.2.1 Invalid SQL: SELECT COUNT(post.dateline) AS postcount, post.userid, user.userid, user.username, user.lastpostid, user.posts, user.usergroupid, IF(displaygroupid=0, usergroupid, displaygroupid) AS displaygroupid, NOT ISNULL(customprofilepic.userid) AS haspic, customprofilepic.width, customprofilepic.height FROM post AS post LEFT JOIN user AS user ON (post.userid = user.userid) LEFT JOIN customprofilepic AS customprofilepic ON (customprofilepic.userid = user.userid) AND user.userid NOT IN (5","6) WHERE post.dateline > 1382567113 GROUP BY post.userid ORDER BY postcount DESC LIMIT 3; 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 '","6) WHERE post.dateline > 1382567113 GROUP BY post.userid ORDER BY post' at line 10 Error Number : 1064 Request Date : Thursday, October 24th 2013 @ 05:25:13 PM Error Date : Thursday, October 24th 2013 @ 05:25:13 PM Script : http://cafe-flirt.com/forum.php?tabid=11 Referrer : http://cafe-flirt.com/forum.php?tabid=11 IP Address : 68.179.255.156 Username : Babygirl Classname : vB_Database MySQL Version : 5.5.23-55 I'm pretty sure that it was a bad modification but I have to knowledge of the syntax if speaks of. Any help you can give is appreciated . Thanks in advance! |
|
|
X vBulletin 3.8.12 by vBS Debug Information | |
---|---|
|
|
More Information | |
Template Usage:
Phrase Groups Available:
|
Included Files:
Hooks Called:
|