Skip to Content Skip to Menu

[SOLVED] Re-seed User ID?

  • autobahn
  • autobahn
  • OFFLINE
  • Posts: 202
  • Thanks: 38
  • Karma: 4
10 years 6 months ago - 10 years 6 months ago #244657 by autobahn
[SOLVED] Re-seed User ID? was created by autobahn
We have a current database of users who all have a numeric Member ID which has to be retained. I plan to upload this data using CB Juice but obviously the user id assigned by CB will not match the existing values for Member ID.

This mismatch does not matter for the existing members, but we would like all new members to have a Member ID which is the same as the CB User ID.

Is it possible to re-seed the User ID field in the database so that it starts from, say, 3000? If so, which field is it and in which table?
Last edit: 10 years 6 months ago by krileon.

Please Log in or Create an account to join the conversation.

  • krileon
  • krileon
  • ONLINE
  • Posts: 48478
  • Thanks: 8282
  • Karma: 1443
10 years 6 months ago - 10 years 6 months ago #244661 by krileon
Replied by krileon on topic Re-seed User ID?
You can adjust the auto increment value within _users and _comprofiler to be set to 3000 using phpmyadmin. Aside from that there's no way to set a start user id. This also will only give the new incremented id to new users. Existing users will be completely unaffected.

Kyle (Krileon)
Community Builder Team Member
Before posting on forums: Read FAQ thoroughly + Read our Documentation + Search the forums
CB links: Documentation - Localization - CB Quickstart - CB Paid Subscriptions - Add-Ons - Forge
--
If you are a Professional, Developer, or CB Paid Subscriptions subscriber and have a support issue please always post in your respective support forums for best results!
--
If I've missed your support post with a delay of 3 days or greater and are a Professional, Developer, or CBSubs subscriber please send me a private message with your thread and will reply when possible!
--
Please note I am available Monday - Friday from 8:00 AM CST to 4:00 PM CST. I am away on weekends (Saturday and Sunday) and if I've missed your post on or before a weekend after business hours please wait for the next following business day (Monday) and will get to your issue as soon as possible, thank you.
--
My role here is to provide guidance and assistance. I cannot provide custom code for each custom requirement. Please do not inquire me about custom development.
Last edit: 10 years 6 months ago by krileon.
The following user(s) said Thank You: autobahn

Please Log in or Create an account to join the conversation.

  • autobahn
  • autobahn
  • OFFLINE
  • Posts: 202
  • Thanks: 38
  • Karma: 4
10 years 6 months ago #244665 by autobahn
Replied by autobahn on topic Re-seed User ID?
Thanks Kyle, that is just brilliant :)

Please Log in or Create an account to join the conversation.

Moderators: beat, nant, krileon
Powered by Kunena Forum