|| SQL error ||

[org knopper]

Does any 1 have any idea ?

Invalid SQL:

SELECT prefix.*, prefixpermission.usergroupid AS restriction
FROM forumprefixset AS forumprefixset
INNER JOIN prefixset AS prefixset ON (prefixset.prefixsetid = forumprefixset.prefixsetid)
INNER JOIN prefix AS prefix ON (prefix.prefixsetid = prefixset.prefixsetid)
LEFT JOIN prefixpermission AS prefixpermission ON (prefix.prefixid = prefixpermission.prefixid)
WHERE forumprefixset.forumid = 23
ORDER BY prefixset.displayorder, prefix.displayorder;

TYIA.

[Lynne]

That is not the full error. There should be some stuff below that that will give us the full error.

[org knopper]

Heres the error below -

MySQL Error : Table 'databaseid.prefixpermission' doesn't exist
Error Number : 1146
Request Date : Friday, May 29th 2009 @ 12:07:58 PM
Error Date : Friday, May 29th 2009 @ 12:07:59 PM
Script : http://anyforum.com/newthread.php?do=newthread&f=17
Referrer : http://anyforum.com/forumdisplay.php?f=17
IP Address : **********
Username : username
Classname : vB_Database
MySQL Version : 5.0.77-community

[cono1717]

Add this to the end of your config.php and see if it happens again.

PHP Code:

define('DISABLE_HOOKS', true); 


If it doesn't it is a mod causing the error. Post the mods you have installed here.

[org knopper]

thanks mod was making some error i disabled it 1 error is gone but the above posted error still exists.

[Lynne]

At the top of your error, doesn't it say what vb version it thinks you are running? And when you last upgraded, did you run the upgrade.php script?

[org knopper]

YEs it does say

Database error in vBulletin 3.7.3:

n i did run the upgrade.php script.

Edit - Error comes up only when i try to click on button "new thread"

[Lynne]

That query is from the function fetch_prefix_array in the function_prefix.php file for version 3.8.0. The table prefixpermission as not in that query for vb 3.7.3. So, it seems you either have a modification using a 3.8.0 query or a file that is for 3.8.0.

[org knopper]

How do i fix it ?

[Lynne]

Well, it looks to me like you are running a 3.8.0 page with a 3.7.3 database. What version of vbulletin do you think you have installed?