OpenCart Community

I met a problem on opencart 2.0.1.1, I can not edit the orders in backend.
Every time the same error:
SyntaxError Unexpected end of input OK


I already did all these things:
1. In Opencart Admin, go to Settings >> API and create a new user.
2. In cPanel navigate to phpMyAdmin and then select your database where your store is installed.
3. Find table oc_setting and then find key "config_api_id".
4. Set the value field to 1 where key = config_ap_id (it was set to 0 on my system).
5. Next go to table oc_api and check that api_id = 1

Problem still not resolve, I found many many solution, but all not work for me.
I think maybe this is a bug for the software.
I hope somebody can help me.

Is your site in maintainence mode? You should turn it off.

My shop is not in maintenance mode. I already turn it off.

I looked all over the internet and found no answer.

Basically my problem is whenever I try to edit orders and change stores I get the SyntaxError: JSON.parse: unexpected end of data at line 1 column 1 of the JSON data OK in firefox and in chrome I get SyntaxError: Unexpected end of input OK.

Has anyone found a "real" solution for this because I tried all that was suggested but they don't work. From changing the api_id to making a secondary API. And even the .htaccess method.

I have exactly the same problem.

When I try to edit an order in admin panel, I get the following error:

On Google Chrome display:
"SyntaxError Unexpected end of input OK"

On Firefox display:
"SyntaxError: Json.parse: unexpected end of data at line 1 column 1 of the JSON Data OK"

Things that I tried:

A)
1. In Opencart Admin, go to Settings >> API and create a new user.
2. In cPanel navigate to phpMyAdmin and then select your database where your store is installed.
3. Find table oc_setting and then find key "config_api_id".
4. Set the value field to 1 where key = config_ap_id
5. Next go to table oc_api and check that api_id = 1

In my database it was set correctly to "1"

B) My site is NOT in maintenance mode.

C) mod_security is OFF

D) file htaccess is disabled. It named htaccess.txt, as it a new fresh installation of opencart 2.0.1.1

Any other ideas?

I'm desperate for an answer to this as well.
I too have tried adjusting maintenance mode, and user group settings, and have even double checked the table data.
Nothing has fixed this.
Please help!

I have exactly the same problem. Can someone please help

I have also talked to my hoster and they are not using mod_security but suhosin.
I have no idea what this is. can this be the problem??

Please help!

Thanks

I have the same problem, I cannot edit any orders and I cannot change the order status.

chilledworld wrote:I have the same problem, I cannot edit any orders and I cannot change the order status.

First: Why this is in Bugs thread?

You see in admin setting/setting > edit > tab option > API user.
Is it enabled?

I have tried all these things but nothing works

A)
1. In Opencart Admin, go to Settings >> API and create a new user.
2. In cPanel navigate to phpMyAdmin and then select your database where your store is installed.
3. Find table oc_setting and then find key "config_api_id".
4. Set the value field to 1 where key = config_ap_id
5. Next go to table oc_api and check that api_id = 1

In my database it was set correctly to "1"

B) My site is NOT in maintenance mode.

C) mod_security is OFF

D) file htaccess is disabled. It named htaccess.txt, as it a new fresh installation of opencart 2.0.1.1


Mod_security is not enabled but suhosin

bleekk wrote:I have tried all these things but nothing works

A)
1. In Opencart Admin, go to Settings >> API and create a new user.
2. In cPanel navigate to phpMyAdmin and then select your database where your store is installed.
3. Find table oc_setting and then find key "config_api_id".
4. Set the value field to 1 where key = config_ap_id
5. Next go to table oc_api and check that api_id = 1

In my database it was set correctly to "1"

B) My site is NOT in maintenance mode.

C) mod_security is OFF

D) file htaccess is disabled. It named htaccess.txt, as it a new fresh installation of opencart 2.0.1.1


Mod_security is not enabled but suhosin

If this is not work (even if all the settings are correct) error is your server. you may ask in web hosting, is it php cURL Library in Use?

I have tested all possible solutions in this topic and don't work.

The cURL is activated.

On my hoster cURL is also activated

rlasmar wrote:I have tested all possible solutions in this topic and don't work.

The cURL is activated.

Do you mean that the session 'cookie' is found?

http://forum.opencart.com/viewtopic.php ... pi#p531625

I have the same issue..
Can't edit orders can't delete orders and any interaction with orders slows down the site.

I have the same issue..

https://github.com/opencart/opencart/issues/2775

Finally I got it!

My PHP Version was 5.3 with "Magic Quotes GPC" ON
This "Magic Quotes GPC" is deprecated since PHP Version 5.4

So I changed the PHP Version to 5.4 and now everything is working fine

Quite funny ...

Step 2 of the installer shows everyone the result of the magic_quotes setting.
Red = ON, Green = OFF (should be green!).

What for do you think is this?
Just for fun .. ?

No I do not think that this is for fun.
But the Shop was not developed on the productive server but localy and was transported to the productive server.

Unfortunately the server settings were not same.