Post by straightlight » Wed Jul 26, 2023 5:29 am

straightlight wrote:
Wed Jul 26, 2023 5:21 am
Hourglasss wrote:
Wed Jul 26, 2023 5:20 am
straightlight wrote:
Wed Jul 26, 2023 5:14 am


Which database engine are you using?
Image

InnoDB
Which database charset and collate are you using?
Based on this original issue:
Hourglasss wrote:
Thu Jul 20, 2023 4:54 pm
All order status drop boxes in admin panel are empty and cant change / save settings cause the value is empty to im using latest opencart from github
4.0.2.2 i connected to my old database from my previous store is that the cause maybe would i need ot make a new DB? i assume new DB layout changed since codebase changed?
Empty your OC error logs from your OC admin > systems > maintenance > error logs page. Then, in admin/controller/setting/setting.php file,

In the save() method, find:

Code: Select all

if (!$json) {
add below:

Code: Select all

$this->log->write('Before saving settings: ' . print_r($this->request->post));
Then, find underneath it:

Code: Select all

$this->model_setting_setting->editSetting('config', $this->request->post);
Add below:

Code: Select all

$this->log->write('After saving settings: ' . print_r($this->request->post));
Then, try to save your settings again from your OC admin > systems > settings > edit store page. Lastly, check your OC error logs again noticing both activities if they're showing and check your server error logs in regard to your setting/setting controller's actions.

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 Hourglasss » Wed Jul 26, 2023 5:43 am

straightlight wrote:
Wed Jul 26, 2023 5:29 am
straightlight wrote:
Wed Jul 26, 2023 5:21 am
Hourglasss wrote:
Wed Jul 26, 2023 5:20 am


Image

InnoDB
Which database charset and collate are you using?
Based on this original issue:
Hourglasss wrote:
Thu Jul 20, 2023 4:54 pm
All order status drop boxes in admin panel are empty and cant change / save settings cause the value is empty to im using latest opencart from github
4.0.2.2 i connected to my old database from my previous store is that the cause maybe would i need ot make a new DB? i assume new DB layout changed since codebase changed?
Empty your OC error logs from your OC admin > systems > maintenance > error logs page. Then, in admin/controller/setting/setting.php file,

In the save() method, find:

Code: Select all

if (!$json) {
add below:

Code: Select all

$this->log->write('Before saving settings: ' . print_r($this->request->post));
Then, find underneath it:

Code: Select all

$this->model_setting_setting->editSetting('config', $this->request->post);
Add below:

Code: Select all

$this->log->write('After saving settings: ' . print_r($this->request->post));
Then, try to save your settings again from your OC admin > systems > settings > edit store page. Lastly, check your OC error logs again noticing both activities if they're showing and check your server error logs in regard to your setting/setting controller's actions.
Image


im able to change settings now and i have my order statuses now was this a bug?

Active Member

Posts

Joined
Mon Jan 23, 2023 10:39 pm

Post by Hourglasss » Wed Jul 26, 2023 6:14 am

straightlight wrote:
Wed Jul 26, 2023 5:29 am
straightlight wrote:
Wed Jul 26, 2023 5:21 am
Hourglasss wrote:
Wed Jul 26, 2023 5:20 am


Image

InnoDB
Which database charset and collate are you using?
Based on this original issue:
Hourglasss wrote:
Thu Jul 20, 2023 4:54 pm
All order status drop boxes in admin panel are empty and cant change / save settings cause the value is empty to im using latest opencart from github
4.0.2.2 i connected to my old database from my previous store is that the cause maybe would i need ot make a new DB? i assume new DB layout changed since codebase changed?
Empty your OC error logs from your OC admin > systems > maintenance > error logs page. Then, in admin/controller/setting/setting.php file,

In the save() method, find:

Code: Select all

if (!$json) {
add below:

Code: Select all

$this->log->write('Before saving settings: ' . print_r($this->request->post));
Then, find underneath it:

Code: Select all

$this->model_setting_setting->editSetting('config', $this->request->post);
Add below:

Code: Select all

$this->log->write('After saving settings: ' . print_r($this->request->post));
Then, try to save your settings again from your OC admin > systems > settings > edit store page. Lastly, check your OC error logs again noticing both activities if they're showing and check your server error logs in regard to your setting/setting controller's actions.
im confused maybe my setting.php didnt had read write access?

the stuff you made me add is only for logging what was going on right?

Active Member

Posts

Joined
Mon Jan 23, 2023 10:39 pm

Post by Hourglasss » Wed Jul 26, 2023 6:45 am

just did a new install and it now works out of the box? idk what happend ??? :crazy:
or what im doing different

Active Member

Posts

Joined
Mon Jan 23, 2023 10:39 pm

Post by straightlight » Wed Jul 26, 2023 7:20 am

Hourglasss wrote:
Wed Jul 26, 2023 6:45 am
just did a new install and it now works out of the box? idk what happend ??? :crazy:
or what im doing different
Using your old database with a new one vs. a fresh install with a fresh database don't have the same results obviously. Now that you've decided to run a fresh install and resolved the issue, please add: [SOLVED] at the beginning of the subject line on your first post (but I assume, by now, it has already been done).

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 Hourglasss » Thu Aug 10, 2023 11:54 pm

the issue was that i needed to purge my cloudflare cache

Active Member

Posts

Joined
Mon Jan 23, 2023 10:39 pm

Post by cosmin.dobrescu » Thu Feb 22, 2024 5:46 am

I had the same problem. The issue was related to a missing config value (fresh install)
I fixed by inserting the missing config_language_id in the settings table
eg:
INSERT into oc_setting values (217, 0, 'config', 'config_language_id',1,0);


Posts

Joined
Tue Jan 23, 2018 2:51 am
Who is online

Users browsing this forum: No registered users and 1 guest