News:

Wondering if this will always be free?  See why free is better.

Main Menu

1.1 Converters

Started by Grudge, June 15, 2005, 04:46:34 PM

Previous topic - Next topic

Oldiesmann

Proenski - I'm not sure what the problem is. I'll tell Compuart to take a look at this topic and see if he can figure out the issue.

dvd-man - What do you want to convert from?
Michael Eshom
Christian Metal Fans

Compuart

Proenski, try replacing (yabbse_to_smf.sql):
---* {$to_prefix}log_boards
SELECT ID_BOARD
ID_MEMBERlogTime
FROM 
{$from_prefix}log_mark_read;
---*



into:
---* {$to_prefix}log_mark_read
SELECT ID_BOARD
ID_MEMBERlogTime
FROM 
{$from_prefix}log_mark_read;
---*
Hendrik Jan Visser
Former Lead Developer & Co-founder www.simplemachines.org
Personal Signature:
Realitynet.nl -> ExpeditieRobinson.net / PekingExpress.org / WieIsDeMol.Com

dvd-man

Quotedvd-man - What do you want to convert from?

phpBB :)

Proenski

Quote from: Compuart on October 07, 2005, 12:52:38 PM
Proenski, try replacing (yabbse_to_smf.sql):
---* {$to_prefix}log_boards
SELECT ID_BOARD
ID_MEMBERlogTime
FROM 
{$from_prefix}log_mark_read;
---*



into:
---* {$to_prefix}log_mark_read
SELECT ID_BOARD
ID_MEMBERlogTime
FROM 
{$from_prefix}log_mark_read;
---*


Ok. Will try. Keep you updated...
May the force be with you

Oldiesmann

Quote from: dvd-man on October 07, 2005, 01:59:39 PM
Quotedvd-man - What do you want to convert from?

phpBB :)

It's there... Right between phorum and phpnuke. Here's a direct link though: http://www.simplemachines.org/community/index.php?action=dlattach;topic=38966.0;attach=9338

Make sure you also download converter.php
Michael Eshom
Christian Metal Fans

dvd-man

Hmm.. strange; wasn't there last time I looked! :-\

Do you mean convert.php?

Oldiesmann

Yeah, that's what I meant. It's easy to overlook attachments since there are so many of them in that topic.
Michael Eshom
Christian Metal Fans

dvd-man

OK thanks!

As for the attachements... when I was trying to find it I didn't see any attachments on the post.. not like there are now. But that doesn't matter now anyway since I've got it! :P

Champi

i made a clean install of 1.1 rc 1 and tried to convert the ipb2.0.4 to my smf database..

it stucks at step 2:

Converting personal messages (step 2)... Unsuccessful!
This query:
INSERT INTO `mkportal1`.smfCH_pm_recipients
(ID_PM, ID_MEMBER, bcc, is_read)
VALUES ('1', '1', '0', '1123274796'),
('21', '1', '0', '1123835608'),
('3', '1', '0', '1123362879'),
('4', '1', '0', '1123411263'),
etc. etc.

Caused the error:

Duplicate entry '1-1' for key 1

Normally you would say that if i empty that table and run it again.. the problem ius solved.. but i still get this error..

what can i do about it..

greetzz


Compuart

Can you try replacing (invision2_to_smf.sql)

---* {$to_prefix}pm_recipients
SELECT
mt_msg_id AS ID_PM, mt_to_id AS ID_MEMBER, mt_hide_cc AS bcc,
mt_user_read AS is_read
FROM {$from_prefix}message_topics
WHERE mt_vid_folder != 'sent' OR mt_from_id != m.mt_to_id;
---*


by:
---* {$to_prefix}pm_recipients
SELECT
mt_msg_id AS ID_PM, mt_to_id AS ID_MEMBER, MIN(mt_hide_cc) AS bcc,
IF(MAX(mt_user_read) > 0, 1, 0) AS is_read
FROM {$from_prefix}message_topics
WHERE mt_vid_folder != 'sent' OR mt_from_id != m.mt_to_id
GROUP BY mt_msg_id, mt_to_id;
---*


Hendrik Jan Visser
Former Lead Developer & Co-founder www.simplemachines.org
Personal Signature:
Realitynet.nl -> ExpeditieRobinson.net / PekingExpress.org / WieIsDeMol.Com

Champi

 Converting personal messages (step 2)... Unsuccessful!
This query:

    SELECT
    mt_msg_id AS ID_PM, mt_to_id AS ID_MEMBER, MIN(mt_hide_cc) AS bcc,
    IF(MAX(mt_user_read) > 0, 1, 0) AS is_read
    FROM `mkportal1`.ibf_message_topics
    WHERE mt_vid_folder != 'sent' OR mt_from_id != m.mt_to_id
    GROUP BY mt_msg_id, mt_to_id
    LIMIT 0, 500;

