vb.org Archive - Database error

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

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

- - Database error (https://vborg.vbsupport.ru/showthread.php?t=242496)

darrenjdoc

05-14-2010 12:57 PM

Database error

Hi

I am receiving this error and i am not sure how to fix it

Quote:

Database error in vBulletin 4.0.2:

Invalid SQL:

SELECT *
FROM xt_style
WHERE (styleid = 21)
OR styleid = 21
ORDER BY styleid ASC
LIMIT 1;

MySQL Error : Unknown column 'styleid' in 'where clause'
Error Number : 1054
Request Date : Friday, May 14th 2010 @ 02:53:19 PM
Error Date : Friday, May 14th 2010 @ 02:53:19 PM
Script : http://www.rslocator.com/
Referrer :
IP Address : 93.97.246.187
Username : Doc
Classname : vB_Database_MySQLi
MySQL Version : 5.0.90-community-log

Anybody any idea ??

Thanks in advance

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

If i cant log onto the site how do i fix it ? Ftp ?

Lynne

05-14-2010 01:34 PM

You can try disabling your modifications/plugins and see if you still have this problem.
Note: To temporarily disable the plugin system, edit config.php and add this line right under <?php

PHP Code:


		
			
define('DISABLE_HOOKS', true);

I don't think that is going to do it though. There is no reason you should be missing that column in that table. Can you check that table and see what fields you have?

darrenjdoc

05-14-2010 01:46 PM

Thanks for your help.

You are right it didnt help.

I had a database error on Wednesday and i had to reupload the database from the previous day and reupload the site and it cured it then. But this morning this started.

I am a bit of a noob. How do you check that table ?

borbole

05-14-2010 01:57 PM

Quote:

Originally Posted by darrenjdoc (Post 2036934)

Go to phpmyadmin and run this query:

Code:

SHOW columns FROM style;

If your db tables have a prefix, include that in the query as well.

A table will be displayed with all the columns. Check it against the default structure for the style table and see what is missing and what not. Then readd manually the missing column and you should be all set.

All times are GMT. The time now is 04:42 PM.

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.03709 seconds Memory Usage 1,720KB 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_code_printable (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 (4)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: