Bravo List
Register
Go Back   > Bravo List > Source Code > Active Trackers > Torrent Trader
Reply
  #1  
Old 14th July 2008, 22:25
klonoa2 klonoa2 is offline
Member
 
Join Date: Jun 2008
Posts: 8
Default 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
Reply With Quote
Reply

Tags
importing , torrentstrike , userdb

Thread Tools

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
TorrentStrike v0.4 Fynnon Torrent Strike 14 23rd March 2016 10:30
TorrentStrike to TorrentTrader ocha Torrent Trader 0 4th April 2009 01:33
TorrentStrike to TorrentTrader ocha Torrent Strike 0 25th March 2009 01:45
TorrentStrike X-Fusion tunad Torrent Strike 2 8th December 2008 15:48
TorrentStrike light Torrent Strike 4 9th May 2008 22:50



All times are GMT +2. The time now is 03:35. vBulletin skin by ForumMonkeys. Powered by vBulletin® Version 3.8.11 Beta 3
Copyright ©2000 - 2024, vBulletin Solutions Inc.