Page 1 of 1

Version 2.1.0.1 - Orders error table Need urgent help

Posted: Sun Dec 06, 2015 5:38 am
by bestbuyseller
Hi been creating a webiste on open cart - www.ukcanvas.co.uk and when i click on the orders tab when logged in as admin or any user i get the following error:

SyntaxError: JSON.parse: unexpected character at line 1 column 1 of the JSON data

OK

<b>Notice</b>: Error: Table 'i1928438_oc1.oc_api_ip' doesn't exist<br />Error No: 1146<br />SELECT * FROM `oc_api_ip` WHERE api_id = '0' in <b>/home/bestbuyseller/public_html/system/library/db/mysqli.php</b> on line <b>41</b><b>Notice</b>: Trying to get property of non-object in <b>/home/bestbuyseller/public_html/catalog/model/account/api.php</b> on line <b>59</b><b>Warning</b>: Invalid argument supplied for foreach() in <b>/home/bestbuyseller/public_html/catalog/controller/api/login.php</b> on line <b>15</b>{"error":{"ip":"Warning: Your IP 90.222.0.217 is not allowed to access this API!"}}

Also when i try and update a order status to anything i.e processing dispatched i get the the same error message.

Any help would be greatly appreciated, Thanks in advance.

Re: Version 2.1.0.1 - Orders error table Need urgent help

Posted: Tue Dec 29, 2015 7:14 pm
by jty
Hi,
This bit of the error message gives a clue

Code: Select all

Error: Table 'i1928438_oc1.oc_api_ip' doesn't exist
Does the table "i1928438_oc1.oc_api_ip" exist ? Check your database as a start