admin user gone after update

Next topic

Author	Message
Marko Žmak	Sunday 08 January 2006 5:07:25 am I've updated my eZ installatin from 3.5 to 3.7.2. After update I couldn't log in as admin. I looked into the databae and found out that the admin user was missing in the ezuser table. What happened? How do I fix it? -- Nothing is impossible. Not if you can imagine it! Hubert Farnsworth
Brian Gambill	Sunday 08 January 2006 1:55:45 pm I had a the same problem going from 3.5 to 3.6.4. If I remember correctly I lost the admin user with the upgrade to 3.5.2. One method I have sen recently to correct this is create a new user with publish (or whatever you password is). Dig into the database and manually create one their using that encrypted password. The 'Admin' user is user 14. Also be sure to create a entry in ezuser_setting to show user 14 as enabled ('1'). BTW, I also lost my anonymous user and <b>all</b> of my links.
Kåre Køhler Høvik	Sunday 08 January 2006 2:19:47 pm Do you know where in the upgrade procedure this happend ? Kåre Høvik
Brian Gambill	Sunday 08 January 2006 2:49:54 pm Like I said< Ibelieve I lost them in the upgrade from 3.5.0 to 3.5.2, a necessary step according to the 3.6.0 docs. What was unclear was which upgrade scripts were required to be run. I ran them all and Lost all URLs and admin and anonymous user. No other users were lost as far as I can tell.
Kåre Køhler Høvik	Sunday 08 January 2006 3:00:55 pm Thanks. We'll take a look at what could have gone wrong here. Kåre Høvik
Marko Žmak	Sunday 08 January 2006 4:30:31 pm I lost only the admin user, not the anonymous. I also ran all the update scripts, but I don't know after which one the problrm occured. And yes, inserting apropriate records into ezuser and azuser_setting did the trick. I figure it out by myself, but thanks for the tip anyway. -- Nothing is impossible. Not if you can imagine it! Hubert Farnsworth
john polo	Monday 09 January 2006 11:09:43 pm can you tell us that what exactly you changed in those tables ? I lost all of my users except anon... i dont know whats going on with this
Marko Žmak	Tuesday 10 January 2006 12:02:39 am I did a backup of my database before upgrading so I just inserted the records from the backup into these tables: ezuser ezuser_setting -- Nothing is impossible. Not if you can imagine it! Hubert Farnsworth
john polo	Tuesday 10 January 2006 12:18:36 am yes thanks...i did my backup before too..thanks god

eZ debug

Timing:	Jan 18 2025 19:27:10
Script start
Timing:	Jan 18 2025 19:27:10
Module start 'layout'
Timing:	Jan 18 2025 19:27:10
Module start 'content'
Timing:	Jan 18 2025 19:27:11
Module end 'content'
Timing:	Jan 18 2025 19:27:11
Script end

Main resources:

Total runtime	0.7218 sec
Peak memory usage	4,096.0000 KB
Database Queries	79

Timing points:

Checkpoint	Start (sec)	Duration (sec)	Memory at start (KB)	Memory used (KB)
Script start	0.0000	0.0056	589.0469	152.6250
Module start 'layout'	0.0056	0.0025	741.6719	39.4453
Module start 'content'	0.0080	0.7121	781.1172	674.3516
Module end 'content'	0.7202	0.0016	1,455.4688	16.1641
Script end	0.7217		1,471.6328

Time accumulators:

Accumulator	Duration (sec)	Duration (%)	Count	Average (sec)
Ini load
Load cache	0.0032	0.4495	16	0.0002
Check MTime	0.0013	0.1848	16	0.0001
Mysql Total
Database connection	0.0007	0.1031	1	0.0007
Mysqli_queries	0.6612	91.6092	79	0.0084
Looping result	0.0007	0.0998	77	0.0000
Template Total	0.6872	95.2	2	0.3436
Template load	0.0019	0.2674	2	0.0010
Template processing	0.6852	94.9354	2	0.3426
Template load and register function	0.0001	0.0150	1	0.0001
states
state_id_array	0.0014	0.1960	1	0.0014
state_identifier_array	0.0009	0.1242	2	0.0004
Override
Cache load	0.0016	0.2190	30	0.0001
Sytem overhead
Fetch class attribute can translate value	0.0006	0.0876	4	0.0002
Fetch class attribute name	0.0010	0.1351	11	0.0001
XML
Image XML parsing	0.0013	0.1775	4	0.0003
class_abstraction
Instantiating content class attribute	0.0000	0.0033	14	0.0000
General
dbfile	0.0010	0.1403	23	0.0000
String conversion	0.0000	0.0011	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/ezimage.tpl	<No override>	extension/sevenx/design/simple/templates/content/datatype/view/ezimage.tpl
9	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
1	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: 27 Number of unique templates used: 6

Time used to render debug report: 0.0001 secs