Database error

[TheHeartSmasher]

This is the only thing holding me back from the site working again. I moved it from one domain to the other on the same server

I went to the upgrade so I could see what the error was.


Invalid SQL:

SELECT *
FROM datastore
WHERE title IN ('','options','bitfields','attachmentcache','forum cache','usergroupcache','stylecache','languagecach e','products','pluginlist','cron','profilefield');

MySQL Error : Table 'forumsvb.datastore' doesn't exist
Error Number : 1146
Date : Sunday, June 25th 2006 @ 12:37:46 PM
Script : http://www.website.com/forums/install/upgrade.php
Referrer :
IP Address :
Username :
Classname : vB_Database

[Steve Machol]

Did you actually backup and restore the database, then check to make sure the db was fully restored?

If so are you using a table prefix? If so, edit your config.php file to use that prefix.

[TheHeartSmasher]

I had to restore the files back to the 3.5.4(This morning Database and files) it seems I didn't use any new prefixes, everything was the same. Is there a procedure for moving the forums from one domain to the other that can probably help me out. When I tried to move it back to the original domain I recieved the same error so now we are back to the backup I made this morning before installing 3.6 beta 3 and moving it.

I would really like to get the site moved to the same domain as the new version gives us more options and the control I have been looking for.

:)

[Steve Machol]

Did you check the database? Does it have a datastore table?

[TheHeartSmasher]

Yes that's the weird thing.

I checked before and after the upgrade to 3.6 beta 3

[Steve Machol]

So you are aying that the 'forumsvb' database *does* have a 'datastore' table? If so, then I don't see any way that this error would be possible:

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

[TheHeartSmasher]

so the table does exsist it is called vbdatastore but when I move the site just click on my forums folder and index.php and move from one domain folder to the other that is what I see.

I keep trying and it keeps happining.

[Steve Machol]

I didn't understand the rest of your post, but it sounds like you are using 'vb' as the table prefix. Try editing your config.php file to use that prefix.

[TheHeartSmasher]

I will let you know how it goes when I try again.