[klonoa2]

INSERT INTO users( `id` , `username`)
SELECT `id` , `username` FROM users2;
INSERT INTO users( `password` )
SELECT `user_password` FROM phpbb_users; 
INSERT INTO users ( `secret` , `email` , `status` , `added` , `last_login` , `last_access` , `editsecret` , `privacy` , `stylesheet` , `language` , `info` , `acceptpms` , `ip` , `class` , `avatar` , `uploaded` , `downloaded` , `title` , `donated` , `country` , `notifs` , `enabled` , `modcomment` , `gender` , `client` , `age` , `warned` , `signature` , `last_browse` , `passkey` )
SELECT `secret` , `email` , `status` , `added` , `last_login` , `last_access` , `editsecret` , `privacy` , `stylesheet` , `info` , `acceptpms` , `ip` , `class` , `avatar` , `uploaded` , `downloaded` , `title` , `donated` , `country` , `notifs` , `enabled` , `modcomment` , `gender` , `client` , `warned` , `signature` , `last_browse` , `passkey`FROM users2;

this is what i am using to try and import the userdb from one source to another but when i try to do it i get an error message

EDIT
this is the error i get

SQL query: Documentation

INSERT INTO users( `password` )
SELECT `user_password`
FROM phpbb_users;

MySQL said: Documentation
#1062 - Duplicate entry '' for key 2