Error add wiki permissions about opus

[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

[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 :-)

[PHCCorso]

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

[daniellivingston]

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

[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.