|| 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.


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?

[org knopper]

I have installed 3.7.3 n it was fine till now but after i changed hosts this has been a problem.

[Lynne]

Redownload the 3.7.3 vbulletin files and reupload the function_prefix.php file from that package. If you continue to get the error, then I'm guessing you installed a mod for 3.8 that has that query in it and that is causing the problem. You will have to go through your mods and see which one is making that query.