vb 2.3.2 to vb3 upgrade mysql error 1146

[TechGuy]

I don't get to any step at all... If I go to /install/upgrade.php, I get the generic database error message and an email that reads:

Database error in vBulletin :
Invalid SQL:
SELECT title, data FROM datastore
WHERE title IN ('options', 'cron', 'forumcache', 'usergroupcache', 'stylecache')
mysql error: Table 'beta.datastore' doesn't exist
mysql error number: 1146
Date: Saturday 27th of March 2004 05:12:16 PM
Script: http://***/install/upgrade.php
Referer:
IP Address: ***

I did a search in this forum and found at least a dozen similar posts, but no replies.

[Steve Machol]

Try the fixoptions.php script:

http://www.vbulletin.com/forum/showpost.php?p=575568&postcount=7

[TechGuy]

fixoptions.php reports the same error:

Database error in vBulletin :

Invalid SQL:
SELECT title, data FROM datastore
WHERE title IN ('options', 'cron', 'forumcache', 'usergroupcache', 'stylecache')

mysql error: Table 'beta.datastore' doesn't exist

mysql error number: 1146

[Steve Machol]

Hmmm...running that script should have fixed this. I realy don't know then.

[TechGuy]

Heh... then what's my next step? Support request?

(FYI, I don't have a "datastore" table... dunno if I'm supposed to.)

[Steve Machol]

I'm looking around but all I can find is that the fixoptions.php script should have fixed this. Exactly at what step is this occuring? The datastore table is actually created in the next upgrade script (upgrade1) and you shouldn't be getting this error on upgrade.php.

Is this a clean 2.3.2 database with no hacks? Just out of curiousity, did you run the database conflicts script prior to attempting the upgrade?

http://www.vbulletin.com/forum/showthread.php?threadid=73163

[TechGuy]

Tried running the check, but, uhh... got the same error.

It's got a few hacks, but none that effect the db... If the datastore isn't created in upgrade.php, why in the world would it be looking for it there?

[Steve Machol]

It doesn't make any sense to me. I'll see if I can get one of the Devs to take a look.

[TechGuy]

Just got it going, Steve! Turns out I had file permissions set wrong in such a way that mysqld couldn't make changes to my beta database.

Now to see how long it takes 200,000 threads and 100,000 members to convert...

[Steve Machol]

Just out of curiousity which files did you have permissions wrong for?

[TechGuy]

The actual database files -- /var/lib/mysql/beta/* -- I had to chown mysql *

But, I'd be willing to bet that for anyone else this will be a generic error meaning that it couldn't make changes to the database, possibly due to MySQL permissions (as opposed to file permissions). Hope that helps and thanks for your assistance!

[ImportPassion.com]

yup, permissions prob for me too. think it's time for some error checking on the upgrade script.

[bharvey42]

I am getting this same issue as well I can't even get the upgrade.php file to do anything except mail my admin account an e-mail with the errors listed on this page. I don't know if it's a db permissions problem or not. Is there a command that will list who it's assigned to for each table and should mysql be the proper name?

I have cpanel and shell access on my box if that makes it easier.

Thanks,
Brandon

[MissKalunji]

yup, permissions prob for me too. think it's time for some error checking on the upgrade script.

Hey how do u fix the permissions??

[hass]

has anyone worked out what file's permissions we are to change and how to do so?

regards