Fields in users_table unique?

Get help from other users here.

Moderators: Developer, Contributor

Post Reply
davidbaumann
Posts: 5
Joined: 22 Apr 2005, 12:31

Fields in users_table unique?

Post 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
Last edited by davidbaumann on 08 Sep 2005, 12:05, edited 1 time in total.
Top
thraxisp
Developer
Posts: 509
Joined: 14 Feb 2005, 03:38
Location: Ottawa, Canada
Contact:
Contact thraxisp

Post 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.
Top
Post Reply

Return to “Help”