Versión 3.0.3.7
When in Sales > Orders I am selecting an order and try adding an information in the history I am getting a "Warning: You do not have permission to access the API!"
I found around this forum and stackoverflow several people with the same issue but couldn't fix it.
What I tried is the following
In System > User > API I tried generating the API again, add my IP address and save
Then in System > Settings > Edit > Option I made sure the default API user was selected and save
I also tried to create a new API user but none of what I did seems to have any effect.
When in Sales > Orders I am selecting an order and try adding an information in the history I am getting a "Warning: You do not have permission to access the API!"
I found around this forum and stackoverflow several people with the same issue but couldn't fix it.
What I tried is the following
In System > User > API I tried generating the API again, add my IP address and save
Then in System > Settings > Edit > Option I made sure the default API user was selected and save
I also tried to create a new API user but none of what I did seems to have any effect.
Admin > Systems > Settings > edit settings > Option Tab.
Dedication and passion goes to those who are able to push and merge a project.
Regards,
Straightlight
Programmer / Opencart Tester
Good to know that this issue also affects the APIs ...aj.cox131991 wrote: ↑Fri May 20, 2022 1:24 pmBit of a necropost, but THANK YOU! This fixed this very issue for me.
Dedication and passion goes to those who are able to push and merge a project.
Regards,
Straightlight
Programmer / Opencart Tester
The GitHub issue for the timezone affecting the API is here, if anyone is interested. https://github.com/opencart/opencart/issues/9492straightlight wrote: ↑Fri May 20, 2022 6:30 pmGood to know that this issue also affects the APIs ...aj.cox131991 wrote: ↑Fri May 20, 2022 1:24 pmBit of a necropost, but THANK YOU! This fixed this very issue for me.
This worked for me after trying all sorts of other solutions so Thank You CódigoNET.
Just a slight addition for other people: UPDATE `ocxx_setting` SET `value` = 'UTC' WHERE `key` = 'config_timezone';
where xx in ocxx_setting will vary depending on your database.
Having similar issues in OC 3.0.3.8 maintenance release where I do not have permission to modify orders.
PHP 8.0.X.
Trying to work through the final issues going from 3.0.3.8 to maintenance release.
As posted elsewhere I've had to edit the db to make them compatible now including oc_api which had field names (first, last) and extra value columns the 3.0.3.8 maintenance release will not accept.
If I set UPDATE `oc_setting` SET `value` = 'UTC' WHERE `key` = 'config_timezone';
I receive this error: date_default_timezone_set(): Timezone ID 'UTC WHERE' is invalid in <b>/var/www/clients/client14/web50/web/shop/admin/controller/startup/startup.php
I have checked that editing orders is permitted (all are) have a working store .
If I set the timezone in oc_settings to anything other than UTC I cannot login as admin.
PHP 8.0.X.
Trying to work through the final issues going from 3.0.3.8 to maintenance release.
As posted elsewhere I've had to edit the db to make them compatible now including oc_api which had field names (first, last) and extra value columns the 3.0.3.8 maintenance release will not accept.
If I set UPDATE `oc_setting` SET `value` = 'UTC' WHERE `key` = 'config_timezone';
I receive this error: date_default_timezone_set(): Timezone ID 'UTC WHERE' is invalid in <b>/var/www/clients/client14/web50/web/shop/admin/controller/startup/startup.php
I have checked that editing orders is permitted (all are) have a working store .
If I set the timezone in oc_settings to anything other than UTC I cannot login as admin.
Check the value of config_timezone directly in the oc_setting table in your database, it looks like it might be an invalid value.mediatechnology2 wrote: ↑Mon Sep 25, 2023 2:03 amHaving similar issues in OC 3.0.3.8 maintenance release where I do not have permission to modify orders.
PHP 8.0.X.
Trying to work through the final issues going from 3.0.3.8 to maintenance release.
As posted elsewhere I've had to edit the db to make them compatible now including oc_api which had field names (first, last) and extra value columns the 3.0.3.8 maintenance release will not accept.
If I set UPDATE `oc_setting` SET `value` = 'UTC' WHERE `key` = 'config_timezone';
I receive this error: date_default_timezone_set(): Timezone ID 'UTC WHERE' is invalid in <b>/var/www/clients/client14/web50/web/shop/admin/controller/startup/startup.php
I have checked that editing orders is permitted (all are) have a working store .
If I set the timezone in oc_settings to anything other than UTC I cannot login as admin.
If you do want to change the time zone you need to change it in the settings and also in system/config/default.php. See https://github.com/opencart/opencart/is ... -814312649.
Expanding further: Admin > Systems > Settings > edit settings > Option Tab>Enable api Userstraightlight wrote: ↑Thu May 06, 2021 10:35 pmAdmin > Systems > Settings > edit settings > Option Tab.
I didn't pay attention to this post and when I re-read it and realized this was the final solution to a problem. A corrupt db import had disabled api users. Though I had fixed oc_api in the db (it contained extra field columns) the fact that it had been corrupted prevented api Users from being enabled in settings.
Thank you.
Who is online
Users browsing this forum: No registered users and 154 guests