justicechick
10-24-2013, 10:43 PM
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!
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!