1.1 Converters

Sven0 · November 30, 2005, 11:30:32 AM

i still need help, i need a RepairBoards.php which loads in steps to avoid the mySQL time out or i need the SQL code to drop it manually in phpmyadmin....

any ideas?

chanh · December 01, 2005, 09:55:51 AM

I use Mambo 4.5.2.3, SMF 1.1 RC1, Mambo-SMF.

I run convert.php with simpleboard_to_smf.sql

In Simpleboard:
Testing

After run convert.php, I got this in SMF
T[img width=][img width=]t[img width=]n[img width=]

What am I missing?

Thanks

nextrance · December 01, 2005, 05:57:57 PM

I'm having some issues converting from Invision v2.1.3 to SMF 1.1RC1. Here's the error:

Code Select

Converting...
Converting poll options... 
Notice: Array to string conversion in /home/azinfol/public_html/smf/convert.php(1627) : eval()'d code on line 8

Notice: Array to string conversion in /home/azinfol/public_html/smf/convert.php(1627) : eval()'d code on line 8

Notice: Array to string conversion in /home/azinfol/public_html/smf/convert.php(1627) : eval()'d code on line 8

Notice: Array to string conversion in /home/azinfol/public_html/smf/convert.php(1627) : eval()'d code on line 8

Notice: Array to string conversion in /home/azinfol/public_html/smf/convert.php(1627) : eval()'d code on line 8

Notice: Array to string conversion in /home/azinfol/public_html/smf/convert.php(1627) : eval()'d code on line 8

Notice: Array to string conversion in /home/azinfol/public_html/smf/convert.php(1627) : eval()'d code on line 8

Notice: Array to string conversion in /home/azinfol/public_html/smf/convert.php(1627) : eval()'d code on line 8

Notice: Array to string conversion in /home/azinfol/public_html/smf/convert.php(1627) : eval()'d code on line 8

Notice: Array to string conversion in /home/azinfol/public_html/smf/convert.php(1627) : eval()'d code on line 8

Notice: Array to string conversion in /home/azinfol/public_html/smf/convert.php(1627) : eval()'d code on line 8

Notice: Array to string conversion in /home/azinfol/public_html/smf/convert.php(1627) : eval()'d code on line 8

Notice: Array to string conversion in /home/azinfol/public_html/smf/convert.php(1627) : eval()'d code on line 8

Notice: Array to string conversion in /home/azinfol/public_html/smf/convert.php(1627) : eval()'d code on line 8
Unsuccessful!
This query:
INSERT INTO `azinfol_smf`.smf_poll_choices

(ID_POLL, ID_CHOICE, label, votes)

VALUES (538, 'What - if any - political party do you associate with?', 'Array', 'Array'),

(538, 'Do you consider yourself ...', 'Array', 'Array'),

(538, 'What is your religion?', 'Array', 'Array'),

(535, 'Which are you?', 'Array', 'Array'),

(536, 'How do you feel about your body after reading a popular women&#39;s magazine ( i.e. cosmo, glamour, etc)?', 'Array', 'Array'),

(537, 'What did you do while AZInfoline was down?', 'Array', 'Array'),

(534, 'If you found an abandoned DJ, what would you do with it?', 'Array', 'Array');
Caused the error:
Duplicate entry '538-0' for key 1

This appears to be from the multiple-question-per-poll feature of Invision. Is there a workaround for this? I can live without the polls, or perhaps just the first poll question, so any help would be really appreciated.

Oldiesmann · December 02, 2005, 01:14:48 PM

Unfortunately, SMF only allows one question per poll. I'm working on fixing the issues for 2.1.3 at the moment, so I'll just have SMF pull the first poll question for each one.

nextrance · December 04, 2005, 07:21:19 PM

Any luck?

egiraudy · December 05, 2005, 02:26:57 AM

Infinite loop when converting a phpBB forum.

While converting a small phpbb2.0.2 forum to smf, i faced an infinite loop during the attachment convertion (substep 10).
My forum contains no attachments but a small number of uploaded avatars. The issue comes from the following statement:

Code Select

            // Probably not one of the converted ones, then?
            if (!file_exists($filename))
               continue;

This means the row is not processed and then will be retrieved again on the next loop, again and again...

In my case i just disabled the step and everthing went smooth...

CoasterJoe.com · December 05, 2005, 06:47:17 AM

I'm converting from Ikonboard 3.1.2a and I get this error message. Any thought on what is wrong?

Converting topic notifications... Unsuccessful!
This query:

