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 :

DuCe Reviewed by DuCe on 1st Feb 2010. Database issues Alright webmasters, I been having this problem importing my old database from my site and I thought someone from this site may be able to help me seeing as this is a webmasters site. I had a website not too long ago, then there was a power outage where I live at (Florida) which happens alot. This power outage fried my charger, and the piece where you connect it. Now with the few minutes I had left with power on my laptop I made a backup of my site just in case I was not going to be able Rating: 5

[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!

[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...