Textpattern CMS support forum
You are not logged in. Register | Login | Help
- Topics: Active | Unanswered
#1 2007-08-11 20:08:07
- els
- Moderator
- From: The Netherlands
- Registered: 2004-06-06
- Posts: 7,458
...add a new user directly in the database?
I was asked to make some changes to an existing Textpattern site. The site owner gave me his login for the back end, but he is only a copy editor and I need publisher privileges. So in the database I added a row in txp_users, filling the fields name, pass, RealName, email and privs. Unfortunately my login attempts result in a page that just says “Please reload.” And reload doesn’t do anything. Looking at the txp_users table, the last_access field is now filled. There is also the nonce field, should I enter anything there to make it work?
(Edit: I should add that the person who originally built the site is no longer available.)
Last edited by els (2007-08-11 20:13:13)
Offline
Re: ...add a new user directly in the database?
Try changing the privileges of the site owner from copy editor to ‘1’ (publisher).
Offline
#3 2007-08-11 21:15:26
- els
- Moderator
- From: The Netherlands
- Registered: 2004-06-06
- Posts: 7,458
Re: ...add a new user directly in the database?
Yes, that was my ‘plan B’ ;)
Offline
#4 2007-08-13 21:59:10
- Mary
- Sock Enthusiast
- Registered: 2004-06-27
- Posts: 6,236
Re: ...add a new user directly in the database?
nonce does need to have a value. It is just any random string, MD5’d.
Offline
#5 2007-08-13 22:07:45
- els
- Moderator
- From: The Netherlands
- Registered: 2004-06-06
- Posts: 7,458
Re: ...add a new user directly in the database?
Thanks Mary! In the meantime I solved it by changing the copy editor to publisher in the db, then creating a new publisher in Admin > Users, then changing the first one back to copy editor in the db…
Next time I need to do this I’ll only need one step instead of three :)
Offline