vb.org Archive - || SQL error ||

vb.org Archive (https://vborg.vbsupport.ru/index.php)

- vB3 General Discussions (https://vborg.vbsupport.ru/forumdisplay.php?f=111)

- - || SQL error || (https://vborg.vbsupport.ru/showthread.php?t=214847)

org knopper

05-29-2009 03:05 PM

|| SQL error ||

Does any 1 have any idea ?

Quote:

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

05-29-2009 03:48 PM

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

org knopper

05-29-2009 04:09 PM

Heres the error below -

Quote:

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

05-29-2009 05:02 PM

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

05-29-2009 05:23 PM

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

Lynne

05-29-2009 05:23 PM

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

05-29-2009 06:00 PM

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

05-29-2009 07:52 PM

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

05-30-2009 10:14 AM

How do i fix it ?

Lynne

05-30-2009 04:08 PM

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

05-30-2009 09:15 PM

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

Lynne

05-30-2009 09:24 PM

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.

All times are GMT. The time now is 06:11 PM.

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.01135 seconds Memory Usage 1,733KB Queries Executed 10 (?)
More Information
Template Usage: (1)ad_footer_end (1)ad_footer_start (1)ad_header_end (1)ad_header_logo (1)ad_navbar_below (1)bbcode_php_printable (2)bbcode_quote_printable (1)footer (1)gobutton (1)header (1)headinclude (6)option (1)post_thanks_navbar_search (1)printthread (12)printthreadbit (1)spacer_close (1)spacer_open Phrase Groups Available: global postbit showthread	Included Files: ./printthread.php ./global.php ./includes/init.php ./includes/class_core.php ./includes/config.php ./includes/functions.php ./includes/class_hook.php ./includes/modsystem_functions.php ./includes/class_bbcode_alt.php ./includes/class_bbcode.php ./includes/functions_bigthree.php Hooks Called: init_startup init_startup_session_setup_start init_startup_session_setup_complete cache_permissions fetch_threadinfo_query fetch_threadinfo fetch_foruminfo style_fetch cache_templates global_start parse_templates global_setup_complete printthread_start bbcode_fetch_tags bbcode_create bbcode_parse_start bbcode_parse_complete_precache bbcode_parse_complete printthread_post printthread_complete
Messages: