On Wed, Oct 08, 2003 at 11:02:51PM -0400, Rusty Foster wrote: > The patch that changed user ids to auto increment broke new user > creation on K5. > > The error looks like: > > DBD::mysql::st execute failed: Duplicate entry '0' for key 1 at > /www/scoop/lib/Scoop/DB.pm line 203. > <<ERROR>> <<207.69.13.168>> in db_insert: Duplicate entry '0' for key 1 > (Query is INSERT INTO users (nickname, origemail, realemail, passwd, > perm_group, creation_ip, creation_time, is_new_account) VALUES ( > [...values...]) : Error in /www/scoop/lib/Scoop/Admin/Users.pm line 494 > at /www/scoop/lib/Scoop/DB.pm line 206. > > Clearly it's not auto-incrementing. Any ideas why? Or how I can find out > if the patch took and that field is actually marked auto-increment? mysqldump <usual user stuff> -d <dbname> users Will dump just the table structure. The -d prevents it dumping the row information. -- http://janes.demon.co.uk/scoop/ Hulver's site. -------------- next part -------------- A non-text attachment was scrubbed... Name: not available Type: application/pgp-signature Size: 189 bytes Desc: not available Url : http://lists.kuro5hin.org/pipermail/scoop-dev/attachments/20031009/58eec952/attachment.bin