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
Dedication and passion goes to those who are able to push and merge a project.
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: Amazon [Bot] and 169 guests