Database error

Status
Not open for further replies.
T

the fanopsis

New Member
i receive this mail every seconde in my mail box about a database error :

Code: 
Database error in vBulletin 3.7.3:
 
Invalid SQL:
 
				SELECT *
				FROM session
				WHERE userid = 0
					AND host = 'xxx.xxx.xxx.xxx'
					AND idhash = '42ca445b8ab053d8bda7f1ed042cf2dc'
				LIMIT 1;
 
MySQL Error   : Table 'basededonné.session' doesn't exist
Error Number  : 1146
Request Date  : Wednesday, October 22nd 2008 @ 06:46:43 AM
Error Date    : Wednesday, October 22nd 2008 @ 06:46:43 AM
Script        : http://monforum/showthread.php?t=620
Referrer      : http://www.google.fr/search?hl=fr&q=recherche&start=40&sa=N
IP Address    : xxx.xxx.xxx.xxx
Username      : 
Classname     : vB_Database
MySQL Version :

the problem is i can see the table session from the phpmyadmin but not from vbulletin admincp
how could i resolve this please ?
 
seems is a mod you have installed thata creates a table basededonné the only thing you can do is track that mod or create that table
 
no "base de donné" is "database" in frensh because i have a frensh board so i call my database "basededonné" and their's no link to my board here
 
try to go to AdminCP > Maintenace > rebuild tables or something similar
fix the database and optimize it

last time i had an error i did that and got it fixed

props
 
Just do a soft upgrade of your forum version.

if your not on the latest VB version simply upgrade. If you are, simply overwrite the current files.

Make sure to backup your forum of course.

This way your forum files will be current & your forum itself (members, posts, threads, polls, etc) will remain intact.
 
Backup your database before following my post

PHP: 
CREATE TABLE " . TABLE_PREFIX . "session (
	sessionhash CHAR(32) NOT NULL DEFAULT '',
	userid INT UNSIGNED NOT NULL DEFAULT '0',
	host CHAR(15) NOT NULL DEFAULT '',
	idhash CHAR(32) NOT NULL DEFAULT '',
	lastactivity INT UNSIGNED NOT NULL DEFAULT '0',
	location CHAR(255) NOT NULL DEFAULT '',
	useragent CHAR(100) NOT NULL DEFAULT '',
	styleid SMALLINT UNSIGNED NOT NULL DEFAULT '0',
	languageid SMALLINT UNSIGNED NOT NULL DEFAULT '0',
	loggedin SMALLINT UNSIGNED NOT NULL DEFAULT '0',
	inforum SMALLINT UNSIGNED NOT NULL DEFAULT '0',
	inthread INT UNSIGNED NOT NULL DEFAULT '0',
	incalendar SMALLINT UNSIGNED NOT NULL DEFAULT '0',
	badlocation SMALLINT UNSIGNED NOT NULL DEFAULT '0',
	bypass TINYINT NOT NULL DEFAULT '0',
	profileupdate SMALLINT UNSIGNED NOT NULL DEFAULT '0',
	PRIMARY KEY (sessionhash)
)

Replace TABLE_PREFIX if you have defined it. If you're not sure you can check your config.php file for $config['Database']['tableprefix'], if theres nothing, remove " . TABLE_PREFIX . " part from the query completely and execute from phpMyAdmin or vBulletin AdminCP itself.

Hope this helps
 
Status
Not open for further replies.
Back
Top