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
Imprecise version provided. 4 decimals used by opencart.com .I installed open cart 3
The most generated errors being found on Opencart forum originates from contributed programming. The increased post counters are caused by redundancies of the same solutions that were already provided prior.
Regards,
Straightlight
Programmer / Opencart Tester
The problem is in the 1009.php file. Search for 'affiliatee' and correct the spelling to 'affiliate'. Then it will work.
Sandra King.
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.Webdragonaz wrote: ↑Tue Jan 23, 2018 11:43 amSyntaxError: 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'
Sandra King.
Who is online
Users browsing this forum: No registered users and 8 guests