Page 1 of 1

Fields in users_table unique?

Posted: 01 Jun 2005, 08:00
by davidbaumann
I am trying to get all users into my DB, but I get Errors all the time because fields are unique.
I'm not sure if this is the problem but when I#m trying to insert it via csv with "MySQL-Fron" I get following Error:


I will have to insert some thousands of bugs and Several Projekts (almost 800), so I will need to know why these fields are unique...

Please help even if my explanation of the problem might be bad :)

David

Posted: 03 Jun 2005, 12:09
by thraxisp
ids and usernames are unique. Have you run the insert script twice? You also need to set a unique cookie for each user. "CONCAT(MD5(RAND()),MD5(NOW()))" should work for this.