Caused the error:

    Unknown table 'm' in where clause

this is the result of replacing above.. strange

Compuart

Strange indeed. Can you try without the m, so like this:

---* {$to_prefix}pm_recipients
SELECT
mt_msg_id AS ID_PM, mt_to_id AS ID_MEMBER, MIN(mt_hide_cc) AS bcc,
IF(MAX(mt_user_read) > 0, 1, 0) AS is_read
FROM {$from_prefix}message_topics
WHERE mt_vid_folder != 'sent' OR mt_from_id != mt_to_id
GROUP BY mt_msg_id, mt_to_id;
---*

Hendrik Jan Visser
Former Lead Developer & Co-founder www.simplemachines.org
Personal Signature:
Realitynet.nl -> ExpeditieRobinson.net / PekingExpress.org / WieIsDeMol.Com

Champi

ok that functions.. now i get

Converting moderators... Unsuccessful!
This query:

    INSERT INTO `mkportal1`.smf_moderators
    (ID_MEMBER, ID_BOARD)
    VALUES ('-1', '2'),
    ('-1', '3'),
    ('-1', '4'),
    ('-1', '5'),
    ('-1', '7'),
    ('-1', '8'),

etcetc
     ('-1', '13'),
    ('-1', '28'),
    ('-1', '29'),
    ('-1', '33'),
    ('-1', '32'),
    ('-1', '32');

Caused the error:

    Duplicate entry '2-0' for key 1

do you think i have to modify everythin in the tables..

Compuart

I think (invision2_to_smf.sql):
---* {$to_prefix}moderators
SELECT member_id AS ID_MEMBER, forum_id AS ID_BOARD
FROM {$from_prefix}moderators
WHERE member_id != 1;
---*


has to be:
---* {$to_prefix}moderators
SELECT member_id AS ID_MEMBER, forum_id AS ID_BOARD
FROM {$from_prefix}moderators
WHERE member_id != -1;
---*


Sorry about these errors, the convertors are still in alpha/beta stage.
Hendrik Jan Visser
Former Lead Developer & Co-founder www.simplemachines.org
Personal Signature:
Realitynet.nl -> ExpeditieRobinson.net / PekingExpress.org / WieIsDeMol.Com

Champi

doesnt matter... no problem about the errors.. i am gla the fault isnt in my installation..  ;)

Champi

it works perfectly... please modify the orignal file.. otherwise you get hundred questions..

greetz and thnx  :)

Compuart

Done. Thanks for the feedback.
Hendrik Jan Visser
Former Lead Developer & Co-founder www.simplemachines.org
Personal Signature:
Realitynet.nl -> ExpeditieRobinson.net / PekingExpress.org / WieIsDeMol.Com

cesar

I try to use the eblah converter but i get the error:

Quote
E-Blah Platinum 9 to SMF Converter
Converting...
Unsuccessful!
This query:

    ALTER TABLE `foro`.smf_personal_messages
    CHANGE COLUMN ID_PM ID_PM int(10) unsigned NOT NULL default 0,
    DROP PRIMARY KEY,
    ADD temp_toName tinytext;

Caused the error:

    Duplicate column name 'temp_toName'


I need help with that.

Thanks in advance.

Compuart

