Help with a database error please

[justicechick]

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!

[ozzy47]

I would start by disabling your mods one by one, till you no longer see the error, then you will know which mod it is.

[ForceHSS]

at anytime did you edit your functions_databuild.php long shot but need to ask

[justicechick]

Originally Posted by ozzy47

I would start by disabling your mods one by one, till you no longer see the error, then you will know which mod it is.

Ozzy the first thing I did was to disable them all in my config.php. So they are off and the board is fine as long as they are off it appears. Just cant turn the hooks back on until its fixed....I am gonna re-enable them in config now and do one by one in the admincp now.

Force I didnt intentionally on my own, no but I had accidentally attempted to install this mod https://vborg.vbsupport.ru/showthrea...read+filtering (thinking it was another that I had downloaded earlier) and that was when the problem started so I figure that there are Db changes.

Ughhhh I feel so stupid doing this!

--------------- Added [DATE]1382661521[/DATE] at [TIME]1382661521[/TIME] ---------------

Originally Posted by ozzy47

I would start by disabling your mods one by one, till you no longer see the error, then you will know which mod it is.

I removed the suspect modification from my admincp then moved the files off the server so Idk.

[ozzy47]

Stuff happens sometimes, if you find out which mod it is, let us know.

[ForceHSS]

That mod https://vborg.vbsupport.ru/showthrea...read+filtering does not have the above info don't seeing it being this one but if removing it helps

[Max Taxable]

Is it possible you installed it, then uninstalled and the changes to the DB stayed, along with the template modifications?

Mod says it does the following:

DB Changes
Auto-Template
Code Changes

[justicechick]

Originally Posted by ForceHSS

That mod https://vborg.vbsupport.ru/showthrea...read+filtering does not have the above info don't seeing it being this one but if removing it helps

Thanks Forcee . The Only other one that I have attempted was https://vborg.vbsupport.ru/showthrea...thread+listing one. I it did nothing at all so I uninstalled it.

--------------- Added [DATE]1382663812[/DATE] at [TIME]1382663812[/TIME] ---------------

Originally Posted by Max Taxable

Is it possible you installed it, then uninstalled and the changes to the DB stayed, along with the template modifications?

Mod says it does the following:

DB Changes
Auto-Template
Code Changes

Ive been banging around in the database now for four hrs going through tables and things. I dont see it nor do I see the any of the data (AND user.userid NOT IN (5","6)
WHERE post.dateline > 1382567113 (this should identify that post in the table, but then what do I know! LOL) Im just taking a shot in the dark here .
GROUP BY post.userid
ORDER BY postcount DESC
LIMIT 3; Its possible I can miss anything ..

[Max Taxable]

Did the errors start after you uninstalled the Mod?

[justicechick]

Originally Posted by Max Taxable

Did the errors start after you uninstalled the Mod?

I suppose you could say that . It was really weird. I havent had a mod act that way thus far on me. I have had then cause a DB error when I first started doing this but it was bc I uninstalled the server side I think before I did the admincp side. This time everything was fine for a bit after I uninstalled it.

--------------- Added [DATE]1382720939[/DATE] at [TIME]1382720939[/TIME] ---------------

This has been resolved. I ended up reloading all the orginal vb files then turning my plugins back on one by one and it is resolved is seems. Thanks for the help.