Update errors Version 1.5.1.3 to Version 1.5.6.3

Quote

Post by r4nd0m » Mon Apr 21, 2014 2:18 am

I now have tried multiple ways to get a functional upgrade to a supported/suggested version.

This time I tried from 1.5.1.3 to 1.5.6.3 but I receive the below error during the upgrade - I assume the error seems to be that the upgrade tries to create all the tables rather than checking for existence and then to insert if there are changes ...
Notice: Error: Table 'address' already exists
Error No: 1050
CREATE TABLE `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 /home/_folder_/_domain_/system/database/mysql.php on line 50
please allow the question if the software is actually tested prior to release.

cheers
r4n
r4nd0m
New member
Posts
26
Joined
Wed Oct 16, 2013 11:35 pm
Top

Re: Update errors Version 1.5.1.3 to Version 1.5.6.3

Quote

Post by IP_CAM » Mon Apr 21, 2014 5:38 am

I guess the existing v.1.5.1.x DB cannot longer be handled by v.1.5.6.x Versions, you probably have to create a new DB.

Ernie

My Github OC Site: https://github.com/IP-CAM
5'600 + FREE OC Extensions, on the World's largest private Github OC Repository Archive Site.

User avatar
IP_CAM
Legendary Member
Posts
13060
Joined
Tue Mar 04, 2014 1:37 am
Location - Switzerland
Top

Re: Update errors Version 1.5.1.3 to Version 1.5.6.3

Quote

Post by rph » Mon Apr 21, 2014 5:27 pm

To fix the issue edit /system/helper/utf8.php and change both instances of:

Code: Select all

function utf8_substr($string, $offset, $length = null) {
    if ($length == null) { 
To:

Code: Select all

function utf8_substr($string, $offset, $length = null) {
    if ($length === null) { 
You can see the fix on GitHub at:

https://github.com/opencart/opencart/co ... 3bc37a86f1

-Ryan

rph
Expert Member
Posts
4102
Joined
Fri Jan 08, 2010 5:05 am
Location - Lincoln, Nebraska
Top

Re: Update errors Version 1.5.1.3 to Version 1.5.6.3

Quote

Post by r4nd0m » Tue Apr 22, 2014 6:01 am

cheers buddy, that solved it ...

r4n
r4nd0m
New member
Posts
26
Joined
Wed Oct 16, 2013 11:35 pm
Top
Post Reply
Return to “Installation, Upgrade, & Config Support”
Who is online

Users browsing this forum: No registered users and 7 guests