Post by Webdragonaz » Tue Jan 23, 2018 11:43 am

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

Newbie

Posts

Joined
Wed Oct 25, 2017 11:05 am

Post by straightlight » Wed Jan 24, 2018 4:49 am

I installed open cart 3
Imprecise version provided. 4 decimals used by opencart.com .

Dedication and passion goes to those who are able to push and merge a project.

Regards,
Straightlight
Programmer / Opencart Tester


Legendary Member

Posts

Joined
Mon Nov 14, 2011 11:38 pm
Location - Canada, ON

Post by sandraolt » Thu Feb 01, 2018 5:36 am

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.

New member

Posts

Joined
Thu Aug 01, 2013 2:51 am

Post by Printopia » Thu Feb 01, 2018 3:07 pm

Thanks Sandra, solved the issue for me.

Newbie

Posts

Joined
Fri Mar 04, 2016 11:35 pm
Who is online

Users browsing this forum: No registered users and 141 guests