vBulletin Modifications

BD 'datastore' Error after Host move

Welcome to vBHackers.com! - vBHackers Updates:

Go Back   vBulletin Modifications > General vBulletin Section > General vBulletin Support

Reply
 
LinkBack Thread Tools
Old 03-30-2006, 06:53 AM   #1
Member
VirtualBurn's Avatar
Join Date: Jan 2005
Real Name: VirtualBurn
Location: UK
VirtualBurn is on a distinguished road

Question BD 'datastore' Error after Host move

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.

You must first be a registered member to view any code.
I've search the DB and in both the original and the moved DB this reference only appears in 'Post'

You must first be a registered member to view any code.
Stumped.

Board ver is 3.0.9
__________________




Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
Sponsored Links
Old 03-30-2006, 10:55 AM   #2
Coder
Idan's Avatar
Join Date: Feb 2005
Real Name: Idan
Location: Israel
Idan is on a distinguished road

Default

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:
You must first be a registered member to view any code.
instead of the query you posted here before.
greets.




Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
Old 03-30-2006, 11:11 AM   #3
vBulletin Guru
Arnoud's Avatar
Join Date: Nov 2004
Real Name: Arnoud Kuipers
Location: Europe, Flanders
Arnoud is on a distinguished road

Default

Quote:
Invalid SQL:
SELECT title, data
FROM datastore
WHERE title IN ('options', 'cron', 'forumcache', 'usergroupcache', 'stylecache', 'userstats', 'birthdaycache', 'maxloggedin', 'iconcache', 'eventcache', 'mailqueue')

mysql error: Table 'equinox.datastore' doesn't exist
That might be it?




Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
Old 03-30-2006, 12:20 PM   #4
Ken Iovino
Founder
Ken Iovino's Avatar
Join Date: Mar 2004
Real Name: Ken Iovino
Location: Miami, Florida
Ken Iovino is on a distinguished road

Default

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




Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
Old 03-30-2006, 01:30 PM   #5
Member
VirtualBurn's Avatar
Join Date: Jan 2005
Real Name: VirtualBurn
Location: UK
VirtualBurn is on a distinguished road

Default

Quote:
Originally Posted by LiveWire
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?
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.




Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
Old 03-30-2006, 02:05 PM   #6
Advanced Coder
Niels's Avatar
Join Date: Jun 2004
Real Name: Niels
Location: NL
Niels is on a distinguished road

Default

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.




Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
Old 03-31-2006, 01:39 AM   #7
Ken Iovino
Founder
Ken Iovino's Avatar
Join Date: Mar 2004
Real Name: Ken Iovino
Location: Miami, Florida
Ken Iovino is on a distinguished road

Default

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




Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
Old 03-31-2006, 04:29 AM   #8
Member
VirtualBurn's Avatar
Join Date: Jan 2005
Real Name: VirtualBurn
Location: UK
VirtualBurn is on a distinguished road

Default

Well the code reference in index.php is this:
You must first be a registered member to view any code.
the thing is.. I ran this Query:
You must first be a registered member to view any code.
and...
You must first be a registered member to view any code.
seems to have bypassed that now.. onto another issue ..lol

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




Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
Old 03-31-2006, 09:06 PM   #9
vBulletin Guru
Arnoud's Avatar
Join Date: Nov 2004
Real Name: Arnoud Kuipers
Location: Europe, Flanders
Arnoud is on a distinguished road

Default

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?




Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
Old 04-01-2006, 08:20 AM   #10
Member
VirtualBurn's Avatar
Join Date: Jan 2005
Real Name: VirtualBurn
Location: UK
VirtualBurn is on a distinguished road

Default

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.




Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
Reply



Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Thread Tools

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On
Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Cache System Explanation (datastore) Ken Iovino vBulletin Modification Tutorials 19 05-13-2006 04:56 PM
[Req] Quick Sig. Host for Vb3.5.0 Gold. Nneel vBulletin Modification Requests 1 10-27-2005 12:59 AM
How to Move the Forum? vieri General vBulletin Support 3 02-20-2005 10:39 PM
Mass Move killer vBulletin Modification Requests 0 01-30-2005 10:08 AM


All times are GMT -3. The time now is 06:53 PM.


SEO by vBSEO 3.2.0 ©2008, Crawlability, Inc. (Patent Pending)