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.
Results 1 to 10 of 11
Thread: Mysql Error.
-
Mysql Error.
Last edited by Johno; 17-10-2008 at 08:55 PM.
.:.:#14:.:. .:.: Impossible Is Nothing :.:. .:.: 845 Rep:.:.
.:.: Stand up for what is right, even if you stand alone:.:.
-
Hmm i'm not too sure what's causing the error but you may want to remove the MD5 from your post lol.
-
Whats key 2 ?
-
grr I need a mod to remove the md5.
.:.:#14:.:. .:.: Impossible Is Nothing :.:. .:.: 845 Rep:.:.
.:.: Stand up for what is right, even if you stand alone:.:.
-
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..
-
it's just moving a usertable from a usersystem into the phpbb usertable.
.:.:#14:.:. .:.: Impossible Is Nothing :.:. .:.: 845 Rep:.:.
.:.: Stand up for what is right, even if you stand alone:.:.
-
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.
-
what row already exists?
The only row's i can think of need to exists to be able to insert..:.:#14:.:. .:.: Impossible Is Nothing :.:. .:.: 845 Rep:.:.
.:.: Stand up for what is right, even if you stand alone:.:.
-
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*' );Kind Regards,
Guy__________________
Since 2007. Unbelievable Uptime. Web hosting, resellers, master resellers, linux VPS, windows VPS, shoutcasts, at the lowest prices on the net.
Tech-Hosts.co.uk.
-
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.:.:#14:.:. .:.: Impossible Is Nothing :.:. .:.: 845 Rep:.:.
.:.: Stand up for what is right, even if you stand alone:.:.
Reply With Quote
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts