mysql error

[CarpCharacin]

i tried to access my TOS announcement and it said there was a mysql error. I do not know what to do. Here is a link to it: http://dudetalk.info/announcement.php?f=5

[ozzy47]

You should have got a email with the actual error, we would need that info to see what the issue is.

If not check your server error logs, if you don't know where those are, ask your host.

[CarpCharacin]

Here is what it said: I blocked out my ip address.

Database error in vBulletin 4.2.2:
Invalid SQL:
SELECT userid
FROM post
WHERE threadid = AND userid = 1;
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 userid = 1' at line 3
Error Number : 1064
Request Date : Monday, December 29th 2014 @ 06:22:21 AM
Error Date : Monday, December 29th 2014 @ 06:22:22 AM
Script : http://dudetalk.info/announcement.php?f=5
Referrer : https://vborg.vbsupport.ru/showthread.php?p=2529368
IP Address : ***.**.***.***
Username : CarpCharacin
Classname : vB_Database
MySQL Version : 5.5.40-cll

[ozzy47]

Ok lets do this, disable plugins via the includes/config.php file.

To do that open your includes/config.php file and below <?php add the following.

PHP Code:

define('DISABLE_HOOKS', true); 


So it looks like this:

PHP Code:

<?php
define('DISABLE_HOOKS', true);
/*=================================================  =====================*\
|| ##################################################  ################## ||
|| # vBulletin 4.2.2

Use a editor like notepad++ to edit any files, don't use Notepad or Wordpad.

If that fixes the issue enable plugins again by adding // before the line you added, then navigate to ACP --> Plugins & Products --> Manage Products and disable one mod at a time until you find the one causing the issue.

Once you find the culprit, post in that mods thread what the issue is, and maybe someone in that thread can help.

[kh99]

That's the query you were asking about, Ozzy, for your "moderate reported posts" mod, so if that's installed I'd start there.

[ozzy47]

I have a feeling it is that. But I don't know why, all the link is is to the announcement forum.

[CarpCharacin]

Originally Posted by ozzy47

I have a feeling it is that. But I don't know why, all the link is is to the announcement forum.

It was only showing the error when i clicked on my TOS announcement.

[ozzy47]

Yup, it's sorted now. I replied in the mod's thread.