try replacing (eblah_to_smf.php)
convert_query("
ALTER TABLE {$to_prefix}personal_messages
CHANGE COLUMN ID_PM ID_PM int(10) unsigned NOT NULL default 0,
DROP PRIMARY KEY,
ADD temp_toName tinytext");


by:
convert_query("
ALTER TABLE {$to_prefix}personal_messages
DROP COLUMN temp_toName", true);
convert_query("
ALTER TABLE {$to_prefix}personal_messages
CHANGE COLUMN ID_PM ID_PM int(10) unsigned NOT NULL default 0,
DROP PRIMARY KEY,
ADD temp_toName tinytext");


This should make sure the column is dropped before it's created.
Hendrik Jan Visser
Former Lead Developer & Co-founder www.simplemachines.org
Personal Signature:
Realitynet.nl -> ExpeditieRobinson.net / PekingExpress.org / WieIsDeMol.Com

MysticBrewing

I get the following error when converting a phpBB 2.0.7 board to 1.1rc1.. any clues??

Converting boards... Unsuccessful!
This query:
INSERT INTO `reality_smf1`.smf1_boards
(ID_BOARD, boardOrder, numPosts, ID_LAST_MSG, name, ID_CAT, description, numTopics, memberGroups)
VALUES ('2', '10', '1684', '12696', 'BB Anonymous', '2', 'BB6 is over. Are you going through withdrawals? Join our recovery program inside...lol...', '240', '-1,0,2'),
('27', '20', '804', '12765', 'BB Bulletins', '2', 'News to keep you in the know and links to recaps of episodes you might have missed...', '618', '-1,0,2'),
('4', '30', '360', '10443', 'Live Feed Updates', '2', 'Up-to-the-minute updates on what BB6 Houseguests are doing...', '130', '-1,0,2'),
('50', '30', '33', '12744', 'Wife Swap', '11', '', '22', '-1,0,2'),
('61', '10', '145', '12621', 'Survivor: Guatemala Scrutiny', '15', 'Sixteen Survivors...two big twists... Who will Outwit, Outplay, and Outlast?', '27', '-1,0,2'),
('9', '10', '130', '12863', 'Multitude of the Masses', '6', 'This is where you can discuss all the other reality shows with other reality junkies...', '40', '-1,0,2'),
('55', '70', '60', '12822', 'The Apprentice: Martha Stewart', '11', '', '59', '-1,0,2'),
('56', '20', '72', '12829', 'Three Wishes', '11', '', '63', '-1,0,2'),
('52', '40', '21', '12573', 'Supernanny', '11', '', '15', '-1,0,2'),
('13', '10', '2872', '12857', 'The Grapevine', '8', 'Talk about anything here...and everything...', '265', '0,2'),
('14', '40', '213', '12862', 'The Exchange', '8', 'Questions? Complaints? Compliments? Meet with admins here... Keep up to date with RTVG updates and announcements...', '20', '-1,0,2'),
('15', '40', '107', '12826', 'Casting Calls', '6', 'You might discover a reality show you would like to audition for...', '81', '-1,0,2'),
('18', '50', '84', '12064', 'The Conclave', '8', 'Top secret...admin only...', '7', ''),
('20', '40', '230', '9337', 'Live Feed Captures', '2', 'Favorite moments captured as pics during live feeds...', '57', '-1,0,2'),
('24', '50', '18', '8825', 'Reality Links', '6', 'Other sites devoted to reality tv...', '3', '-1,0,2'),
('53', '50', '41', '12832', 'The Biggest Loser', '11', '', '39', '-1,0,2'),
('25', '30', '46', '12769', 'Upcoming Reality Shows', '6', 'New show announcements and schedules...', '36', '-1,0,2'),
('-99', '1', '0', '0', 'INDEX PAGE', '0', 'Index Page Control', '0', '-1,0,2'),
('-7', '1', '0', '0', 'MEMBERLIST', '0', 'Memberlist Control', '0', '-1,0,2'),
('28', '20', '330', '12830', 'MOTM Morsels', '6', 'News and updates about reality tv in general...', '282', '-1,0,2'),
('41', '50', '157', '10858', 'BB6 Houseguests', '2', 'Find info and discuss your favorite houseguests here...', '14', '-1,0,2'),
('47', '80', '202', '12824', 'American Idol', '11', '', '198', '-1,0,2'),
('66', '20', '49', '12861', 'The Amazing Race 8: Family Edition', '16', 'Discuss the first-ever family edition of TAR...', '5', '-1,0,2'),
('69', '20', '479', '12791', 'Cause Celebre: Reality Enquirer', '8', 'www.realityenquirer.blogspot.com airs a lot of dirty laundry about different internet sites that revolve around reality tv discussion... Step inside to discuss RE\'s latest gossip...', '25', '0,2'),
('54', '60', '88', '12828', 'The Apprentice', '11', '', '81', '-1,0,2'),
('68', '30', '633', '12855', 'Square Peg Through Round Hole', '8', 'Have something to say but don\'t want anyone to know you\'re saying it? This is the forum for you... Registered members only may post... Please read guidelines inside...', '33', '-1,0,2'),
('59', '60', '18', '7827', 'Reality Interviews', '6', 'Q & A sessions with contestants on reality shows...', '9', '-1,0,2'),
('62', '20', '234', '12772', 'Survivor Sensations', '15', 'News and updates on current and past seasons and Survivors...', '210', '-1,0,2'),
('65', '30', '102', '12835', 'TAR Tellings', '16', 'News and updates about past and current seasons and contestants...', '95', '-1,0,2'),
('70', '100', '4', '12569', 'Starting Over', '11', '', '2', '-1,0,2'),
('73', '10', '122', '12794', 'Small Screen', '19', 'LOST, Invasion, Threshold, others...discuss them here...', '9', '-1,0,2'),
('74', '20', '25', '12690', 'Small Screen News', '19', 'Commentaries and recaps...', '23', '-1,0,2');
Caused the error:

Duplicate entry '2' for key 1

Advertisement: