OpenCart Community

Hi,

I have installed a module "Hide Dashboard per User Groups - 2.X", which kind of works. Issue with Dashboard Panel selections, displaying and retain Check box selections in "USER GROUP > Dashboard Panels" when settings changed in Admin.

If you change selection and save, it does update Admin page. But when you go back to USER GROUP > Dashboard Panels no selection is shown, all unchecked still.

The developer says to check or increase "database table size". Developer says it can be that your database simply not fits anymore settings into the table (due to limitation of the entries ).

But not getting any advise how to do this or I dont know what that means.

Anyone able to assist?

Thanks Nathan

It would be helpful to give your OpenCart and PHP version.

Are you saying the settings actually work, but it's just that you can't see which settings you have set?

nathanaus wrote: ↑

Mon Oct 07, 2024 1:19 pm

The developer says to check or increase "database table size". Developer says it can be that your database simply not fits anymore settings into the table (due to limitation of the entries ).

Ask them to fix it.

Hi,

@ADD_Creative - "Are you saying the settings actually work, but it's just that you can't see which settings you have set?" Correct Admin does change if you select and SAVE. But the admin check boxes selected do not remain visably checked, once saved for DASHBOARD PANEL options, like it does for ACCESS PERMISSIONS etc.

Our opencart is Version 2.0.1.1

How do I find PHP version sorry?

I have tried working with developer to fix, but has not been straigth forward or language barrier unfortuantly.
Thanks Nathan

If the settings are actually being changed and saved then it's not an issue with your database. It will be an issue with the extension to displaying them correctly.

nathanaus wrote: ↑

Fri Oct 25, 2024 8:47 am

I have tried working with developer to fix, but has not been straigth forward or language barrier unfortuantly.

We live in the age of free and almost 100% accurate translation tools, so I don't see why that would be an issue?

It sounds like a frustrating issue with the module! The suggestion about checking the database table size makes sense, as it could be causing the selections to not save properly. You might want to look into optimizing your database or increasing the table size if possible.

I can relate—I’ve had similar speed issues. Sometimes clearing the cache helps, but after a while, the same issue pops up again. It can be quite the hassle! Good luck with your troubleshooting!

Thanks

@abuislam How does one "increase the table size"?

nathanaus wrote: ↑

Wed Oct 30, 2024 9:30 am

Thanks

@abuislam How does one "increase the table size"?

Unfortunately that looks like a post just advertising a website. If the settings are saving then the tables size is not likely an issue. You would also find lots of other issues with OpenCart if there was a problem with the oc_setting table. You might want to try a "CHECK TABLE oc_setting" and also look how big it is.

For details on MySQL table sizes see the link below.
https://dev.mysql.com/doc/refman/8.0/en ... limit.html

I do not think this is what the developer/host meant by increase table size.
I think it is referring to the cell size of an array being set to for example varchar 255 instead of text because it is not saving a long array.