[Beta 2, Step 4] Upgrade error, Unknown column 'product' in 'where clause'

[Floris]

Step 4) Import latest style

Importing vbulletin-style.xml MASTER STYLE

Please Wait

Database error in vBulletin 3.5.0 Beta 2:
Invalid SQL:
DELETE FROM language_template WHERE styleid = -10 AND (product = 'vbulletin' OR product = '');
MySQL Error  : Unknown column 'product' in 'where clause'
Error Number : 1054
Date		 : Saturday, June 18th 2005 @ 06:43:55 PM
Script	   : [URL="http://www.vbulletin-language.com/install/finalupgrade.php?step=4"]http://www.vbulletin-language.com/install/finalupgrade.php?step=4[/URL]
Referrer	 : [URL="http://www.vbulletin-language.com/install/finalupgrade.php?step=3"]http://www.vbulletin-language.com/install/finalupgrade.php?step=3[/URL]
IP Address   : 62.194.46.xxx
Username	 : 
Classname	: vb_database

I have a bunch of sites on the same server, and three of them upgraded perfectly, this is the fourth one and it just won't go. I am not known with the error. Upgrade from 3.0.7 to 3.5.0 beta 1 did not give me any issues and the site runs perfectly fine. I am using a default master style on beta 1

Reuploading the .xml files didn't fix it

[Kier]

Those product fields should have been added by the initial upgrade to 3.5.0... we aren't sure how the upgrade could have continued without adding them...

[Kier]

Okay, in upgrade.php, find this line:

$db->query_first("SELECT product FROM " . TABLE_PREFIX . "phrasetype LIMIT 1");

and replace it with

$db->query_first("SELECT product FROM " . TABLE_PREFIX . "adminhelp LIMIT 1");

Then run upgrade.php four or five times and see if the error happens after that.

[Floris]

That didn't fix it.

[Floris]

I run the query:

ALTER TABLE template ADD product VARCHAR(15) NOT NULL

and then upgrade.php again with your replaced $db-... line.

WORKED.

Upgraded perfectly fine this time.

[Kier]

You need more than that. You need all these queries to be run sucessfully:

ALTER TABLE phrasetype   ADD product VARCHAR(15) NOT NULL;
ALTER TABLE phrase       ADD product VARCHAR(15) NOT NULL;
ALTER TABLE template     ADD product VARCHAR(15) NOT NULL;
ALTER TABLE setting      ADD product VARCHAR(15) NOT NULL;
ALTER TABLE settinggroup ADD product VARCHAR(15) NOT NULL;
ALTER TABLE adminhelp    ADD product VARCHAR(15) NOT NULL;

[sHORTYWZ]

FYI, I am having this problem as well. Changing the php and running the query worked.

However, the forum is now displaying Beta1 everywhere - reran the upgrade and still didn't fix that.

[Onimua]

Besides all that, for some reason I keep getting the error that none of those tables exist (as mentioned in my thread started in this forum, but after trying all of those, can't figure out the problem).

Yep, keep getting the "this table doesn't exist" error for every query Kier posted.

[Kier]

The queries I posted do not include your personal table prefix. You will need to add that manually, so if you have a table prefix of 'vb_' then the queries will need to become ALTER TABLE vb_template etc.

[Floris]

You need more than that. You need all these queries to be run sucessfully:

ALTER TABLE phrasetype   ADD product VARCHAR(15) NOT NULL;
ALTER TABLE phrase       ADD product VARCHAR(15) NOT NULL;
ALTER TABLE template     ADD product VARCHAR(15) NOT NULL;
ALTER TABLE setting      ADD product VARCHAR(15) NOT NULL;
ALTER TABLE settinggroup ADD product VARCHAR(15) NOT NULL;
ALTER TABLE adminhelp    ADD product VARCHAR(15) NOT NULL;

Yes, but only template one was missing. The rest already excisted.