Announcement

Collapse
No announcement yet.

Userid problem

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

  • Userid problem

    Hi
    after a DB crash and repair, new registered userid are > 3181650000
    I've tried deleting all traces of this %number% on all tables/datastore but when I add new user it is still increasing
    I've repaired again all tables but no luck.
    vb 3.8.7 pl2

    any idea ?

    Thanks

  • #2
    ALTER TABLE `user`
    AUTO_INCREMENT=4;

    run this query
    change the number 4 to the one above the highest of the one you have now for userid


    so in other words if the highest userid is 4 then you would change it to 5

    Comment


    • #3
      Worked,
      thank you

      Comment


      • #4
        your welcome

        Comment

        widgetinstance 262 (Related Topics) skipped due to lack of content & hide_module_if_empty option.
        Working...
        X