upgrading from 3.0.6 - 3.5.4

[zyad]

Hello, i'm not completely positive if this fits into this topic, but it's the most relevant, other than asking support on .com.

I'm sure this is a dumb question, but I tried upgrading from 3.0.6 - 3.5.4 using /install/upgrade.php ... however i get an error.

Database error in vBulletin :

Invalid SQL:

SELECT title, data
FROM _datastore
WHERE title IN ('','options','bitfields','forumcache','usergroupc ache','stylecache','languagecache','products','plu ginlist','cron');

MySQL Error : Table 'frforum._datastore' doesn't exist
Error Number : 1146
Date : Saturday, May 27th 2006 @ 03:46:06 PM
Script : http://*************/install/upgrade.php
Referrer :
IP Address : 65.92.172.244
Username :
Classname : vb_database

i put in the database login info into the config file from the 3.0.6 to 3.5.4

am i missing something?

[Mark.B]

The first thing that stands out for me is this:

'frforum._datastore'

There appears to be a dot after your table prefix....are you sure that's supposed to be there?

Check your new config.php and make sure the table prefix is set correctly without a dot. Since I'm assuming your forum worked ok previously, I would say that's where the problem could lie.

[zyad]

hmmm no period

// ****** TABLE PREFIX ******
// Prefix that your vBulletin tables have in the database.
$config['Database']['tableprefix'] = '_';

however i just removed the underscore and now it's like this...

Database error in vBulletin :

Invalid SQL:

SELECT title, data
FROM datastore
WHERE title IN ('','options','bitfields','forumcache','usergroupc ache','stylecache','languagecache','products','plu ginlist','cron');

MySQL Error : Table 'frforum.datastore' doesn't exist
Error Number : 1146
Date : Saturday, May 27th 2006 @ 04:01:23 PM
Script : http://www.*************/install/upgrade.php
Referrer :
IP Address : 65.92.172.244
Username :
Classname : vb_database

[Mark.B]

Hmmm....

It's late at night, it's the underscore that's wrong, not the dot. I'm half asleep.....

Have you a copy of your OLD config.php? If so, what was the table prefix entry on that?

It's worth double checking that the database details on the new config file exactly match those on the old one.

[zyad]

table prefix in the old config file says vb3_ .... however in phpmyadmin, it doesn't show a prefix on any table

[Mark.B]

Originally Posted by zyad

table prefix in the old config file says vb3_ .... however in phpmyadmin, it doesn't show a prefix on any table

Well it's worth trying putting that in and seeing what happens....

If that was the setting in the old config file, and the forum was running ok, then it's got to be worth chaging it back to that.

Not having run a board with prefixes I am never 100% sure how they're set up, but I'd try that for certain.

[zyad]

thanks for your help mark. i actually removed the prefixes and i noticed that i forgot to change the db name lol i'm such a dummy