|
|
| Re: error message: FATAL ERROR: anonymous user's ID must be 1! [message #164270 is a reply to message #164269] |
Tue, 18 January 2011 00:49   |
The Witcher
Messages: 675
Registered: May 2009
Location: USA
Karma: 3
|
Senior Member |
|
|
marymezzo wrote on Mon, 17 January 2011 18:38I've gotten to the point in the installer at which I'm trying to create a user name and password for myself as administrator of the forum.
Everything else has been fine.
I type in an admin user name, password, and e-mail address, and when I click the "next" button, I see an error screen with this scary message:
FATAL ERROR: anonymous user's ID must be 1!
anyone have a clue what I might be doing wrong or how I can fix it?
thanks,
Mary
Did you try to install it before this happened?
I've had this several times recently moving from one host to another and changing things around.
I Uninstalled it completely, then reinstalled from scratch, or alternativly you can upload the user table manualy if you have it.
But I would definitely reinstall. If you have the knowledge to edit your sql you might try that.
"I'm a Witcher, I solve human problems; not always using a sword!"
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Re: error message: FATAL ERROR: anonymous user's ID must be 1! [message #164279 is a reply to message #164275] |
Tue, 18 January 2011 12:11 |
The Witcher
Messages: 675
Registered: May 2009
Location: USA
Karma: 3
|
Senior Member |
|
|
naudefj wrote on Mon, 17 January 2011 21:25Before you try again, please delete all old tables or recreate the entire DB.
I often take the time to manually dump all my data base tables just in case, but in reality doesn't a new install automatically dump all tables with the same prefix?
I've had the same basic problem with 3 installs this week, each when trying to install and import a dump, I assume those were caused by bad dumps or wrong versions but in each case my user table was rewritten as "0".
"I'm a Witcher, I solve human problems; not always using a sword!"
|
|
|
|
|
|
| Re: error message: FATAL ERROR: anonymous user's ID must be 1! [message #164296 is a reply to message #164292] |
Wed, 19 January 2011 09:54 |
The Witcher
Messages: 675
Registered: May 2009
Location: USA
Karma: 3
|
Senior Member |
|
|
Ernesto wrote on Tue, 18 January 2011 21:33On most properly configured SQL systems, www user does not have rights to drop tables.
Don't know how you mean "www user" I log in through the control panel to access the sql database as the DB user and select and drop the tables manually.
"I'm a Witcher, I solve human problems; not always using a sword!"
|
|
|
|
|
|
|
|
|
|
| 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: 3
|
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
]