Error when trying to edit roles@permissions

omakis

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

x00

Yep there is zero need to use an exporter. Always use mysqldump.

You are transferring not exporting.

hgtonight

Welcome to the community!

Your permission table seems to be corrupted. Mind sharing a dump of Gdn_Permission?

x00

well I can see the the syntax error c.,

However GDN_c and GDN_p there 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.

hgtonight

@x00 said:
So the difference between NULL, an empty string, 0, etc. Can be critical.

I wish there was a 'troof ^^^' reaction or something.

x00

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.

omakis

I attach the a dump of the permission table, if of any help...

x00

can you enable quick profiler that come with the core?

omakis

solved the problem when I transfered the database manually without the vanilla2export.

x00

Yep there is zero need to use an exporter. Always use mysqldump.

You are transferring not exporting.