I've just had to move a board to another host.

Took a while as the DB was 200 meg (thanks to SA for recommending BigDump - works great)

http://www.ozerov.de/bigdump

Anyway.. the first issue was the fact it had a htaccess hack that confirmed user/pass via the DB - This didn't seem to be working, regardless of what you put in. Even via AdminCP - No access

I removed the hack script from init.php which seemd to remove the restricted login pop-up..

But now I get this SQL Error.

I've search the DB and in both the original and the moved DB this reference only appears in 'Post'

Stumped.

Board ver is 3.0.9

__________________

came acroos myself not once that working code doesn't work on a new host.
in that case go over your quries and just add the ` tags to every field/table name.
for example:
instead of the query you posted here before.
greets.

That might be it?

The error is caused by a row called equinox, is not present. I don't know which hack would create this datastore called equinox. You have any ideas?

__________________
Earnersforum.com - Learn how to make money online! New Look!

Ken Iovino / vBHackers.com
vBSEO 3.2.0 Launched - Maximum Overdrive for Your Web Traffic! Over 100 Instant SEO Optimizations

vBSEO Google Sitemap Generator - Version 2.2 Released Mandatory Upgrade for vBSEO 3.2.0 GOLD

6X Traffic - $1400 in One Day with vBSEO! Imagine What the vBSEO Patent Pending Technology Can Do For You.

Crawlability Network: vBulletin SEO | vBulletin Hackers

Well the 'Datastore' Table never existed on the original Databse. As I said the second code box contains the 'only' reference to Datastore I could find.

'equinox' is the name of the Database. (original & new)

Maddog - Add these tags before importing the Databse - I will try this when I get home this evening.

Thanks.

I remember datastore as a table name that wasn't rellevant at all. The only thing it was, was being very very big. When moving I never copied it.

The datastore stores all your cached information. Stats, online records, template names, hook names, ect.. Read my tutorial about it. This isn't something you just don't want to leave behind when moving. ;) That's why I'm confussed... vBulletin has always had this table, since at least 3.0.0 as I remember.

__________________
Earnersforum.com - Learn how to make money online! New Look!

Ken Iovino / vBHackers.com
vBSEO 3.2.0 Launched - Maximum Overdrive for Your Web Traffic! Over 100 Instant SEO Optimizations

vBSEO Google Sitemap Generator - Version 2.2 Released Mandatory Upgrade for vBSEO 3.2.0 GOLD

6X Traffic - $1400 in One Day with vBSEO! Imagine What the vBSEO Patent Pending Technology Can Do For You.

Crawlability Network: vBulletin SEO | vBulletin Hackers

Well the code reference in index.php is this:
the thing is.. I ran this Query:
and...
seems to have bypassed that now.. onto another issue ..lol

Strange how the datastore table didn't exist in the old DB.

There's no way the datastore table didn't exist in your old DB. vB wouldn't be able to function without it.

Are you sure you looking for the equinox.datastore table aswell?

Well.. solved the problem,

The Databse I was using, which was the most obvious choice as it was named after the board (200 meg) was infact the wrong one. It was another (63 meg) named vbb_test .. pff

Only issue after that was for some reason I had to add 'grave accents' to a lot of queries.

for example: in functions_databuild.php

SELECT release from ftpdata

had to be changed to:

SELECT release from `ftpdata`

and...

DELETE FROM " . TABLE_PREFIX . "ftpdata

had to be changed to:

DELETE FROM `" . TABLE_PREFIX . "ftpdata`

had to go through all php files and chage this... must be something to do with the sql version, can't think of what else would need this.

Anyway, it's on the way to be fixed now, although the Gamespot finder.html doesn't exist anymore so all users of FXP Pack V1 will not be able to use this function... I'm looking for an alternative.