Post by Renato Frota » Tue Feb 12, 2013 12:42 am

Hi,

a friend is having this problem when trying to upgrade from 1.5.4.1 to 1.5.5.1.

I confirmed he is not in the 'install' screen, it's the upgrade screen.
Notice: Error: Table 'op_address' already exists
Error No: 1050
CREATE TABLE `OP_address` ( `address_id` int(11) NOT NULL AUTO_INCREMENT, `customer_id` int(11) NOT NULL, `firstname` varchar(32) NOT NULL, `lastname` varchar(32) NOT NULL, `company` varchar(32) NOT NULL, `company_id` varchar(32) NOT NULL, `tax_id` varchar(32) NOT NULL, `address_1` varchar(128) NOT NULL, `address_2` varchar(128) NOT NULL, `city` varchar(128) NOT NULL, `postcode` varchar(10) NOT NULL, `country_id` int(11) NOT NULL DEFAULT '0', `zone_id` int(11) NOT NULL DEFAULT '0', PRIMARY KEY (`address_id`), KEY `customer_id` (`customer_id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci in C:\home\djwebdesign.com.br\www\opencart\system\database\mysql.php on line 50
For what I know, upgrade script should not run CREATE queries (at least not for oc_address, the first table).

Any help is appreciated

New member

Posts

Joined
Wed Aug 31, 2011 1:21 pm
Who is online

Users browsing this forum: No registered users and 21 guests