vb.org Archive - Last database error!

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

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

- - Last database error! (https://vborg.vbsupport.ru/showthread.php?t=218522)

aceofspades

07-13-2009 06:46 PM

Last database error!

Hi,

I fixed one database error with your help, now I have one final one I need help with.

Quote:

Database error in vBulletin 3.6.2:

Invalid SQL:

SELECT * FROM search AS search
WHERE searchhash = '65d871b7f803198613f55ec884d81e6e'
AND userid = 1
AND completed = 1;

MySQL Error : Unknown column 'completed' in 'where clause'
Error Number : 1054
Date : Monday, July 13th 2009 @ 08:42:50 PM
Script : http://xxx/forums/search.php?do=process
Referrer : http://xxx/forums/search.php
IP Address : xxx
Username : xxx
Classname : vB_Database

Can anyone help me to understand why this is happening? I was able to fix the last database error by running a query found on this forum that created a missing table. Can i do the same with this one?

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

Tiny bump :confused:

Marco van Herwaarden

07-14-2009 12:49 PM

What caused these tablews to be missing or incomplete? You should address the source of the issue and not repair individual symptoms.

All times are GMT. The time now is 11:12 AM.

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.01044 seconds Memory Usage 1,710KB 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_quote_printable (1)footer (1)gobutton (1)header (1)headinclude (6)option (1)post_thanks_navbar_search (1)printthread (2)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: