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 .

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
Opencart.com Administrator / Quality Assurance Analyst / Programmer


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.

Newbie

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 13 guests