vBulletin Database Error!

[Arashdn]

Hello
I have alot of mails in my inbox from my forum they says:

Database error in vBulletin 3.8.1: Invalid SQL: SELECT user.*, ufield.*, subscribethread.emailupdate, subscribethread.subscribethreadid FROM subscribethread AS subscribethread INNER JOIN user AS user ON (subscribethread.userid = user.userid) INNER JOIN userfield AS ufield ON (ufield.userid = user.userid) LEFT JOIN usergroup AS usergroup ON (usergroup.usergroupid = user.usergroupid) LEFT JOIN usertextfield AS usertextfield ON (usertextfield.userid = user.userid) WHERE subscribethread.threadid = 1591 AND subscribethread.emailupdate IN (1, 4) AND subscribethread.canview = 1 AND CONCAT(' ', IF(usertextfield.ignorelist IS NULL, '', usertextfield.ignorelist), ' ') NOT LIKE '% 3 %' AND user.usergroupid <> 3 AND ufield.field20 <> '' AND (usergroup.genericoptions & 32); MySQL Error : Unknown column 'ufield.field20' in 'where clause' Error Number : 1054 Request Date : Thursday, July 9th 2009 @ 07:46:34 PM Error Date : Thursday, July 9th 2009 @ 07:46:34 PM Script : http://www.parseforum.com/newreply.p...streply&t=1591 Referrer : http://www.parseforum.com/newreply.p...quote=1&p=7786 IP Address : 78.38.15.2 Username : Tohid Classname : vB_Database MySQL Version :

I`m using vb 3.8.1 pl 1 on a VPS with php 5.2.10 and MySQL 5.0.67
what should I do?

[Dismounted]

This is most likely caused by a modification. Try posting a new post (not Quick Reply), and you should see the error, correct?

Disable all your modifications by placing this line at the end of your config.php. The problem should disappear.

PHP Code:

define('DISABLE_HOOKS', true); 


[Arashdn]

Do it disable Plugins & Products I have installed?

[wolfstream]

Originally Posted by Arashdn

Do it disable Plugins & Products I have installed?

Yes, the above will do this, and in this case it is the best way to start debugging your issue

[Arashdn]

But i have many plugins and i can`t disable them

[Pokerbanter]

In that case you'll just need to live with the database errors then.

Have the same problem myself and i'm having to do it.

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

I get this error message:

Internal Server Error, this is an error with your script, check your error log for more information.

Where do I find the error log it speaks of?

[Lynne]

The error_logs on my server are in a directory called /logs. However, the host could have put them anywhere so if you can't find them, you should ask your host where they are.