[osCmax v2.5x] upgrade from beta 2 to beta 3

[cujo]

ok i backed everything up and ran upgrade but get this errorn message,

Error

SQL query:
ALTER TABLE `information` ADD COLUMN `information_url` varchar( 255 ) NOT NULL AFTER `information_description` ,
ADD COLUMN `information_target` varchar( 255 ) NOT NULL AFTER `information_url` ,
CHANGE `parent_id` `parent_id` int( 11 ) NULL AFTER `information_target` ,
CHANGE `sort_order` `sort_order` tinyint( 3 ) unsigned NOT NULL DEFAULT '0' AFTER `parent_id` ,
CHANGE `visible` `visible` enum( '1', '0' ) NOT NULL DEFAULT '1' AFTER `sort_order` ,
CHANGE `language_id` `language_id` int( 11 ) NOT NULL DEFAULT '0' AFTER `visible` ,
COMMENT = '';


MySQL said:
#1146 - Table 'pitpass_catalog.information' doesn't exist

[cujo]

found out why the above happen but now iam getting this
SQL query:
ALTER TABLE `orders_products_attributes` ADD COLUMN `weight_prefix` char( 1 ) NOT NULL AFTER `price_prefix` ,
ADD COLUMN `options_values_weight` decimal( 6, 3 ) NOT NULL DEFAULT '0.000' AFTER `weight_prefix` ,
COMMENT = '';


MySQL said:
#1060 - Duplicate column name 'weight_prefix'

[cujo]

why does the upgrade not work if there is sopmething iam not doing correct you should explain better you say backup files and database and run upgrade file will i do this and everytime i do it it errors here is the error now. so please expalin in detail how to ujpgrade if it not just going to myphpadmin and importing the file.

Error

SQL query:
ALTER TABLE `information` ADD COLUMN `information_url` varchar( 255 ) NOT NULL AFTER `information_description` ,
ADD COLUMN `information_target` varchar( 255 ) NOT NULL AFTER `information_url` ,
CHANGE `parent_id` `parent_id` int( 11 ) NULL AFTER `information_target` ,
CHANGE `sort_order` `sort_order` tinyint( 3 ) unsigned NOT NULL DEFAULT '0' AFTER `parent_id` ,
CHANGE `visible` `visible` enum( '1', '0' ) NOT NULL DEFAULT '1' AFTER `sort_order` ,
CHANGE `language_id` `language_id` int( 11 ) NOT NULL DEFAULT '0' AFTER `visible` ,
COMMENT = '';


MySQL said:
#1060 - Duplicate column name 'information_url'

[michael_s]

You need to be running the stock beta 2 , not an svn update or a modified database. You can only run the sql file once. If it fails with an error, you must restore your backup and start over. Since you got an error, you do not have a stock beta 2 database structure, so you need to manually apply the changes. Open the sql file in a text editor and run each table alteration manually, one at a time.

If you get a #1060 - Duplicate column name 'information_url' that means you already have the upgraded table to beta 3 level. Move on to the next query. Remember, one at a time.

[cujo]

iam running a stock version its the only version i have installed is the beta2 and nothing has been modified there is nothing installed except the beta 2

[cujo]

also its says beta 3 in my admin but i get this message

Error: I am able to write to the configuration file: /home/unlimted/public_html/catalog/includes/configure.php. This is a potential security risk - please set the right user permissions on this file.

But the site does not show that error only in the admin and i ahve checked the file the permission is 0444

[michael_s]

You must restore your backup database and start fresh. You are getting the other errors because you ran the sql file a second time on the same database. Can't do it as the sql already updated those other tables.

I just verified on a stock beta 2 database, the information table has the following fields:

  `information_id` TINYINT(3) UNSIGNED NOT NULL AUTO_INCREMENT,
  `information_group_id` INT(11) UNSIGNED NOT NULL DEFAULT '0',
  `information_title` VARCHAR(255) NOT NULL DEFAULT '',
  `information_description` TEXT NOT NULL,
  `parent_id` INT(11) DEFAULT NULL,
  `sort_order` TINYINT(3) UNSIGNED NOT NULL DEFAULT '0',
  `visible` ENUM('1','0') NOT NULL DEFAULT '1',
  `language_id` INT(11) NOT NULL DEFAULT '0',

Notice that `information_url` is not present. This shows me that you have run the sql file more than once on your database. So,follow my advice and start over. Restore your database from backup, then run the script once. I have tested the script dozens times under various different server environments and it works fine every time. No errors, easy one minute upgrade.

[cujo]

ok i did the upgrade on seprate site ran the SQL One time and got this message.

Error

SQL query:
ALTER TABLE `orders_products_attributes` ADD COLUMN `weight_prefix` char( 1 ) NOT NULL AFTER `price_prefix` ,
ADD COLUMN `options_values_weight` decimal( 6, 3 ) NOT NULL DEFAULT '0.000' AFTER `weight_prefix` ,
COMMENT = '';


MySQL said:
#1060 - Duplicate column name 'weight_prefix'

[cujo]

michael i have tried the upgrade on 3 seprate sites and all 3 give error i backed up my database in cpanel under backups backed up my files to my hard drive then copied new files over exsting files once done weny to myphadmin pick my data base and imported the file in your upgrade folder beta2 to beta3 so if there is something iam not soing correct i dont know what it is.

Now after restoreing database from backup and doing it agin i get this.

Error

SQL query:
ALTER TABLE `information` ADD COLUMN `information_url` varchar( 255 ) NOT NULL AFTER `information_description` ,
ADD COLUMN `information_target` varchar( 255 ) NOT NULL AFTER `information_url` ,
CHANGE `parent_id` `parent_id` int( 11 ) NULL AFTER `information_target` ,
CHANGE `sort_order` `sort_order` tinyint( 3 ) unsigned NOT NULL DEFAULT '0' AFTER `parent_id` ,
CHANGE `visible` `visible` enum( '1', '0' ) NOT NULL DEFAULT '1' AFTER `sort_order` ,
CHANGE `language_id` `language_id` int( 11 ) NOT NULL DEFAULT '0' AFTER `visible` ,
COMMENT = '';


MySQL said:
#1060 - Duplicate column name 'information_url'

[michael_s]

Post the table schema from your backup mysqldump (no actual data inserts, just the table schema).

You can safely ignore the duplicate column messages. It just means that your database already has the column that the script is trying to add.

Move on through each of the table alterations. If you just get the 1060 errors, you can then move on to adding the new data (the inserts and updates)

Once you finish those, you will be all upgraded.