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

Compuart

Quote from: ajburnett34 on 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
It's in the first post of this topic.
Hendrik Jan Visser
Former Lead Developer & Co-founder www.simplemachines.org
Personal Signature:
Realitynet.nl -> ExpeditieRobinson.net / PekingExpress.org / WieIsDeMol.Com

KSE75

I have a an error converting phpbb2 (last version 2.0.19)  to SMF RC1:

Converting topic notifications... Unsuccessful!
This query:

    INSERT INTO `tcmtotal_forum`.smf_log_notify
    (ID_MEMBER, ID_TOPIC)
    VALUES ('2', '2'),
    ('2', '3'),

...

     ('2', '294'),
    ('105', '280');

Caused the error:

    Duplicate entry '2-2-0' for key 1


Somebody knows what is wrong?

Maybe usefull: the full log
O Porto é uma Nação
FIFA Manager

lonestarscorpio

I am converting to 1.1 RC1  from Vbulletin 3.0.8.  I am in a loop:
Converting...
Recalculating forum statistics... Incomplete.


I have optimized and repaired the VB tables, recounted statistics.. it still loops. Any ideas of what I need to do?

Thank you so much- I am just grateful for a vB3 converter- I am so tired of being under their thumb!

lonestarscorpio

Well I just checked the smf forum and it seems everything, including the attachments are there- even though the converter was in a loop-- does that mean it should be in the clear?

TheMaTrIx

You can recallculate forum statistics from the admin pages after the conversion.
You need to do that and check for orphin threads/forums/category's/PM/messages anyways.

A long running VB install tends to litter its database with quite a few orphins.

Unshra

Tried converting from Invision 2 boards and got the following:

QuoteConverting members... Successful.
Converting categories... Successful.
Converting boards... Successful.
Converting topics... Successful.
Converting posts (this may take some time)... Successful.
Converting polls... Successful.
Converting poll options... Successful.
Converting poll logs... Successful.
Converting personal messages (step 1)... Successful.
Converting personal messages (step 2)... Successful.
Converting topic notifications... Successful.
Converting board notifications... Successful.
Converting moderators... Successful.
Converting yearly events... Successful.
Converting permissions... Successful.
Converting board permissions...
Notice: unserialize(): Error at offset 5 of 200 bytes in /home/theredee/public_html/boards/convert.php(653) : eval()'d code on line 89

Fatal error: Unsupported operand types in /home/theredee/public_html/boards/convert.php(653) : eval()'d code on line 89

-Unshra

PlzSuM1hLpMe

#306
phpbb2.0.19 convert (everything newest version):

Converting ranks... Successful.
Converting groups... Successful.
Converting members... Successful.
Converting additional member groups... Successful.
Converting categories... Successful.
Converting boards... Successful.
Converting topics... Unsuccessful!
This query:

    INSERT INTO `sonofsam`.smf_topics
    (ID_TOPIC, isSticky, ID_FIRST_MSG, ID_LAST_MSG, ID_MEMBER_STARTED, ID_MEMBER_UPDATED, ID_BOARD, ID_POLL, locked, numReplies, numViews)
    VALUES ('2', '0', '2', '157', '3', '2', '3', '', '0', '18', '282'),
    ('3', '0', '3', '181', '3', '10', '1', '', '0', '5', '44'),
    ('4', '0', '5', '193', '3', '3', '1', '', '0', '12', '90'),
    ('5', '0', '15', '516', '2', '10', '3', '', '0', '20', '362'),
    ('6', '0', '22', '65', '3', '3', '1', '', '0', '11', '68'),
    ('7', '0', '38', '844', '3', '42', '3', '', '0', '31', '871'),
    ('8', '0', '48', '1228', '-1', '3', '3', '', '0', '6', '213'),
    ('9', '0', '51', '205', '2', '2', '3', '', '1', '17', '402'),
