Forums / General / admin
Alexandru M
Monday 13 March 2006 2:19:51 am
i accidently removed all the admin accounts. what can i do except reinstalling? (i don't have a backup, but i have access to the mysql database)
Kåre Køhler Høvik
Monday 13 March 2006 2:36:10 am
Hi
You can solve this by creating a new admin user as anonymous. You'll need to do this :
1. Edit settings/siteaccess/<admin>/site.ini, and set
[SiteAccessSettings] RequireUserLogin=false
2. Enter MySQL and run this query :
insert into ezuser_role ( contentobject_id, role_id ) values ( 42, 2 );
You should now be able to enter the admin interface as anonymous, and create new admin user.
Kåre Høvik
Monday 13 March 2006 2:57:24 am
i tried, but i get this error:
The requested page could not be displayed. (1)
The system is unable to display the requested page because of security issues.
Possible reasons:
* Your account does not have the proper privileges to access the requested page. * The requested page does not exist. Try changing the URL.
Monday 13 March 2006 3:04:48 am
Did you remember to clear all cache after you did the SQL update ?How far in the procedure do you get ? ( Are you able to browse the admin interface ? )
Monday 13 March 2006 6:56:45 am
1. Did you remember to clear all cache after you did the SQL update ?i don't know how to do that. i can't flush (no reload rights) and i'm using phpmyadmin (this is what my administrator allows me to use).
2. How far in the procedure do you get ? ( Are you able to browse the admin interface ? )i get the error when i open ..index.php/blog_admin page. even if i try to browse the page still get the same error.