Bravo List

Bravo List (http://www.bvlist.com/index.php)
-   Torrent Trader (http://www.bvlist.com/forumdisplay.php?f=29)
-   -   Importing UserDB from TorrentStrike (http://www.bvlist.com/showthread.php?t=632)

klonoa2 14th July 2008 22:25

Importing UserDB from TorrentStrike
 
Code:

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
Code:

SQL query: Documentation

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

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



All times are GMT +2. The time now is 17:12.

Powered by vBulletin® Version 3.8.11 Beta 3
Copyright ©2000 - 2024, vBulletin Solutions Inc.