Error add wiki permissions

[Julianhm9612]

I create a new user and add various permissions at the role admins, in the table role permissions exist this permissions, but the application not recognize this.

Application:

Database:

[PHCCorso]

Any updates on this? This yields the application totally unusable.

[devmanx]

to fix this problem you need execute this sql query:

INSERT INTO permissions ('id', 'name', 'created_at', 'updated_at') VALUES (1, 'admin', NULL, NULL), (2, 'view_page', NULL, NULL), (3, 'add_page', NULL, NULL), (4, 'delete_page', NULL, NULL), (5, 'add_comment', NULL, NULL), (6, 'delete_comment', NULL, NULL);

@PHCCorso @Julianhm9612

[daniellivingston]

@devmanx how do I execute this query? Sorry, I have no PHP experience at all.

[devmanx]

@daniellivingston You don't need php for that. Just open phpmyadmin and then click on SQL tab (you can see this button on image from first post in this thread) and then copy my sql to phpmyadmin and execute it :-)

[antipiot]

Hello!
My apologizes as i'm not a powerfull db user: i encounter this error:

MariaDB [opus]> INSERT INTO permissions ('id', 'name', 'created_at', 'updated_at') VALUES (1, 'admin', NULL, NULL), (2, 'view_page', NULL, NULL), (3, 'add_page', NULL, NULL), (4, 'delete_page', NULL, NULL), (5, 'add_comment', NULL, NULL), (6, 'delete_comment', NULL, NULL);
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ''id', 'name', 'created_at', 'updated_at') VALUES (1, 'admin', NULL, NULL), (2...' at line 1
Looks like there's a synthax error but i'm not used enough to find what and where :-/
Does any of you know what's hapening?

[pstoneTI]

Hello!
My apologizes as i'm not a powerfull db user: i encounter this error:

MariaDB [opus]> INSERT INTO permissions ('id', 'name', 'created_at', 'updated_at') VALUES (1, 'admin', NULL, NULL), (2, 'view_page', NULL, NULL), (3, 'add_page', NULL, NULL), (4, 'delete_page', NULL, NULL), (5, 'add_comment', NULL, NULL), (6, 'delete_comment', NULL, NULL);
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ''id', 'name', 'created_at', 'updated_at') VALUES (1, 'admin', NULL, NULL), (2...' at line 1
Looks like there's a synthax error but i'm not used enough to find what and where :-/
Does any of you know what's hapening?

Try this:
INSERT INTO permissions (id,name,created_at,updated_at) VALUES (1, 'admin', NULL, NULL), (2, 'view_page', NULL, NULL), (3, 'add_page', NULL, NULL), (4, 'delete_page', NULL, NULL), (5, 'add_comment', NULL, NULL), (6, 'delete_comment', NULL, NULL);

The Synthax error is with the ' of the column names.

[antipiot]

Thanks for your answer!
Sadly i have no time atm to try but will do for sure.