What creates numbers for new users in the GDN_User table?
Hi! I'm pretty new to database stuff, but am poking around my site trying to figure out why the application form isn't working.
I have a suspicion it's been broken since January or so... we're running Vanilla 2.0.18, I believe (there's another admin who did the latest upgrading, currently on walkabout).
http://liminalnation.org/discuss/discussions/ is the forum address.
Every time someone tries to apply, the newest user gets assigned the same UserID... which results in a "Duplicate entry" error:
Duplicate entry '2147483647' for key 'PRIMARY'|Gdn_Database|Query|insert GDN_User (Name, Password, DiscoveryText, Email, Gender, DateFirstVisit, DateLastActive, LastIPAddress, DateInserted, HashMethod) values (:Name, :Password, :DiscoveryText, :Email, :Gender, :DateFirstVisit, :DateLastActive, :LastIPAddress, :DateInserted, :HashMethod)
Any idea where that entry number is generated so I can kind of increment it forward? I've tried adding to the number after ENGINE=MyISAM AUTO_INCREMENT in the GDN_User table, but that didn't do the trick.
Thanks for any ideas you can offer!