Post by nathanaus » Mon Oct 07, 2024 1:19 pm

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

Attachments

Picture4 USER GROUP Dashboard Panels.png

Picture4 USER GROUP Dashboard Panels.png (33.18 KiB) Viewed 1031 times


Newbie

Posts

Joined
Mon Oct 07, 2024 1:11 pm

Post by ADD Creative » Mon Oct 07, 2024 5:50 pm

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?

www.add-creative.co.uk


Guru Member

Posts

Joined
Sat Jan 14, 2012 1:02 am
Location - United Kingdom

Post by paulfeakins » Mon Oct 07, 2024 6:43 pm

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.

UK OpenCart Hosting | OpenCart Audits | OpenCart Support - please email info@antropy.co.uk


User avatar
Guru Member
Online

Posts

Joined
Mon Aug 22, 2011 11:01 pm
Location - London Gatwick, United Kingdom

Post by nathanaus » Fri Oct 25, 2024 8:47 am

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.
Abandoned cart - Appear in Dashboard panel options.jpg

Abandoned cart - Appear in Dashboard panel options.jpg (304.66 KiB) Viewed 868 times

Thanks Nathan

Newbie

Posts

Joined
Mon Oct 07, 2024 1:11 pm

Post by ADD Creative » Fri Oct 25, 2024 4:17 pm

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.

www.add-creative.co.uk


Guru Member

Posts

Joined
Sat Jan 14, 2012 1:02 am
Location - United Kingdom

Post by paulfeakins » Mon Oct 28, 2024 6:51 pm

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?

UK OpenCart Hosting | OpenCart Audits | OpenCart Support - please email info@antropy.co.uk


User avatar
Guru Member
Online

Posts

Joined
Mon Aug 22, 2011 11:01 pm
Location - London Gatwick, United Kingdom

Post by abuislam » Tue Oct 29, 2024 12:06 am

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!
Last edited by Johnathan on Wed Oct 30, 2024 9:38 pm, edited 1 time in total.
Reason: Removed non-OpenCart site link

Newbie

Posts

Joined
Wed Sep 18, 2024 5:24 pm

Post by nathanaus » Wed Oct 30, 2024 9:30 am

Thanks

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

Newbie

Posts

Joined
Mon Oct 07, 2024 1:11 pm

Post by ADD Creative » Wed Oct 30, 2024 5:31 pm

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

www.add-creative.co.uk


Guru Member

Posts

Joined
Sat Jan 14, 2012 1:02 am
Location - United Kingdom

Post by by mona » Wed Oct 30, 2024 6:14 pm

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.

DISCLAIMER:
You should not modify core files .. if you would like to donate a cup of coffee I will write it in a modification for you.


https://www.youtube.com/watch?v=zXIxDoCRc84


User avatar
Expert Member

Posts

Joined
Mon Jun 10, 2019 9:31 am
Who is online

Users browsing this forum: No registered users and 13 guests