vb.org Archive - Error 1146 | Table Does Not Exist Problems

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

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

- - Error 1146 | Table Does Not Exist Problems (https://vborg.vbsupport.ru/showthread.php?t=277210)

topianno

01-18-2012 02:23 PM

Error 1146 | Table Does Not Exist Problems

First off, my forum is down. I am running version 4.0.4.

The error messages I am receiving are Error Number 1146, stating that the table doesn't exist. I've noticed this message comes up for several tables.

Does anyone know how to resolve this? I need to get this forum back up ASAP.

Below is an example of one of the error messages...

Code:

Database error in vBulletin 4.0.4:



Invalid SQL:



                                SELECT *

                                FROM session

                                WHERE userid = 0

                                        AND host = '87.118.135.65'

                                        AND idhash = 'c0906fc6d5e4cf4cf8500a487876e945'

                                LIMIT 1;



MySQL Error   : Table 'drkurifo_forum1.session' doesn't exist

Error Number  : 1146

Request Date  : Wednesday, January 18th 2012 @ 10:10:19 AM

Error Date    : Wednesday, January 18th 2012 @ 10:10:19 AM

Script        : http://forum.lapbandsurgery.com/forum.php

Referrer      : 

IP Address    : 87.118.135.65

Username      : 

Classname     : vB_Database

MySQL Version :

kh99	01-18-2012 02:29 PM

Have you made any changes to the site? If you've edited your config.php file you probably want to check and make sure it still has valid database info (although you are obviously connecting to *some* database).

If it's just the session table missing, you could recreate it using myphpadmin or whatever other program you use to access your database. If you have a copy of the vb source you can look in install/mysql-schema.php to see the command used to create it (I'd look myself but I don't have source for that version and I don't know if it's changed).

If there are tables missing other than session then you'd probably have to restore a backup.

Lynne

01-18-2012 04:20 PM

Did you touch your config.php file recently? Maybe you have the wrong table prefix in there.

All times are GMT. The time now is 03:50 PM.

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