(I found an older topic with the exact same question, but no answer. I started a new topic, though, because I was afraid nobody would notice my answer in an ages old topic. Sorry for any inconvenience).
The problem is simple:
When giving IDs to new users, Drupal ignores the sequences table in the database. I tried setting "uid" to 5000, then 1000, then 100, then 250, but with no effect. The users I created got IDs of 201, 202, 203, 204, etc. The strange thing is that Drupal remembers the last user had ID 204 and gives the next one ID 205. I have no idea where this information is stored, because the sequences table has the "uid" value set to 1000 all the time. Perhaps there is some other table which stores the uid? Or am I doing something wrong?
Please note that drupal tables in my database have NO prefix. Does the mod expect them to have drupal_ prefix? And if yes, where can I change this settings? In the mod's configuration file I can change the PHPbb prefix, but I haven't found anything mentioning the Drupal database.
I'd be grateful for any help. Thanks,
Jiri
Comments
Please see first paragraph
Please see first paragraph of http://drupal.i1media.no/drupal+phpbb/install_module
Thanks for your answer,
Thanks for your answer, arkepp. The thing is, I've already done that. Since I have 2500 users, I set the uid number to 3000. When I created a new user in Drupal after, it ignored the number and instead gave him ID 201. I don't even know where it the number 200 from!
This is a screenshot made just a minute ago, when I tried to create a new user via normal registration in Drupal.
Quickpost this image to Myspace, Digg, Facebook, and others!
Ha!
Oh, nevermind, this was my fault. I forgot I was using the w-i-p 6.x version. Drupal 6.x obviously doesn't use the Sequenced table. I had to alter the "uid" autoincrement value in .users table. That made the trick.
ALTER TABLE users AUTO_INCREMENT = 3000
Sorry for the false alarm.