OpenCart Community

I am upgrading from 1.5.4 to version 3. Running the install process as per the upgrade.txt file and in accord with the instructions therein, I have become stuck in a loop with the following errors:

SyntaxError: JSON.parse: unexpected character at line 1 column 1 of the JSON data OK Notice: Undefined index: Tables_in_Bookstall in C:\Inetpub\vhosts\s-r-s.org.uk\httpdocs\Bookstall\install\model\upgrade\1000.php on line 149Notice: Undefined index: Tables_in_Bookstall in C:\Inetpub\vhosts\s-r-s.org.uk\httpdocs\Bookstall\install\model\upgrade\1000.php on line 149Notice: Undefined index: Tables_in_Bookstall in C:\Inetpub\vhosts\s-r-s.org.uk\httpdocs\Bookstall\install\model\upgrade\1000.php on line 149Notice: Undefined index: Tables_in_Bookstall in C:\Inetpub\vhosts\s-r-s.org.uk\httpdocs\Bookstall\install\model\upgrade\1000.php on line 149Notice: Undefined index: Tables_in_Bookstall in C:\Inetpub\vhosts\s-r-s.org.uk\httpdocs\Bookstall\install\model\upgrade\1000.php on line 149Notice: Undefined index: Tables_in_Bookstall in C:\Inetpub\vhosts\s-r-s.org.uk\httpdocs\Bookstall\install\model\upgrade\1000.php on line 149Notice: Undefined index: Tables_in_Bookstall in C:\Inetpub\vhosts\s-r-s.org.uk\httpdocs\Bookstall\install\model\upgrade\1000.php on line 149Notice: Undefined index: Tables_in_Bookstall in C:\Inetpub\vhosts\s-r-s.org.uk\httpdocs\Bookstall\install\model\upgrade\1000.php on line 149Notice: Undefined index: Tables_in_Bookstall in C:\Inetpub\vhosts\s-r-s.org.uk\httpdocs\Bookstall\install\model\upgrade\1000.php on line 149Notice: Undefined index: Tables_in_Bookstall in C:\Inetpub\vhosts\s-r-s.org.uk\httpdocs\Bookstall\install\model\upgrade\1000.php on line 149Notice: Undefined index: Tables_in_Bookstall in C:\Inetpub\vhosts\s-r-s.org.uk\httpdocs\Bookstall\install\model\upgrade\1000.php on line 149Notice: Undefined index: Tables_in_Bookstall in C:\Inetpub\vhosts\s-r-s.org.uk\httpdocs\Bookstall\install\model\upgrade\1000.php on line 149Notice: Undefined index: Tables_in_Bookstall in C:\Inetpub\vhosts\s-r-s.org.uk\httpdocs\Bookstall\install\model\upgrade\1000.php on line 149Notice: Undefined index: Tables_in_Bookstall in C:\Inetpub\vhosts\s-r-s.org.uk\httpdocs\Bookstall\install\model\upgrade\1000.php on line 149Notice: Undefined index: Tables_in_Bookstall in C:\Inetpub\vhosts\s-r-s.org.uk\httpdocs\Bookstall\install\model\upgrade\1000.php on line 149Notice: Undefined index: Tables_in_Bookstall in C:\Inetpub\vhosts\s-r-s.org.uk\httpdocs\Bookstall\install\model\upgrade\1000.php on line 149Notice: Undefined index: Tables_in_Bookstall in C:\Inetpub\vhosts\s-r-s.org.uk\httpdocs\Bookstall\install\model\upgrade\1000.php on line 149Notice: Undefined index: Tables_in_Bookstall in C:\Inetpub\vhosts\s-r-s.org.uk\httpdocs\Bookstall\install\model\upgrade\1000.php on line 149Notice: Undefined index: Tables_in_Bookstall in C:\Inetpub\vhosts\s-r-s.org.uk\httpdocs\Bookstall\install\model\upgrade\1000.php on line 149Notice: Undefined index: Tables_in_Bookstall in C:\Inetpub\vhosts\s-r-s.org.uk\httpdocs\Bookstall\install\model\upgrade\1000.php on line 149Notice: Undefined index: Tables_in_Bookstall in C:\Inetpub\vhosts\s-r-s.org.uk\httpdocs\Bookstall\install\model\upgrade\1000.php on line 149Notice: Undefined index: Tables_in_Bookstall in C:\Inetpub\vhosts\s-r-s.org.uk\httpdocs\Bookstall\install\model\upgrade\1000.php on line 149Notice: Undefined index: Tables_in_Bookstall in C:\Inetpub\vhosts\s-r-s.org.uk\httpdocs\Bookstall\install\model\upgrade\1000.php on line 149Notice: Undefined index: Tables_in_Bookstall in C:\Inetpub\vhosts\s-r-s.org.uk\httpdocs\Bookstall\install\model\upgrade\1000.php on line 149Notice: Undefined index: Tables_in_Bookstall in C:\Inetpub\vhosts\s-r-s.org.uk\httpdocs\Bookstall\install\model\upgrade\1000.php on line 149Notice: Undefined index: Tables_in_Bookstall in C:\Inetpub\vhosts\s-r-s.org.uk\httpdocs\Bookstall\install\model\upgrade\1000.php on line 149Notice: Undefined index: Tables_in_Bookstall in C:\Inetpub\vhosts\s-r-s.org.uk\httpdocs\Bookstall\install\model\upgrade\1000.php on line 149Notice: Undefined index: Tables_in_Bookstall in C:\Inetpub\vhosts\s-r-s.org.uk\httpdocs\Bookstall\install\model\upgrade\1000.php on line 149Notice: Undefined index: Tables_in_Bookstall in C:\Inetpub\vhosts\s-r-s.org.uk\httpdocs\Bookstall\install\model\upgrade\1000.php on line 149Notice: Undefined index: Tables_in_Bookstall in C:\Inetpub\vhosts\s-r-s.org.uk\httpdocs\Bookstall\install\model\upgrade\1000.php on line 149Notice: Undefined index: Tables_in_Bookstall in C:\Inetpub\vhosts\s-r-s.org.uk\httpdocs\Bookstall\install\model\upgrade\1000.php on line 149Notice: Undefined index: Tables_in_Bookstall in C:\Inetpub\vhosts\s-r-s.org.uk\httpdocs\Bookstall\install\model\upgrade\1000.php on line 149Notice: Undefined index: Tables_in_Bookstall in C:\Inetpub\vhosts\s-r-s.org.uk\httpdocs\Bookstall\install\model\upgrade\1000.php on line 149Notice: Undefined index: Tables_in_Bookstall in C:\Inetpub\vhosts\s-r-s.org.uk\httpdocs\Bookstall\install\model\upgrade\1000.php on line 149Notice: Undefined index: Tables_in_Bookstall in C:\Inetpub\vhosts\s-r-s.org.uk\httpdocs\Bookstall\install\model\upgrade\1000.php on line 149Notice: Undefined index: Tables_in_Bookstall in C:\Inetpub\vhosts\s-r-s.org.uk\httpdocs\Bookstall\install\model\upgrade\1000.php on line 149Notice: Undefined index: Tables_in_Bookstall in C:\Inetpub\vhosts\s-r-s.org.uk\httpdocs\Bookstall\install\model\upgrade\1000.php on line 149Notice: Undefined index: Tables_in_Bookstall in C:\Inetpub\vhosts\s-r-s.org.uk\httpdocs\Bookstall\install\model\upgrade\1000.php on line 149Notice: Undefined index: Tables_in_Bookstall in C:\Inetpub\vhosts\s-r-s.org.uk\httpdocs\Bookstall\install\model\upgrade\1000.php on line 149Notice: Undefined index: Tables_in_Bookstall in C:\Inetpub\vhosts\s-r-s.org.uk\httpdocs\Bookstall\install\model\upgrade\1000.php on line 149Notice: Undefined index: Tables_in_Bookstall in C:\Inetpub\vhosts\s-r-s.org.uk\httpdocs\Bookstall\install\model\upgrade\1000.php on line 149Notice: Undefined index: Tables_in_Bookstall in C:\Inetpub\vhosts\s-r-s.org.uk\httpdocs\Bookstall\install\model\upgrade\1000.php on line 149Notice: Undefined index: Tables_in_Bookstall in C:\Inetpub\vhosts\s-r-s.org.uk\httpdocs\Bookstall\install\model\upgrade\1000.php on line 149Notice: Undefined index: Tables_in_Bookstall in C:\Inetpub\vhosts\s-r-s.org.uk\httpdocs\Bookstall\install\model\upgrade\1000.php on line 149Notice: Undefined index: Tables_in_Bookstall in C:\Inetpub\vhosts\s-r-s.org.uk\httpdocs\Bookstall\install\model\upgrade\1000.php on line 149Notice: Undefined index: Tables_in_Bookstall in C:\Inetpub\vhosts\s-r-s.org.uk\httpdocs\Bookstall\install\model\upgrade\1000.php on line 149Notice: Undefined index: Tables_in_Bookstall in C:\Inetpub\vhosts\s-r-s.org.uk\httpdocs\Bookstall\install\model\upgrade\1000.php on line 149Notice: Undefined index: Tables_in_Bookstall in C:\Inetpub\vhosts\s-r-s.org.uk\httpdocs\Bookstall\install\model\upgrade\1000.php on line 149Notice: Undefined index: Tables_in_Bookstall in C:\Inetpub\vhosts\s-r-s.org.uk\httpdocs\Bookstall\install\model\upgrade\1000.php on line 149Notice: Undefined index: Tables_in_Bookstall in C:\Inetpub\vhosts\s-r-s.org.uk\httpdocs\Bookstall\install\model\upgrade\1000.php on line 149Notice: Undefined index: Tables_in_Bookstall in C:\Inetpub\vhosts\s-r-s.org.uk\httpdocs\Bookstall\install\model\upgrade\1000.php on line 149Notice: Undefined index: Tables_in_Bookstall in C:\Inetpub\vhosts\s-r-s.org.uk\httpdocs\Bookstall\install\model\upgrade\1000.php on line 149Notice: Undefined index: Tables_in_Bookstall in C:\Inetpub\vhosts\s-r-s.org.uk\httpdocs\Bookstall\install\model\upgrade\1000.php on line 149Notice: Undefined index: Tables_in_Bookstall in C:\Inetpub\vhosts\s-r-s.org.uk\httpdocs\Bookstall\install\model\upgrade\1000.php on line 149Notice: Undefined index: Tables_in_Bookstall in C:\Inetpub\vhosts\s-r-s.org.uk\httpdocs\Bookstall\install\model\upgrade\1000.php on line 149Notice: Undefined index: Tables_in_Bookstall in C:\Inetpub\vhosts\s-r-s.org.uk\httpdocs\Bookstall\install\model\upgrade\1000.php on line 149Notice: Undefined index: Tables_in_Bookstall in C:\Inetpub\vhosts\s-r-s.org.uk\httpdocs\Bookstall\install\model\upgrade\1000.php on line 149Notice: Undefined index: Tables_in_Bookstall in C:\Inetpub\vhosts\s-r-s.org.uk\httpdocs\Bookstall\install\model\upgrade\1000.php on line 149Notice: Undefined index: Tables_in_Bookstall in C:\Inetpub\vhosts\s-r-s.org.uk\httpdocs\Bookstall\install\model\upgrade\1000.php on line 149Notice: Undefined index: Tables_in_Bookstall in C:\Inetpub\vhosts\s-r-s.org.uk\httpdocs\Bookstall\install\model\upgrade\1000.php on line 149Notice: Undefined index: Tables_in_Bookstall in C:\Inetpub\vhosts\s-r-s.org.uk\httpdocs\Bookstall\install\model\upgrade\1000.php on line 149Notice: Undefined index: Tables_in_Bookstall in C:\Inetpub\vhosts\s-r-s.org.uk\httpdocs\Bookstall\install\model\upgrade\1000.php on line 149Notice: Undefined index: Tables_in_Bookstall in C:\Inetpub\vhosts\s-r-s.org.uk\httpdocs\Bookstall\install\model\upgrade\1000.php on line 149Notice: Undefined index: Tables_in_Bookstall in C:\Inetpub\vhosts\s-r-s.org.uk\httpdocs\Bookstall\install\model\upgrade\1000.php on line 149Notice: Undefined index: Tables_in_Bookstall in C:\Inetpub\vhosts\s-r-s.org.uk\httpdocs\Bookstall\install\model\upgrade\1000.php on line 149Notice: Undefined index: Tables_in_Bookstall in C:\Inetpub\vhosts\s-r-s.org.uk\httpdocs\Bookstall\install\model\upgrade\1000.php on line 149Notice: Undefined index: Tables_in_Bookstall in C:\Inetpub\vhosts\s-r-s.org.uk\httpdocs\Bookstall\install\model\upgrade\1000.php on line 149Notice: Undefined index: Tables_in_Bookstall in C:\Inetpub\vhosts\s-r-s.org.uk\httpdocs\Bookstall\install\model\upgrade\1000.php on line 149Notice: Undefined index: Tables_in_Bookstall in C:\Inetpub\vhosts\s-r-s.org.uk\httpdocs\Bookstall\install\model\upgrade\1000.php on line 149Notice: Undefined index: Tables_in_Bookstall in C:\Inetpub\vhosts\s-r-s.org.uk\httpdocs\Bookstall\install\model\upgrade\1000.php on line 149Notice: Undefined index: Tables_in_Bookstall in C:\Inetpub\vhosts\s-r-s.org.uk\httpdocs\Bookstall\install\model\upgrade\1000.php on line 149Notice: Undefined index: Tables_in_Bookstall in C:\Inetpub\vhosts\s-r-s.org.uk\httpdocs\Bookstall\install\model\upgrade\1000.php on line 149Notice: Undefined index: Tables_in_Bookstall in C:\Inetpub\vhosts\s-r-s.org.uk\httpdocs\Bookstall\install\model\upgrade\1000.php on line 149Notice: Undefined index: Tables_in_Bookstall in C:\Inetpub\vhosts\s-r-s.org.uk\httpdocs\Bookstall\install\model\upgrade\1000.php on line 149Notice: Undefined index: Tables_in_Bookstall in C:\Inetpub\vhosts\s-r-s.org.uk\httpdocs\Bookstall\install\model\upgrade\1000.php on line 149Notice: Undefined index: Tables_in_Bookstall in C:\Inetpub\vhosts\s-r-s.org.uk\httpdocs\Bookstall\install\model\upgrade\1000.php on line 149Notice: Undefined index: Tables_in_Bookstall in C:\Inetpub\vhosts\s-r-s.org.uk\httpdocs\Bookstall\install\model\upgrade\1000.php on line 149Notice: Undefined index: Tables_in_Bookstall in C:\Inetpub\vhosts\s-r-s.org.uk\httpdocs\Bookstall\install\model\upgrade\1000.php on line 149Notice: Undefined index: Tables_in_Bookstall in C:\Inetpub\vhosts\s-r-s.org.uk\httpdocs\Bookstall\install\model\upgrade\1000.php on line 149Notice: Undefined index: Tables_in_Bookstall in C:\Inetpub\vhosts\s-r-s.org.uk\httpdocs\Bookstall\install\model\upgrade\1000.php on line 149Notice: Undefined index: Tables_in_Bookstall in C:\Inetpub\vhosts\s-r-s.org.uk\httpdocs\Bookstall\install\model\upgrade\1000.php on line 149Notice: Undefined index: Tables_in_Bookstall in C:\Inetpub\vhosts\s-r-s.org.uk\httpdocs\Bookstall\install\model\upgrade\1000.php on line 149Notice: Undefined index: Tables_in_Bookstall in C:\Inetpub\vhosts\s-r-s.org.uk\httpdocs\Bookstall\install\model\upgrade\1000.php on line 149Notice: Undefined index: Tables_in_Bookstall in C:\Inetpub\vhosts\s-r-s.org.uk\httpdocs\Bookstall\install\model\upgrade\1000.php on line 149Notice: Undefined index: Tables_in_Bookstall in C:\Inetpub\vhosts\s-r-s.org.uk\httpdocs\Bookstall\install\model\upgrade\1000.php on line 149Notice: Undefined index: Tables_in_Bookstall in C:\Inetpub\vhosts\s-r-s.org.uk\httpdocs\Bookstall\install\model\upgrade\1000.php on line 149Notice: Undefined index: Tables_in_Bookstall in C:\Inetpub\vhosts\s-r-s.org.uk\httpdocs\Bookstall\install\model\upgrade\1000.php on line 149Notice: Undefined index: Tables_in_Bookstall in C:\Inetpub\vhosts\s-r-s.org.uk\httpdocs\Bookstall\install\model\upgrade\1000.php on line 149Notice: Undefined index: Tables_in_Bookstall in C:\Inetpub\vhosts\s-r-s.org.uk\httpdocs\Bookstall\install\model\upgrade\1000.php on line 149Notice: Undefined index: Tables_in_Bookstall in C:\Inetpub\vhosts\s-r-s.org.uk\httpdocs\Bookstall\install\model\upgrade\1000.php on line 149Notice: Undefined index: Tables_in_Bookstall in C:\Inetpub\vhosts\s-r-s.org.uk\httpdocs\Bookstall\install\model\upgrade\1000.php on line 149Notice: Undefined index: Tables_in_Bookstall in C:\Inetpub\vhosts\s-r-s.org.uk\httpdocs\Bookstall\install\model\upgrade\1000.php on line 149Notice: Undefined index: Tables_in_Bookstall in C:\Inetpub\vhosts\s-r-s.org.uk\httpdocs\Bookstall\install\model\upgrade\1000.php on line 149Notice: Undefined index: Tables_in_Bookstall in C:\Inetpub\vhosts\s-r-s.org.uk\httpdocs\Bookstall\install\model\upgrade\1000.php on line 149Notice: Undefined index: Tables_in_Bookstall in C:\Inetpub\vhosts\s-r-s.org.uk\httpdocs\Bookstall\install\model\upgrade\1000.php on line 149Notice: Undefined index: Tables_in_Bookstall in C:\Inetpub\vhosts\s-r-s.org.uk\httpdocs\Bookstall\install\model\upgrade\1000.php on line 149Notice: Undefined index: Tables_in_Bookstall in C:\Inetpub\vhosts\s-r-s.org.uk\httpdocs\Bookstall\install\model\upgrade\1000.php on line 149Notice: Undefined index: Tables_in_Bookstall in C:\Inetpub\vhosts\s-r-s.org.uk\httpdocs\Bookstall\install\model\upgrade\1000.php on line 149Notice: Undefined index: Tables_in_Bookstall in C:\Inetpub\vhosts\s-r-s.org.uk\httpdocs\Bookstall\install\model\upgrade\1000.php on line 149Notice: Undefined index: Tables_in_Bookstall in C:\Inetpub\vhosts\s-r-s.org.uk\httpdocs\Bookstall\install\model\upgrade\1000.php on line 149Notice: Undefined index: Tables_in_Bookstall in C:\Inetpub\vhosts\s-r-s.org.uk\httpdocs\Bookstall\install\model\upgrade\1000.php on line 149Notice: Undefined index: Tables_in_Bookstall in C:\Inetpub\vhosts\s-r-s.org.uk\httpdocs\Bookstall\install\model\upgrade\1000.php on line 149Notice: Undefined index: Tables_in_Bookstall in C:\Inetpub\vhosts\s-r-s.org.uk\httpdocs\Bookstall\install\model\upgrade\1000.php on line 149Notice: Undefined index: Tables_in_Bookstall in C:\Inetpub\vhosts\s-r-s.org.uk\httpdocs\Bookstall\install\model\upgrade\1000.php on line 149Notice: Undefined index: Tables_in_Bookstall in C:\Inetpub\vhosts\s-r-s.org.uk\httpdocs\Bookstall\install\model\upgrade\1000.php on line 149Notice: Undefined index: Tables_in_Bookstall in C:\Inetpub\vhosts\s-r-s.org.uk\httpdocs\Bookstall\install\model\upgrade\1000.php on line 149Notice: Undefined index: Tables_in_Bookstall in C:\Inetpub\vhosts\s-r-s.org.uk\httpdocs\Bookstall\install\model\upgrade\1000.php on line 149Notice: Undefined index: Tables_in_Bookstall in C:\Inetpub\vhosts\s-r-s.org.uk\httpdocs\Bookstall\install\model\upgrade\1000.php on line 149Notice: Undefined index: Tables_in_Bookstall in C:\Inetpub\vhosts\s-r-s.org.uk\httpdocs\Bookstall\install\model\upgrade\1000.php on line 149Notice: Undefined index: Tables_in_Bookstall in C:\Inetpub\vhosts\s-r-s.org.uk\httpdocs\Bookstall\install\model\upgrade\1000.php on line 149Notice: Undefined index: Tables_in_Bookstall in C:\Inetpub\vhosts\s-r-s.org.uk\httpdocs\Bookstall\install\model\upgrade\1000.php on line 149Notice: Undefined index: Tables_in_Bookstall in C:\Inetpub\vhosts\s-r-s.org.uk\httpdocs\Bookstall\install\model\upgrade\1000.php on line 149Notice: Undefined index: Tables_in_Bookstall in C:\Inetpub\vhosts\s-r-s.org.uk\httpdocs\Bookstall\install\model\upgrade\1000.php on line 149Notice: Undefined index: Tables_in_Bookstall in C:\Inetpub\vhosts\s-r-s.org.uk\httpdocs\Bookstall\install\model\upgrade\1000.php on line 149Notice: Undefined index: Tables_in_Bookstall in C:\Inetpub\vhosts\s-r-s.org.uk\httpdocs\Bookstall\install\model\upgrade\1000.php on line 149Notice: Undefined index: Tables_in_Bookstall in C:\Inetpub\vhosts\s-r-s.org.uk\httpdocs\Bookstall\install\model\upgrade\1000.php on line 149Notice: Undefined index: Tables_in_Bookstall in C:\Inetpub\vhosts\s-r-s.org.uk\httpdocs\Bookstall\install\model\upgrade\1000.php on line 149{"error":"Error Code(0): Error: Table 'bk_address' already exists
Error No: 1050
CREATE TABLE `bk_address` (\r\n `address_id` int(11) NOT NULL AUTO_INCREMENT,\r\n `customer_id` int(11) NOT NULL,\r\n `firstname` varchar(32) NOT NULL,\r\n `lastname` varchar(32) NOT NULL,\r\n `company` varchar(40) NOT NULL,\r\n `address_1` varchar(128) NOT NULL,\r\n `address_2` varchar(128) NOT NULL,\r\n `city` varchar(128) NOT NULL,\r\n `postcode` varchar(10) NOT NULL,\r\n `country_id` int(11) NOT NULL DEFAULT '0',\r\n `zone_id` int(11) NOT NULL DEFAULT '0',\r\n `custom_field` text NOT NULL,\r\n PRIMARY KEY (`address_id`),\r\n KEY `customer_id` (`customer_id`)\r\n) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci in C:\\Inetpub\\vhosts\\s-r-s.org.uk\\httpdocs\\Bookstall\\system\\library\\db\\mysqli.php on line 40"}

Please advise how to clear these.
Thanks.

I would suggest to create a new service request in the Commercial Support section of the forum to get this done as a custom job.

Thank you for responding.
I eventually abandoned the upgrade and reverted to the older version.
Having listened to the video describing an upgrade process - essentially install new and export from old to new - I'll have a think through before attempting further.
One lesson for me - don't attempt upgrades on Friday afternoons. Start on Monday morning when the whole week is available!
John

Try to upgrade first from 1.5. to 2.1.0.2, then to 2.3.0.2, then to 3.0.2.0.

It is easy to upgrade from 1.5.6.4 to 2.3.0.2.
Not tested from 2.3.0.2 to 3.0.2.0. I don`t use 3.x version

The v3.1.0.0's (alpha) upgrade infrastructure has been improved in order to avoid upgrading between all these OC versions. Testing a database upgrade should always be done by following these steps: viewtopic.php?f=176&p=731764#p730051