FUDforum
Fast Uncompromising Discussions. FUDforum will get your users talking.

Home » FUDforum » FUDforum Installation Issues » error message: FATAL ERROR: anonymous user's ID must be 1! (trouble with installation)
Show: Today's Messages :: Polls :: Message Navigator
Return to the default flat view Create a new topic Submit Reply
Re: error message: FATAL ERROR: anonymous user's ID must be 1! [message #164331 is a reply to message #164298] Sun, 23 January 2011 02:47 Go to previous messageGo to previous message
The Witcher is currently offline  The Witcher   United States
Messages: 675
Registered: May 2009
Location: USA
Karma:
Senior Member
naudefj wrote on Wed, 19 January 2011 04:05
The issue is that the installer, quite successfully, dropped and re-created all the tables.

Step 5 empties the users table and inserts the first user (anonymous). The database should assign the primary key as ID=1.

Now, if you navigate back and forward within the installer, this operation will be repeated. MySQL and SQLite (and possibly some others) will reset the sequences and re-insert the row as ID=1. Oracle and PostgreSQL probably won't (ID will be 2,3,4...).

I've already fixed it, but will only commit it later.


So using the back and next buttons in the installer would reassign the anonymous user in mysql. But why would the admimport rewrite the user table to Zero when attempting to restore an rc2 dump to an rc2 install?

I've had that happen a few times, before I got it that I needed the user table to regain access and like yiu said before delete TV-1 and redo the upgrade to get right again.



"I'm a Witcher, I solve human problems; not always using a sword!"
[Message index]
 
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Previous Topic: maillist.php produces broken mail header
Next Topic: need advice on upgrading slightly broken legacy 2.7.7. forum
Goto Forum:
  

-=] Back to Top [=-
[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Wed Nov 27 05:36:24 GMT 2024

Total time taken to generate the page: 0.05302 seconds