OpenCart Community

I installed open cart 3 that i downloaded from the open cart website uploaded and followed the install instructions but it updated and now i get an error while doing the update

SyntaxError: JSON.parse: unexpected character at line 1 column 1 of the JSON data OK Notice: Undefined variable: affiliatee in /home/xxxxx/public_html/install/model/upgrade/1009.php on line 23{"error":"Error Code(0): Error: Unknown column 'approved' in 'field list'
Error No: 1054
INSERT INTO `oc_customer` SET `customer_group_id` = '1', `language_id` = '1', `firstname` = 'jonathan', `lastname` = 'snoock', `email` = 'snooka@gamil.com', `telephone` = '01234567890', `password` = '50ddb360038cdd73120ca4f5eab65b6e921913af', `salt` = 'b296e924d', `cart` = '[]', `wishlist` = '[]', `newsletter` = '0', `custom_field` = '[]', `ip` = '', `status` = '1', `approved` = '0', `date_added` = '2013-10-01 16:24:50' in \/home\/kingsof3\/public_html\/system\/library\/db\/mysqli.php on line 40"}

Upgrade
Finished

What did i do wrong and how do i fix it?

Thanks in advance

I installed open cart 3

Imprecise version provided. 4 decimals used by opencart.com .

The problem is in the 1009.php file. Search for 'affiliatee' and correct the spelling to 'affiliate'. Then it will work.

Webdragonaz wrote: ↑

Tue Jan 23, 2018 11:43 am

SyntaxError: JSON.parse: unexpected character at line 1 column 1 of the JSON data OK Notice: Undefined variable: affiliatee in /home/xxxxx/public_html/install/model/upgrade/1009.php on line 23{"error":"Error Code(0): Error: Unknown column 'approved' in 'field list'

When I was getting that error, I had to start the upgrade all over again. I edited the 1009.php file (it is in install/model/upgrade) and was able to finish the upgrade.

Sandra King.

Thanks Sandra, solved the issue for me.