Error when trying to edit roles@permissions
I moved my forum to a new server and everything seem to work well, except
1. There are 3 admins but the only admin who sees the dashboard is the one that created the forum.
2. When the main admin (the one that see the dashboard) tries to edit roles&prmissions i get the following error
Any help would be appreciated
0
Best Answer
-
x00
MVP
Yep there is zero need to use an exporter. Always use mysqldump.
You are transferring not exporting.
5
Answers
Welcome to the community!
Your permission table seems to be corrupted. Mind sharing a dump of Gdn_Permission?
well I can see the the syntax error
c.,However
GDN_candGDN_pthere are no such tables. That means that JunctionTable is wrong and JunctionColumn is empty.quite often problem like this can happen where the imported data came from a dump that did not preserve data type correctly. So the difference between NULL, an empty string, 0, etc. Can be critical.
I think you have lack of NULLs, so it it trying to lock up junctions that are an empty string.
We will see.
I wish there was a 'troof ^^^' reaction or something.
next time when you or dev takes a dump of the database, use mysqldump, and keep everything as true to form as possible. That way you run the query you get all you data as intended.
The permissions table is particularly sensitive to these kinds of problems.
I attach the a dump of the permission table, if of any help...
can you enable quick profiler that come with the core?
solved the problem when I transfered the database manually without the vanilla2export.
Yep there is zero need to use an exporter. Always use mysqldump.
You are transferring not exporting.