Jump to content

SQL errors in upgrade


Recommended Posts

Just upgraded to 1.4.2.5. On install, it said that the upgrade was successful, but picked up 2 sql errors. Before going to much further, should I try again or not worry about it? The log is 3 pages long, but the first bit is:

SET NAMES 'utf8'

ALTER TABLE `ps_tab_lang` MODIFY `id_lang` int(10) unsigned NOT NULL AFTER `id_tab`

ALTER TABLE `ps_carrier` ADD `is_free` tinyint(1) unsigned NOT NULL DEFAULT '0' AFTER `is_module`

(1060) Duplicate column name 'is_free'
UPDATE `ps_address_format` SET `format`=REPLACE(REPLACE(`format`, 'state_iso', 'State:name'), 'country', 'Country:name')

ALTER TABLE `ps_orders` ADD INDEX `date_add`(`date_add`)

(1061) Duplicate key name 'date_add'
/* PHP:update_module_followup(); */

Link to comment
Share on other sites

I also got the following SQL errors:

UPDATE `ps_address_format` SET `format`=REPLACE(REPLACE(`format`, 'state_iso', 'State:name'), 'country', 'Country:name')

(1146) Table 'dermalse_final2.ps_address_format' doesn't exist

UPDATE `ps_address_format` SET `format`=REPLACE(`format`, 'state', 'State:name')

(1146) Table 'dermalse_final2.ps_address_format' doesn't exist

Everything seems to be working OK. Is this something to worry about?

Link to comment
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...