Mysql Error.

[Colin-Roberts]

I'm trying to move my user table into phpbb.
INSERT INTO `phpbb_users` ( user_email, username, user_password )
VALUES ( '[email protected]', 'minifly3', '*Removed*'
)


error:


#1062 - Duplicate entry '' for key 2

Edited by Johno! (Forum Moderator): Content removed for user's safety.

[--ss--]

Hmm i'm not too sure what's causing the error but you may want to remove the MD5 from your post lol.

[Jackboy]

Whats key 2 ? :P

[Colin-Roberts]

grr I need a mod to remove the md5.

[DJ-Ains.T]

I don't know the error tbh, and I know that someone will have the md5 if you're not fast getting rid of it. Also, what is it you're making? Like the full thing..

[Colin-Roberts]

it's just moving a usertable from a usersystem into the phpbb usertable.

[L?KE]

That's because that row already in the table and it's throwing a wobbly because you can't have two of the same I would assume.

[Colin-Roberts]

what row already exists?
The only row's i can think of need to exists to be able to insert.

[iUnknown]

Sounds like it's just that there are two rows with that email or username or any auto-increment that might of stuffed up.

If you dont think it's that, try:

INSERT INTO `phpbb_users` ( 'user_email', 'username', 'user_password' ) VALUES ( '[email protected]', 'minifly3', '*Removed*' );

[Colin-Roberts]

i made sure that the user id, user email or username didn't exist twice. wasn't the problem.

your code gives: #1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ''user_email', 'username', 'user_password' ) VALUES ( '[email protected]'' at line 1

[Trigs]

what are the names of all your table rows?