INSERT INTO `floridac_smf`.smf_log_notify
(ID_MEMBER, ID_TOPIC, sent)
VALUES ('10', '267', ''),
('20', '98', ''),
('20', '230', ''),
('24', '1', ''),
('24', '2', ''),
('24', '3', ''),
('24', '3', ''),
('24', '4', ''),
('24', '5', ''),
('24', '5', ''),
('24', '5', ''),
('24', '6', ''),
('24', '6', ''),
('24', '6', ''),
('24', '7', ''),
('24', '7', ''),
('24', '7', ''),
('24', '8', ''),
('24', '9', ''),
('24', '9', ''),
('24', '9', ''),
('24', '9', ''),
('24', '10', ''),
('24', '11', ''),
('24', '12', ''),
('24', '13', ''),
('24', '15', ''),
('24', '16', ''),
('24', '17', ''),
('24', '17', ''),
('24', '18', ''),
('24', '19', ''),
('24', '19', ''),
('24', '19', ''),
('24', '20', ''),
('24', '20', ''),
('24', '21', ''),
('24', '21', ''),
('24', '22', ''),
('24', '23', ''),
('24', '23', ''),
('24', '24', ''),
('24', '25', ''),
('24', '26', ''),
('24', '27', ''),
('24', '28', ''),
('24', '29', ''),
('24', '30', ''),
('24', '31', ''),
('24', '31', ''),
('24', '32', ''),
('24', '33', ''),
('24', '34', ''),
('24', '35', ''),
('24', '36', ''),
('24', '37', ''),
('24', '37', ''),
('24', '38', ''),
('24', '39', ''),
('24', '40', ''),
('24', '41', ''),
('24', '42', ''),
('24', '42', ''),
('24', '43', ''),
('24', '44', ''),
('24', '46', ''),
('24', '48', ''),
('24', '49', ''),
('24', '50', ''),
('24', '51', ''),
('24', '52', ''),
('24', '53', ''),
('24', '53', ''),
('24', '53', ''),
('24', '54', ''),
('24', '54', ''),
('24', '56', ''),
('24', '57', ''),
('24', '58', ''),
('24', '58', ''),
('24', '58', ''),
('24', '59', ''),
('24', '60', ''),
('24', '61', ''),
('24', '62', ''),
('24', '62', ''),
('24', '62', ''),
('24', '63', ''),
('24', '63', ''),
('24', '65', ''),
('24', '66', ''),
('24', '67', ''),
('24', '68', '0'),
('24', '69', ''),
('24', '70', ''),
('24', '71', ''),
('24', '72', ''),
('24', '73', ''),
('24', '73', ''),
('24', '73', ''),
('24', '73', ''),
('24', '74', ''),
('24', '75', ''),
('24', '75', ''),
('24', '76', ''),
('24', '77', ''),
('24', '78', ''),
('24', '79', ''),
('24', '80', ''),
('24', '81', ''),
('24', '82', ''),
('24', '83', ''),
('24', '84', ''),
('24', '84', ''),
('24', '85', ''),
('24', '86', ''),
('24', '86', ''),
('24', '86', ''),
('24', '88', ''),
('24', '88', ''),
('24', '89', ''),
('24', '89', ''),
('24', '89', ''),
('24', '90', ''),
('24', '90', ''),
('24', '91', ''),
('24', '91', ''),
('24', '92', ''),
('24', '93', ''),
('24', '94', ''),
('24', '95', ''),
('24', '96', ''),
('24', '97', ''),
('24', '98', ''),
('24', '99', ''),
('24', '99', ''),
('24', '99', ''),
('24', '100', ''),
('24', '101', ''),
('24', '102', ''),
('24', '103', ''),
('24', '104', ''),
('24', '105', ''),
('24', '105', ''),
('24', '105', ''),
('24', '106', ''),
('24', '106', ''),
('24', '107', ''),
('24', '107', ''),
('24', '108', ''),
('24', '109', ''),
('24', '110', ''),
('24', '111', ''),
('24', '111', ''),
('24', '111', ''),
('24', '111', ''),
('24', '112', ''),
('24', '113', ''),
('24', '114', ''),
('24', '115', ''),
('24', '115', ''),
('24', '116', ''),
('24', '117', ''),
('24', '117', ''),
('24', '118', ''),
('24', '119', ''),
('24', '121', ''),
('24', '122', ''),
('24', '123', ''),
('24', '124', ''),
('24', '125', ''),
('24', '126', ''),
('24', '127', ''),
('24', '127', ''),
('24', '127', ''),
('24', '127', ''),
('24', '128', ''),
('24', '129', ''),
('24', '130', ''),
('24', '131', ''),
('24', '133', ''),
('24', '134', ''),
('24', '134', ''),
('24', '135', ''),
('24', '136', ''),
('24', '136', ''),
('24', '137', ''),
('24', '138', ''),
('24', '139', ''),
('24', '140', ''),
('24', '142', ''),
('24', '143', '0'),
('24', '143', '0'),
('24', '143', '0'),
('24', '143', '0'),
('24', '143', '0'),
('24', '143', '0'),
('24', '144', ''),
('24', '144', ''),
('24', '145', ''),
('24', '146', ''),
('24', '147', ''),
('24', '147', ''),
('24', '148', ''),
('24', '149', ''),
('24', '150', ''),
('24', '150', ''),
('24', '151', ''),
('24', '152', ''),
('24', '153', ''),
('24', '154', ''),
('24', '155', ''),
('24', '156', ''),
('24', '157', ''),
('24', '158', ''),
('24', '159', ''),
('24', '160', ''),
('24', '161', ''),
('24', '162', ''),
('24', '162', ''),
('24', '162', ''),
('24', '163', ''),
('24', '164', ''),
('24', '165', ''),
('24', '166', ''),
('24', '167', ''),
('24', '167', ''),
('24', '167', ''),
('24', '168', ''),
('24', '168', ''),
('24', '169', ''),
('24', '170', ''),
('24', '170', ''),
('24', '170', ''),
('24', '170', ''),
('24', '171', ''),
('24', '172', ''),
('24', '173', ''),
('24', '173', ''),
('24', '174', ''),
('24', '175', ''),
('24', '176', ''),
('24', '176', ''),
('24', '177', ''),
('24', '177', ''),
('24', '178', ''),
('24', '179', ''),
('24', '180', ''),
('24', '180', ''),
('24', '180', ''),
('24', '180', ''),
('24', '180', ''),
('24', '180', ''),
('24', '181', ''),
('24', '183', ''),
('24', '184', ''),
('24', '184', ''),
('24', '185', ''),
('24', '186', ''),
('24', '187', ''),
('24', '187', ''),
('24', '187', ''),
('24', '187', ''),
('24', '188', ''),
('24', '189', ''),
('24', '190', ''),
('24', '191', ''),
('24', '194', ''),
('24', '194', ''),
('24', '194', ''),
('24', '194', ''),
('24', '195', ''),
('24', '196', ''),
('24', '197', ''),
('24', '199', ''),
('24', '200', ''),
('24', '201', ''),
('24', '202', ''),
('24', '203', ''),
('24', '204', ''),
('24', '205', ''),
('24', '205', ''),
('24', '206', ''),
('24', '207', ''),
('24', '208', ''),
('24', '208', ''),
('24', '208', ''),
('24', '208', ''),
('24', '209', ''),
('24', '210', ''),
('24', '212', ''),
('24', '213', ''),
('24', '213', ''),
('24', '214', ''),
('24', '215', '0'),
('24', '215', '0'),
('24', '216', ''),
('24', '217', ''),
('24', '218', ''),
('24', '219', ''),
('24', '220', ''),
('24', '221', ''),
('24', '222', ''),
('24', '222', ''),
('24', '223', ''),
('24', '223', ''),
('24', '224', ''),
('24', '224', ''),
('24', '225', ''),
('24', '226', ''),
('24', '227', ''),
('24', '228', ''),
('24', '229', ''),
('24', '229', ''),
('24', '229', ''),
('24', '230', ''),
('24', '230', ''),
('24', '231', ''),
('24', '232', ''),
('24', '232', ''),
('24', '232', ''),
('24', '232', ''),
('24', '233', ''),
('24', '234', ''),
('24', '234', ''),
('24', '234', ''),
('24', '234', ''),
('24', '235', ''),
('24', '235', ''),
('24', '236', ''),
('24', '237', ''),
('24', '238', ''),
('24', '238', ''),
('24', '239', ''),
('24', '239', ''),
('24', '239', ''),
('24', '239', ''),
('24', '239', ''),
('24', '239', ''),
('24', '239', ''),
('24', '240', ''),
('24', '241', ''),
('24', '242', ''),
('24', '243', ''),
('24', '244', ''),
('24', '245', ''),
('24', '246', ''),
('24', '246', ''),
('24', '247', ''),
('24', '248', '0'),
('24', '249', ''),
('24', '250', ''),
('24', '251', ''),
('24', '252', ''),
('24', '253', ''),
('24', '253', ''),
('24', '254', ''),
('24', '255', ''),
('24', '255', ''),
('24', '255', ''),
('24', '256', ''),
('24', '257', ''),
('24', '258', ''),
('24', '259', ''),
('24', '260', ''),
('24', '261', ''),
('24', '262', ''),
('24', '264', ''),
('24', '266', ''),
('24', '266', ''),
('24', '266', ''),
('24', '266', ''),
('24', '266', ''),
('24', '267', ''),
('24', '267', ''),
('24', '268', ''),
('24', '269', ''),
('24', '270', ''),
('24', '271', ''),
('24', '272', ''),
('24', '273', ''),
('24', '274', ''),
('24', '275', ''),
('24', '276', ''),
('24', '276', ''),
('24', '276', ''),
('24', '277', ''),
('24', '279', ''),
('24', '280', ''),
('24', '283', ''),
('24', '284', ''),
('24', '284', ''),
('24', '284', ''),
('24', '285', ''),
('24', '286', '1'),
('24', '287', ''),
('24', '287', ''),
('24', '288', '0'),
('24', '552', '1'),
('24', '553', '0'),
('24', '558', '1'),
('24', '564', '0'),
('24', '567', '0'),
('24', '568', '1'),
('24', '568', '1'),
('24', '570', '1'),
('24', '573', '1'),
('24', '576', '0'),
('24', '577', '1'),
('24', '592', '1'),
('24', '592', '1'),
('24', '596', '0'),
('24', '597', '1'),
('24', '597', '1'),
('24', '598', '0'),
('24', '608', '0'),
('24', '608', '0'),
('24', '608', '0'),
('24', '610', '0'),
('24', '611', '0'),
('24', '612', '0'),
('24', '613', '0'),
('24', '614', '0'),
('24', '618', '0'),
('24', '618', '0'),
('24', '623', '0'),
('24', '624', '1'),
('24', '625', '1'),
('24', '628', '0'),
('24', '289', ''),
('24', '290', ''),
('24', '292', ''),
('24', '293', ''),
('24', '293', ''),
('24', '293', ''),
('24', '294', ''),
('24', '295', ''),
('24', '296', ''),
('24', '297', ''),
('24', '298', ''),
('24', '299', ''),
('24', '299', ''),
('24', '300', ''),
('24', '301', ''),
('24', '302', ''),
('24', '303', ''),
('24', '304', ''),
('24', '305', ''),
('24', '306', ''),
('24', '307', ''),
('24', '308', ''),
('24', '309', ''),
('24', '310', ''),
('24', '311', ''),
('24', '311', ''),
('24', '312', ''),
('24', '314', ''),
('24', '315', ''),
('24', '315', ''),
('24', '315', ''),
('24', '315', ''),
('24', '315', ''),
('24', '316', ''),
('24', '316', ''),
('24', '317', ''),
('24', '317', ''),
('24', '317', ''),
('24', '317', ''),
('24', '317', ''),
('24', '317', ''),
('24', '317', ''),
('24', '318', ''),
('24', '318', ''),
('24', '319', ''),
('24', '319', ''),
('24', '319', ''),
('24', '319', ''),
('24', '319', ''),
('24', '319', ''),
('24', '319', ''),
('24', '319', ''),
('24', '319', ''),
('24', '319', ''),
('24', '319', ''),
('24', '320', ''),
('24', '320', ''),
('24', '320', ''),
('24', '320', ''),
('24', '320', ''),
('24', '320', ''),
('24', '320', ''),
('24', '321', ''),
('24', '322', ''),
('24', '322', ''),
('24', '322', ''),
('24', '322', ''),
('24', '322', ''),
('24', '323', ''),
('24', '325', ''),
('24', '326', '');

Caused the error:

Duplicate entry '10-267-0' for key 1

bRuslius · December 06, 2005, 12:23:00 PM

didn`t read now,

maby somebody asked it.
but if my prefix iz ldp_ not phpBB

will http://www.simplemachines.org/download.php?converters phpbb2_to_smf.php work?
and HOW it works?

no manual

i`m not good at php so didnt understood :/ sorry for abuse ;(

fnord · December 06, 2005, 11:28:30 PM

I'm trying to use the phpbb2_to_smf.php but it keeps failing with this error:

QuoteThe installation of SMF in the path you specified is not a version this converter can deal with. If it is older than SMF 1.0, you need to upgrade first. If it is newer, you need to use a different converter.

This is with a new install of smf_1-1-rc1_install.tar.gz and an existing phpbb 2.0.10. Any ideas? Also where is this convert.php I see people talking about.. I can't find it anywhere.

bRuslius · December 07, 2005, 12:00:15 AM

http://www.simplemachines.org/community/index.php?topic=38966.0
first post

fnord · December 07, 2005, 08:42:44 AM

whoops don't mine me~

nextrance · December 07, 2005, 06:06:29 PM

Has there been any progress on the IPB 2.1.3 converter? I'm dying to switch away, but vB is starting to look pretty good at this point...

mellie · December 09, 2005, 12:11:47 PM

Quote from: Compuart on November 10, 2005, 11:00:35 AM
The board you're converting from contains some integrity errors that prevent topics to be inserted. Most likely some of the topics have equal last messages. The easiest way to work around it is to change the indexes of the topics table to non-unique indexes:
Code Select Expand
ALTER TABLE smf_topics DROP INDEX lastMessage, DROP INDEX firstMessage, DROP INDEX poll, ADD INDEX lastMessage (ID_LAST_MSG, ID_BOARD), ADD INDEX firstMessage (ID_FIRST_MSG, ID_BOARD), ADD INDEX poll (ID_POLL, ID_TOPIC)

After everything is converted, you can use the 'repair boards' function and readd the unique indexes if you like.

I have tried the above while attempting to convert phpbb 2.0.18 to smf 1.1 and have been getting following error message:

__________________________________________________________
Converting posts (this may take some time)... Unsuccessful!
This query:
INSERT INTO `blahblah`.smf_messages
(ID_MSG, ID_TOPIC, posterTime, ID_MEMBER, posterEmail, subject, posterName, smileysEnabled, modifiedTime, posterIP, body, ID_BOARD)
VALUES ('7585',

Caused the error:

Duplicate entry '7585' for key 1
_________________________________________________

Will appreciate it if anyone can help me. Thanks in advance.

Cheers,
Mellie

MotMann · December 18, 2005, 03:04:29 PM

i Have SMF 1.1 RC 1 an the phpBB2 Converter from August 2005.
i got the Error:
The installation of SMF in the path you specified is not a version this converter can deal with. If it is older than SMF 1.0, you need to upgrade first. If it is newer, you need to use a different converter.

What happened?

beemer · December 19, 2005, 06:50:14 AM

Quote from: CoasterJoe.com on December 05, 2005, 06:47:17 AM
I'm converting from Ikonboard 3.1.2a and I get this error message. Any thought on what is wrong?

Converting topic notifications... Unsuccessful!
This query:

Caused the error:

Duplicate entry '10-267-0' for key 1

I had a few of these errors when I converted my IB, I think from memory I had phpmyadmin open at the same time and tried deleting the offending duplicate - didnt work

So I deleted any topic notifications from the IB database to start with

keisa · December 19, 2005, 07:09:35 AM

it has forteh past liek 2-3 hrs been giving me this

Code Select

Recalculating forum statistics... Incomplete.

um iyts stilldoing it i dunno can i close it ? ad asuem its all fine?

Trekkie101 · December 20, 2005, 04:53:05 AM

Quote from: keisa on December 19, 2005, 07:09:35 AM
it has forteh past liek 2-3 hrs been giving me this

Code Select Expand
Recalculating forum statistics... Incomplete.

um iyts stilldoing it i dunno can i close it ? ad asuem its all fine?

What system are you converting from?

How large is the board?

Depending, it could be normal.

Oldiesmann · December 20, 2005, 10:26:46 AM

There seems to be a bug in the converter that causes it to keep doing that and never finish. It should be safe to ignore the problem and go on to the converted board as that's the last step in the converter.

keisa · December 24, 2005, 09:53:47 AM

Quote from: Oldiesmann on December 20, 2005, 10:26:46 AM
There seems to be a bug in the converter that causes it to keep doing that and never finish. It should be safe to ignore the problem and go on to the converted board as that's the last step in the converter.

ah thx to you oldesmann!

ajburnett34 · December 27, 2005, 03:16:20 PM

is there a converter for mybb, because i searched and because in this topic (http://www.simplemachines.org/community/index.php?topic=56889.0) spicyjoe said he used the mybb converter, so i was wondering.

thanks

News:

1.1 Converters

CoasterJoe.com