By yanger on
hi! I've a problem that's been bugging me, and was hoping someone could help me out..
I manually added some users (instead of using the import.php because I don't remember my mysql db passwords) using phpMyAdmin (into table users) and it seemed to work right. When a new user requests a logon, it fails.
error in log stats:
Duplicate entry '4' for key 1 query: INSERT INTO users (name, mail, pass, init, status, created, changed, uid) VALUES ('dinglehopper', 'dinglehopper@yahoo.com', 'afcb4a5e187c7zc0b68e5633792023b0', 'dinglehopper@yahoo.com', '1', '1140673179', '1140673179', '4') in /home/mysite/www/includes/database.mysql.inc on line 66.
did i miss something when I imported manually? I am thinking I forgot to change the increment of something so that the total number of users was valid (but does it just count?)
hope someone can assist. Thanks!
Dave
Comments
Sequences table
There is a value in the sequences table that stores the ID of the last user to be added - you should increment that as well.
(if you've forgotten your password, you should be able to get it again from the settings.php file in /path/to/drupal/sites/default/)
ahh, i see.. ok will do
ahh, i see.. ok will do that..
for the forgotten password, mdpro uses encrypted passwordding (at least, my old mdpro) in that file, so i can't really use that then...
will try the first mentioned. thanks!
---------------------------
yanger