Log in

View Full Version : Error Page or forum


no mods
07-03-2007, 02:20 AM
I was getting on my forum awhile ago, then an error page came up. But my other admin can still acess the forum. I just switched hosting so that may be the problem. Can I get some feedback on weither you get the forum or error page.

http://www.type2chat.com

HMBeaty
07-03-2007, 02:24 AM
I get the error page, and here is your error:

Database error in vBulletin :
Invalid SQL:
SELECT *
FROM datastore
WHERE title IN ('','options','bitfields','attachmentcache','forum cache','usergroupcache','stylecache','languagecach e','products','pluginlist','cron','profilefield',' userstats','birthdaycache','maxloggedin','iconcach e','eventcache','mailqueue');
MySQL Error : Table 'nomods_type2chatalksqlkey.datastore' doesn't exist
Error Number : 1146
Date : Monday, July 2nd 2007 @ 10:24:24 PM
Script : http://www.type2chat.com/
Referrer :
IP Address : 67.142.130.31
Username :
Classname : vb_database

no mods
07-03-2007, 02:26 AM
Me two, but my admin is on the sie and able to post, i was earlier two.

Logikos
07-03-2007, 02:33 AM
You most likely didn't enter a correct database name or you left out your table prefix in the config.php file.

no mods
07-03-2007, 02:34 AM
BUt its was working then its stopped for me, but is still working for my admin for some reason. I could post and everything.

Logikos
07-03-2007, 02:43 AM
<a href="http://www.vbulletin.com/forum/showthread.php?t=229974&highlight=datastore+error+1146" target="_blank">http://www.vbulletin.com/forum/showt...ore+error+1146</a>

no mods
07-03-2007, 02:45 AM
Actually I dont have a table prefix, any Idea what I would put for that?

Logikos
07-03-2007, 02:49 AM
Contact vBulletin for support. They will probably tell you the same thing, but maybe there is something I over looked. That's a pretty standard error and happens to quite a few people.

It says: nomods_type2chatalksqlkey.datastore doesn't exist. So your database is named "nomods_type2chatalksqlkey"?

no mods
07-03-2007, 02:55 AM
Ya thats what its named.

$config['Database']['tableprefix'] = '';

Is there post to be something there

Logikos
07-03-2007, 02:57 AM
Whats the value for your $config['Database']['dbname'] variable?

no mods
07-03-2007, 03:01 AM
This is what I have, username and pass left out. I dont know what your talking about Ken please explain.

// ****** DATABASE TYPE ******
// This is the type of the database server on which your vBulletin database will be located.
// Valid options are mysql and mysqli, for slave support add _slave. Try to use mysqli if you are using PHP 5 and MySQL 4.1+
$config['Database']['dbtype'] = 'mysql';

// ****** DATABASE NAME ******
// This is the name of the database where your vBulletin will be located.
// This must be created by your webhost.
$config['Database']['dbname'] = 'nomods_type2chatalksqlkey';

// ****** TABLE PREFIX ******
// Prefix that your vBulletin tables have in the database.
$config['Database']['tableprefix'] = '';

// ****** TECHNICAL EMAIL ADDRESS ******
// If any database errors occur, they will be emailed to the address specified here.
// Leave this blank to not send any emails when there is a database error.
$config['Database']['technicalemail'] = 'dbmaster@example.com';

// ****** FORCE EMPTY SQL MODE ******
// New versions of MySQL (4.1+) have introduced some behaviors that are
// incompatible with vBulletin. Setting this value to "true" disables those
// behaviors. You only need to modify this value if vBulletin recommends it.
$config['Database']['force_sql_mode'] = false;



// ****** MASTER DATABASE SERVER NAME AND PORT ******
// This is the hostname or IP address and port of the database server.
// If you are unsure of what to put here, leave the default values.
$config['MasterServer']['servername'] = 'localhost';
$config['MasterServer']['port'] = 3306;

Logikos
07-03-2007, 03:05 AM
It's likely that your datastore table is just not there. Maybe somehow got deleted during an upgraded? I don't know, I wouldn't be able to know unless I'm in your PHPMYADMIN area. I would send a ticket to Jelsoft, this is something they can help you with.