| 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   |
The Witcher
Messages: 675
Registered: May 2009
Location: USA
Karma:
|
Senior Member |
|
|
naudefj wrote on Wed, 19 January 2011 04:05The 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!"
|
|
|
|
Calendar
Search
Help
Members
Register
Login
Home
]