By ernst on

I Have a instalation 5.x working fine, I Thouth. but when I ad new user I write ower the old users. I have imported the data from an old non-funcional drupal instalation where I have saved data from.

HELP I ned to know how to count up the user-numbers in whith table or so so a I can step up the user-numbers so the counter will work fine. I ......

HELP PLEASE;

⋅ Categories: Drupal 5.x

Comments

styro’s picture

styro commented

it contains the next usable id for various Drupal objects.

If the next id for a certain object type in the sequences table is lower than the highest id you already use - then I can imagine that creating new objects will cause trouble.

--
Anton
New to Drupal? | Troubleshooting FAQ
Example knowledge base built with Drupal

heine’s picture

heine commented

Please see Tips for posting. I've removed the caps.

You did not update the sequences table. The column with name = users_uid has to have its ID set to the highest user id on your system.

If, like me, you are lazy, use the following query (MySQL 4.1 +):

UPDATE sequences SET id = (SELECT max(uid) FROM users) WHERE name = 'users_uid';

--
The Manual | Troubleshooting FAQ | Tips for posting | How to report a security issue.

ernst’s picture

ernst commented

THanks all! IT have solved my problem