...
    ('108', '0', '816', '5645', '39', '5', '5', '', '0', '4', '333'),
    ('109', '0', '817', '5640', '29', '5', '5', '', '0', '3', '206'),
    ('110', '0', '820', '830', '42', '42', '1', '', '0', '1', '26'),
    ('111', '0', '823', '828', '2', '42', '1', '', '0', '2', '55'),
    ('112', '0', '834', '1088', '29', '3', '1', '', '0', '10', '73'),
...
    ('582', '0', '5369', '5424', '7', '2', '1', '18', '0', '12', '62');

Caused the error:

    Duplicate entry '110-3' for key 2


When will this duplicate entry problem solved??

piskè

#307
1 have this error converting from mybb1.00 Preview Release 2


when converting topics...
INSERT INTO `my_databasename`.smf_log_topics
(ID_TOPIC, ID_MEMBER, logTime)
VALUES ('350', '4', '1130950869'),
('46', '2', '1130965344'),
('369', '42', '1130965536'),
ecc...
Converting topic view logs... Unsuccessful!

Caused the error:

Unknown column 'logTime' in 'field list'


mybb. it's a nice board indeed but without convertors it just sucks)

Compuart

Quote from: piskè on January 02, 2006, 07:05:04 PM
1 have this error converting from mybb1.00 Preview Release 2


when converting topics...
INSERT INTO `my_databasename`.smf_log_topics
(ID_TOPIC, ID_MEMBER, logTime)
VALUES ('350', '4', '1130950869'),
('46', '2', '1130965344'),
('369', '42', '1130965536'),
ecc...
Converting topic view logs... Unsuccessful!

Caused the error:

Unknown column 'logTime' in 'field list'


mybb. it's a nice board indeed but without convertors it just sucks)
Currently the converters are only compatible for 1.1 RC 1. We will be updating the converters soon for 1.1 RC2. In the meantime it's easier to install a 1.1 RC1 forum, run the converter and if everything went well, upgrade your SMF forum to RC2
Hendrik Jan Visser
Former Lead Developer & Co-founder www.simplemachines.org
Personal Signature:
Realitynet.nl -> ExpeditieRobinson.net / PekingExpress.org / WieIsDeMol.Com

piskè

#309
LOL didn't notice the link to the Archived Releases.  :x

i'll upload and install again this time 1.1 RC 1 (just hope the convertor will work fine with the mybb1.00 Preview Release 2)

piskè

oh ******...


Converting attachments... Unsuccessful!
This query:
SELECT pid AS ID_MSG, filedata, downloads, filename, filesize
FROM `my_database`.forums_attachments
LIMIT 0, 500;
Caused the error:

Unknown column 'filedata' in 'field list'

why's that?

Unshra

Managed to work around my problem by converting Invision2 to phpBB2 then converting phpBB2 to SMF.

-Unshra

Harzem

This is not an answer for any post, just my experience. For ones who are interested.

phpBB converter worked well on my phpBB 2.0.19 forum with attachment mod, to SMF 1.1 RC2. It only generated one "unsuccessfull" error, but it was about forum stats and can easily be corrected using SMF Admin pages. Don't forget to optimize tables and other stuff at Forum Maintainance after converting.

tfbiii

I just installed RC2 - is there any way to import from Netbula AnyBoard 9? I'm using the flat files DB and NOT SQL for my Anyboard install. Thanks, - Fred

PlzSuM1hLpMe

phpbb2.0.19 convert (everything newest version):

Converting ranks... Successful.
Converting groups... Successful.
Converting members... Successful.
Converting additional member groups... Successful.
Converting categories... Successful.
Converting boards... Successful.
Converting topics... Unsuccessful!
This query:

    INSERT INTO `sonofsam`.smf_topics
    (ID_TOPIC, isSticky, ID_FIRST_MSG, ID_LAST_MSG, ID_MEMBER_STARTED, ID_MEMBER_UPDATED, ID_BOARD, ID_POLL, locked, numReplies, numViews)
    VALUES ('2', '0', '2', '157', '3', '2', '3', '', '0', '18', '282'),
    ('3', '0', '3', '181', '3', '10', '1', '', '0', '5', '44'),
    ('4', '0', '5', '193', '3', '3', '1', '', '0', '12', '90'),
    ('5', '0', '15', '516', '2', '10', '3', '', '0', '20', '362'),
    ('6', '0', '22', '65', '3', '3', '1', '', '0', '11', '68'),
    ('7', '0', '38', '844', '3', '42', '3', '', '0', '31', '871'),
    ('8', '0', '48', '1228', '-1', '3', '3', '', '0', '6', '213'),
    ('9', '0', '51', '205', '2', '2', '3', '', '1', '17', '402'),
