Page 1 of 1

User group issues

Posted: Mon Nov 06, 2017 5:20 am
by durkbusta
Hey

I just upgraded my store from 1.5.6.4 to 3.0.2.0. It seems to be doing pretty good but i have these weird User Group issues. I seems the amount of checked permissions is limited. I can just select all and press save, it will uncheck quite a few automatically. I can selectively choose the ones i need and save those, but its a bit of a pain.
Is there a certain db limit issue that i might have ran into? Any idea on how to fix this ? thanks

Re: User group issues

Posted: Mon Nov 06, 2017 9:20 pm
by straightlight
It would be best to truncate your user group table from your database and re-insert the values in this case. However, when doing so, ensure to follow these steps: viewtopic.php?f=190&t=169431&p=699273&h ... ue#p699275

Re: User group issues

Posted: Tue Nov 07, 2017 3:21 am
by durkbusta
Thanks for the advise, i changed both files and resaved my permissions. However the problem remains.
The system says it successfully saved the changes but when i open the list it still has quite a few items unchecked.
I can get around it by unselecting a few that i don't need and then enable the ones that i do, but its still a bit of a pain.
Any other ideas ? :)

Re: User group issues

Posted: Tue Nov 07, 2017 4:36 am
by straightlight
Did you truncated the user groups table from the database and re-inserted the values into the database from your previous database backup?

Re: User group issues

Posted: Tue Nov 07, 2017 5:15 am
by durkbusta
Oh snap, no i didnt. I just followed the link you send.
I just upgraded Opencart from 1.5.6.4 to 3.0.2.0 so my db backup would be the wrong version ...

Re: User group issues

Posted: Tue Nov 07, 2017 5:31 am
by straightlight
Truncate the user groups table and re-insert the default values from your install/opencart.sql file. Ensure to use the right database table prefix before executing the query in your PHPMyAdmin.