admin

Next topic

Author	Message
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
Alexandru M	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.
Kåre Køhler Høvik	Monday 13 March 2006 3:04:48 am Hi 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 ? ) Kåre Høvik
Alexandru M	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.

eZ debug

Timing:	Jan 19 2025 01:08:27
Script start
Timing:	Jan 19 2025 01:08:27
Module start 'layout'
Timing:	Jan 19 2025 01:08:27
Module start 'content'
Timing:	Jan 19 2025 01:08:28
Module end 'content'
Timing:	Jan 19 2025 01:08:28
Script end

Main resources:

Total runtime	0.6355 sec
Peak memory usage	4,096.0000 KB
Database Queries	63

Timing points:

Checkpoint	Start (sec)	Duration (sec)	Memory at start (KB)	Memory used (KB)
Script start	0.0000	0.0066	588.9219	152.5938
Module start 'layout'	0.0066	0.0034	741.5156	39.3750
Module start 'content'	0.0100	0.6240	780.8906	557.3906
Module end 'content'	0.6340	0.0015	1,338.2813	12.2188
Script end	0.6354		1,350.5000

Time accumulators:

Accumulator	Duration (sec)	Duration (%)	Count	Average (sec)
Ini load
Load cache	0.0034	0.5372	16	0.0002
Check MTime	0.0014	0.2145	16	0.0001
Mysql Total
Database connection	0.0016	0.2444	1	0.0016
Mysqli_queries	0.5734	90.2313	63	0.0091
Looping result	0.0006	0.0964	61	0.0000
Template Total	0.6022	94.8	2	0.3011
Template load	0.0021	0.3285	2	0.0010
Template processing	0.6001	94.4274	2	0.3001
Template load and register function	0.0002	0.0302	1	0.0002
states
state_id_array	0.0015	0.2416	1	0.0015
state_identifier_array	0.0011	0.1693	2	0.0005
Override
Cache load	0.0017	0.2608	30	0.0001
Sytem overhead
Fetch class attribute can translate value	0.0006	0.0930	2	0.0003
Fetch class attribute name	0.0011	0.1678	6	0.0002
XML
Image XML parsing	0.0007	0.1052	2	0.0003
class_abstraction
Instantiating content class attribute	0.0000	0.0024	7	0.0000
General
dbfile	0.0017	0.2747	15	0.0001
String conversion	0.0000	0.0017	4	0.0000
Note: percentages do not add up to 100% because some accumulators overlap

Templates used to render the page:

Usage	Requested template	Template	Template loaded
1	node/view/full.tpl	full/forum_topic.tpl	extension/sevenx/design/simple/override/templates/full/forum_topic.tpl
5	content/datatype/view/ezxmltext.tpl	<No override>	extension/community_design/design/suncana/templates/content/datatype/view/ezxmltext.tpl
10	content/datatype/view/ezxmltags/paragraph.tpl	<No override>	extension/ezwebin/design/ezwebin/templates/content/datatype/view/ezxmltags/paragraph.tpl
2	content/datatype/view/ezimage.tpl	<No override>	extension/sevenx/design/simple/templates/content/datatype/view/ezimage.tpl
2	content/datatype/view/ezxmltags/literal.tpl	<No override>	extension/community/design/standard/templates/content/datatype/view/ezxmltags/literal.tpl
4	content/datatype/view/ezxmltags/line.tpl	<No override>	design/standard/templates/content/datatype/view/ezxmltags/line.tpl
1	print_pagelayout.tpl	<No override>	extension/community/design/community/templates/print_pagelayout.tpl
Number of times templates used: 25 Number of unique templates used: 7

Time used to render debug report: 0.0001 secs