...
    ('108', '0', '816', '5645', '39', '5', '5', '', '0', '4', '333'),
    ('109', '0', '817', '5640', '29', '5', '5', '', '0', '3', '206'),
    ('110', '0', '820', '830', '42', '42', '1', '', '0', '1', '26'),
    ('111', '0', '823', '828', '2', '42', '1', '', '0', '2', '55'),
    ('112', '0', '834', '1088', '29', '3', '1', '', '0', '10', '73'),
...
    ('582', '0', '5369', '5424', '7', '2', '1', '18', '0', '12', '62');

Caused the error:

    Duplicate entry '110-3' for key 2


When will this duplicate entry problem solved??

kcunck

#315
I am converting from phpBB2 2.0.19 to a fresh install of SMF 1.1 RC2. I downloaded the latest converter and received the following error:

Converting ranks... Successful.
Converting groups... Successful.
Converting members... Successful.
Converting additional member groups... Successful.
Converting categories... Successful.
Converting boards... Successful.
Converting topics... Successful.
Converting posts (this may take some time)... Successful.
Converting polls... Successful.
Converting poll options... Successful.
Converting poll votes... Successful.
Converting personal messages (step 1)... Successful.
Converting personal messages (step 2)... Successful.
Converting topic notifications... Successful.
Converting board access... Successful.
Converting group access... Successful.
Converting moderators... Successful.
Converting avatar gallery images... Successful.
Converting censored words... Successful.
Converting reserved names... Successful.
Converting banned users... Successful.
Converting settings... Successful.
Converting attachment mod (if installed)... Successful.
Recalculating forum statistics... Unsuccessful!
This query:
UPDATE `kcunck`.smf_boards
SET ID_LAST_MSG = 1014, lastUpdated = 1136653871
WHERE ID_BOARD = 3
LIMIT 1;
Caused the error:

Unknown column 'lastUpdated' in 'field list'


The lastUpdated column does not exist. I thought about adding it to the table for the time being and recalculating in the admin panel.

Anyone have any idea? Thanks!

Birger_Nord

Converting...
Recalculating forum statistics... Unsuccessful!
This query:

    UPDATE `ragnaros_bb2`.smf_boards
    SET ID_LAST_MSG = 2, lastUpdated = 1136808639
    WHERE ID_BOARD = 1
    LIMIT 1;

Caused the error:

    Unknown column 'lastUpdated' in 'field list'


What should I do to correct this? It's only a test board, but need to be sure in the future.

Oldiesmann

Run this query in phpMyAdmin and post the results here...

SHOW COLUMNS FROM smf_boards;
Michael Eshom
Christian Metal Fans

Birger_Nord

I must honest admit I don't know to do it. I have tryed in the tab called "Query". But from there I don't know.

kcunck

It isn't trying to pull any data from phpBB tables.

At this step, the converter is trying to take all the avatars from the smf_messages table and give it the correct height and width. It then updates the height and width in the smf_boards table. This is "Step 10" in the converter code. It isn't that important so I removed the lastUpdated part from the query.

However, after I did that, it was stuck in an endless loop.

After some debugging, I discovered Step 10 isn't programmed correctly and would stay in an endless loop. I changed the code to break out and told it to skip that step alltogether.

Bottom line, you could tell it to skip Step 10. Add a "break;" tag at the beginning of Step 10.

Advertisement: