Blog Documentation Book a Demo
Vanilla 1 is no longer supported or maintained. If you need a copy, you can get it here.
HackerOne users: Testing against this community violates our program's Terms of Service and will result in your bounty being denied.

Deleted Admin Role!

HerrgeistHerrgeist
edited December 2006 in Vanilla 1.0 Help
How do I fix this?

Comments

  • MinisweeperMinisweeper New
    Err...you deleted the role altogether? Not just took everyone out of the role group? In that case try running this query on your database:
    INSERT INTO `LUM_Role` (`Name`, `Active`, `PERMISSION_SIGN_IN`, `PERMISSION_HTML_ALLOWED`, `PERMISSION_RECEIVE_APPLICATION_NOTIFICATION`, `Permissions`, `Priority`, `UnAuthenticated`) VALUES ('Administrator','1','1','1','1','a:44:{s:23:\"PERMISSION_ADD_COMMENTS\";i:1;s:27:\"PERMISSION_START_DISCUSSION\";i:1;s:27:\"PERMISSION_SINK_DISCUSSIONS\";i:1;s:28:\"PERMISSION_STICK_DISCUSSIONS\";i:1;s:27:\"PERMISSION_HIDE_DISCUSSIONS\";i:1;s:28:\"PERMISSION_CLOSE_DISCUSSIONS\";i:1;s:27:\"PERMISSION_EDIT_DISCUSSIONS\";i:1;s:34:\"PERMISSION_VIEW_HIDDEN_DISCUSSIONS\";i:1;s:24:\"PERMISSION_EDIT_COMMENTS\";i:1;s:24:\"PERMISSION_HIDE_COMMENTS\";i:1;s:31:\"PERMISSION_VIEW_HIDDEN_COMMENTS\";i:1;s:44:\"PERMISSION_ADD_COMMENTS_TO_CLOSED_DISCUSSION\";i:1;s:25:\"PERMISSION_ADD_CATEGORIES\";i:1;s:26:\"PERMISSION_EDIT_CATEGORIES\";i:1;s:28:\"PERMISSION_REMOVE_CATEGORIES\";i:1;s:26:\"PERMISSION_SORT_CATEGORIES\";i:1;s:28:\"PERMISSION_VIEW_ALL_WHISPERS\";i:1;s:29:\"PERMISSION_APPROVE_APPLICANTS\";i:1;s:27:\"PERMISSION_CHANGE_USER_ROLE\";i:1;s:21:\"PERMISSION_EDIT_USERS\";i:1;s:31:\"PERMISSION_IP_ADDRESSES_VISIBLE\";i:1;s:30:\"PERMISSION_MANAGE_REGISTRATION\";i:1;s:21:\"PERMISSION_SORT_ROLES\";i:1;s:20:\"PERMISSION_ADD_ROLES\";i:1;s:21:\"PERMISSION_EDIT_ROLES\";i:1;s:23:\"PERMISSION_REMOVE_ROLES\";i:1;s:28:\"PERMISSION_CHECK_FOR_UPDATES\";i:1;s:38:\"PERMISSION_CHANGE_APPLICATION_SETTINGS\";i:1;s:28:\"PERMISSION_MANAGE_EXTENSIONS\";i:1;s:26:\"PERMISSION_MANAGE_LANGUAGE\";i:1;s:24:\"PERMISSION_MANAGE_THEMES\";i:1;s:24:\"PERMISSION_MANAGE_STYLES\";i:1;s:27:\"PERMISSION_ALLOW_DEBUG_INFO\";i:1;s:27:\"PERMISSION_DATABASE_CLEANUP\";i:1;s:21:\"PERMISSION_ADD_ADDONS\";i:1;s:19:\"PERMISSION_BLOG_ADD\";i:1;s:20:\"PERMISSION_BLOG_EDIT\";i:1;s:23:\"PERMISSION_BLOG_APPROVE\";i:1;s:23:\"PERMISSION_BLOG_PUBLISH\";i:1;s:22:\"PERMISSION_BLOG_DELETE\";i:1;s:28:\"PERMISSION_BLOG_ADD_COMMENTS\";i:1;s:26:\"PERMISSION_COMMENTS_DELETE\";i:1;s:24:\"PERMISSION_COMMENTS_JUNK\";i:1;s:27:\"PERMISSION_COMMENTS_APPROVE\";i:1;}',4,'0');

    Then you may need to manually reassign that role back to someone by changing their roleID to the roleID it assigns to the administrator role.
This discussion has been closed.