Database issues

[DuCe]

No, I really don't know anything about this database stuff.

Kind of an rookie at this.

I know it says:

atabase error in vBulletin :

Invalid SQL:

SELECT *
FROM datastore
WHERE title IN ('','options','bitfields','attachmentcache','forum cache','usergroupcache','stylecache','languagecach e','products','pluginlist','cron','profilefield',' loadcache','noticecache','userstats','birthdaycach e','maxloggedin','iconcache','eventcache','mailque ue');

MySQL Error : Table 'warezdes_name.datastore' doesn't exist
Error Number : 1146
Request Date : Monday, February 1st 2010 @ 02:37:39 AM
Error Date : Monday, February 1st 2010 @ 02:37:39 AM
Script : http://www.warezdesign.net/
Referrer :
IP Address :
Username :
Classname : vB_Database
MySQL Version :

[delboy]

MySQL Error : Table 'warezdes_name.datastore' doesn't exist

There is a few reasons
1) you backup is incomplete
2) there was an error while importing the db
3) Probably some more reasons i cannot think of right now!!!

There is a few things you can do
1) look in your .sql file and see if it has that table, if it does well we know its number 2, so just reimport, if it doesnt then we can assume your backup is incomplete,

if your backup is incomplete you have pretty much lost the missing data, however you can still use the db, there is a few ways to use it still

Dead Cert Way
1) Install a fresh copy of vBulletin
2) cut the post/topic/member important bits out of the db and run as a query

A Possiblity
1) Upload the latest copy of vBulletin 4.0
2) Run The Upgrade feature
3) wait and hope... it may then insert the missing tables...

Another Possiblity
1) Convert the db to ipb then convert it back to vBulletin

There is probably more ways, it all depends on the reasons for this error, probably the most important question is it in your sql file, once we know that we have the key to what we need to do next!

[Maniac_]

Can't he just... create that table..??

[delboy]

Can't he just... create that table..??

It depends, as i personally don’t use vBulletin I really cannot be sure if vBulletin inserts data on install/upgrade into that table...

if vBulletin doesn’t insert data obviously he could just create that table however if vBulletin requires x data to be present in that table for vBulletin to function properly then it removes that possibility.

[DuCe]

There is a few reasons
1) you backup is incomplete
2) there was an error while importing the db
3) Probably some more reasons i cannot think of right now!!!

There is a few things you can do
1) look in your .sql file and see if it has that table, if it does well we know its number 2, so just reimport, if it doesnt then we can assume your backup is incomplete,

if your backup is incomplete you have pretty much lost the missing data, however you can still use the db, there is a few ways to use it still

Dead Cert Way
1) Install a fresh copy of vBulletin
2) cut the post/topic/member important bits out of the db and run as a query

A Possiblity
1) Upload the latest copy of vBulletin 4.0
2) Run The Upgrade feature
3) wait and hope... it may then insert the missing tables...

Another Possiblity
1) Convert the db to ipb then convert it back to vBulletin

There is probably more ways, it all depends on the reasons for this error, probably the most important question is it in your sql file, once we know that we have the key to what we need to do next!

Is there any way that I can contact you away from this site such as AIM, MSN, ect... I have it all.

That way we can figure this thing out if you wish to help me because I don't know much...

It sounds like you know a bunch about this, if you do then we can probably fix this, and know for next time. Also I would have another trusted webmaster I can come too if anything...

[DuCe]

Guess not...

[litewarez]

Duce are you confident that the actual database named "warezdes_name" exists ?

if it does not then create that database and import the backup to that one!

[deAthbLisS]

just resolved the same error on missionw.com yesterday.

1. check your database name
2. check your table name
3. check your mysql login and pass.
4. if not sure for step 3, then make a new mysql user.
5. give the new user all permissions to work on db
6. configure your include/config.php file accordingly. check the database name, table prefix, user id and pass,

save the file and refresh.

hope this works.

[gigawiz]

whenever i had this prob myself, i went with what i guess is called "Dead Cert Way" ... i always called it the old copypaster.... but anyways... ive done it so many times its second nature.... if you need help let me know.... my im's are on my contact page here at KWWH..