Datastore

[mdorty]

I was getting an error saying that there were duplicate tables in the datastore table, so I (stupidly) went into myphpadmin and dropped a couple of things in the datastore table, and now my forum doesn't work. Is there any way to fix this? Would the items i 'dropped' be available anywhere for me to 'undrop' them? I'm hoping I don't have to re-install my forum to fix the problem...

[Steve Machol]

We need to see the real error message. Right-click on the error page and go to View/Source. Then copy-n-paste the error message here.

[mdorty]

Database error in vBulletin :
 
Invalid SQL:
 
			SELECT *
			FROM datastore
			WHERE title IN ('','options','bitfields','attachmentcache','forumcache','usergroupcache','stylecache','languagecache','products','pluginlist','cron','profilefield','loadcache','noticecache','userstats','birthdaycache','maxloggedin','iconcache','eventcache','mailqueue');
 
MySQL Error   : Unknown column 'title' in 'where clause'
Error Number  : 1054
Request Date  : Saturday, October 3rd 2009 @ 01:23:56 PM
Error Date    : Saturday, October 3rd 2009 @ 01:23:56 PM
Script        : http://planetmado.com/forum/
Referrer      : http://www.planetmado.com/
IP Address    : 96.35.57.60
Username      : 
Classname     : vB_Database
MySQL Version :

[Steve Machol]

Unfortunately it looks like you messed up your datastore table. Rename the one you have to 'datastore_bak', then run this query to recreate it:

CREATE TABLE datastore (
title CHAR(50) NOT NULL DEFAULT '',
data MEDIUMTEXT,
unserialize SMALLINT NOT NULL DEFAULT '0',
PRIMARY KEY (title)
);

Then uload the tools.php script in the 'do_not_upload' folder of the vB zip file to your Admin CP directory and run it from your browser. Then run the [Options Cache] - Update the options cache from the setting table. This should fix the datastore table.

[mdorty]

Thank you, that worked