Forums / Setup & design / admin user gone after update

admin user gone after update

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 16:15:28
Script start
Timing: Jan 18 2025 16:15:28
Module start 'content'
Timing: Jan 18 2025 16:15:30
Module end 'content'
Timing: Jan 18 2025 16:15:30
Script end

Main resources:

Total runtime1.6907 sec
Peak memory usage4,096.0000 KB
Database Queries216

Timing points:

CheckpointStart (sec)Duration (sec)Memory at start (KB)Memory used (KB)
Script start 0.00000.0111 588.8281180.8359
Module start 'content' 0.01111.4800 769.6641679.4297
Module end 'content' 1.49110.1996 1,449.0938340.4375
Script end 1.6906  1,789.5313 

Time accumulators:

 Accumulator Duration (sec) Duration (%) Count Average (sec)
Ini load
Load cache0.00440.2631210.0002
Check MTime0.00170.0989210.0001
Mysql Total
Database connection0.00090.051310.0009
Mysqli_queries1.582893.61882160.0073
Looping result0.00260.15422140.0000
Template Total1.629896.420.8149
Template load0.00250.150120.0013
Template processing1.627396.245720.8136
Template load and register function0.00010.005710.0001
states
state_id_array0.01220.723610.0122
state_identifier_array0.00270.161920.0014
Override
Cache load0.00210.1225300.0001
Sytem overhead
Fetch class attribute can translate value0.00450.267650.0009
Fetch class attribute name0.00160.0944110.0001
XML
Image XML parsing0.00150.088450.0003
class_abstraction
Instantiating content class attribute0.00000.0015140.0000
General
dbfile0.00920.5426340.0003
String conversion0.00000.000430.0000
Note: percentages do not add up to 100% because some accumulators overlap

CSS/JS files loaded with "ezjscPacker" during request:

CacheTypePacklevelSourceFiles
CSS0extension/community/design/community/stylesheets/ext/jquery.autocomplete.css
extension/community_design/design/suncana/stylesheets/scrollbars.css
extension/community_design/design/suncana/stylesheets/tabs.css
extension/community_design/design/suncana/stylesheets/roadmap.css
extension/community_design/design/suncana/stylesheets/content.css
extension/community_design/design/suncana/stylesheets/star-rating.css
extension/community_design/design/suncana/stylesheets/syntax_and_custom_tags.css
extension/community_design/design/suncana/stylesheets/buttons.css
extension/community_design/design/suncana/stylesheets/tweetbox.css
extension/community_design/design/suncana/stylesheets/jquery.fancybox-1.3.4.css
extension/bcsmoothgallery/design/standard/stylesheets/magnific-popup.css
extension/sevenx/design/simple/stylesheets/star_rating.css
extension/sevenx/design/simple/stylesheets/libs/fontawesome/css/all.min.css
extension/sevenx/design/simple/stylesheets/main.v02.css
extension/sevenx/design/simple/stylesheets/main.v02.res.css
JS0extension/ezjscore/design/standard/lib/yui/3.17.2/build/yui/yui-min.js
extension/ezjscore/design/standard/javascript/jquery-3.7.0.min.js
extension/community_design/design/suncana/javascript/jquery.ui.core.min.js
extension/community_design/design/suncana/javascript/jquery.ui.widget.min.js
extension/community_design/design/suncana/javascript/jquery.easing.1.3.js
extension/community_design/design/suncana/javascript/jquery.ui.tabs.js
extension/community_design/design/suncana/javascript/jquery.hoverIntent.min.js
extension/community_design/design/suncana/javascript/jquery.popmenu.js
extension/community_design/design/suncana/javascript/jScrollPane.js
extension/community_design/design/suncana/javascript/jquery.mousewheel.js
extension/community_design/design/suncana/javascript/jquery.cycle.all.js
extension/sevenx/design/simple/javascript/jquery.scrollTo.js
extension/community_design/design/suncana/javascript/jquery.cookie.js
extension/community_design/design/suncana/javascript/ezstarrating_jquery.js
extension/community_design/design/suncana/javascript/jquery.initboxes.js
extension/community_design/design/suncana/javascript/app.js
extension/community_design/design/suncana/javascript/twitterwidget.js
extension/community_design/design/suncana/javascript/community.js
extension/community_design/design/suncana/javascript/roadmap.js
extension/community_design/design/suncana/javascript/ez.js
extension/community_design/design/suncana/javascript/ezshareevents.js
extension/sevenx/design/simple/javascript/main.js

Templates used to render the page:

UsageRequested templateTemplateTemplate loadedEditOverride
1node/view/full.tplfull/forum_topic.tplextension/sevenx/design/simple/override/templates/full/forum_topic.tplEdit templateOverride template
5content/datatype/view/ezimage.tpl<No override>extension/sevenx/design/simple/templates/content/datatype/view/ezimage.tplEdit templateOverride template
9content/datatype/view/ezxmltext.tpl<No override>extension/community_design/design/suncana/templates/content/datatype/view/ezxmltext.tplEdit templateOverride template
10content/datatype/view/ezxmltags/paragraph.tpl<No override>extension/ezwebin/design/ezwebin/templates/content/datatype/view/ezxmltags/paragraph.tplEdit templateOverride template
1content/datatype/view/ezxmltags/line.tpl<No override>design/standard/templates/content/datatype/view/ezxmltags/line.tplEdit templateOverride template
1pagelayout.tpl<No override>extension/sevenx/design/simple/templates/pagelayout.tplEdit templateOverride template
 Number of times templates used: 27
 Number of unique templates used: 6

Time used to render debug report: 0.0001 secs