Converting eBlah to SMF

[Jade Elizabeth]

It's been 2 months so you're fine to bump .

[david100351]

I admin two EBlah forums currently, and one SMF.

I'm in no hurry to move, they are both small, they run on minimum resources, etc etc., but I'll feel an awful lot more secure when a working converter is available.

Thanks.

[ThorstenE]

tested on a very small test-system, converter is for SMF 1.1.x.
use convert.php from this topic: http://www.simplemachines.org/community/index.php?topic=140741.0 and the attached eblah1036_to_smf.php

good luck...

Edit: attachment removed, some posts below is a new one..

[warpman999]

I'll take it that this will work for eblah 10.3? I have 10.3.6
I have a question, if I run these steps will the data on my new SMF forum will be overwritten?
If I can copy the members, PM and any attachments associated with the members that would be great.

Any information would be appreciated.

tested on a very small test-system, converter is for SMF 1.1.x.
use convert.php from this topic: http://www.simplemachines.org/community/index.php?topic=140741.0 and the attached eblah1036_to_smf.php

good luck...

[ThorstenE]

I have a question, if I run these steps will the data on my new SMF forum will be overwritten?
If I can copy the members, PM and any attachments associated with the members that would be great.

Yes, the entire SMF data will be overwritten.. Sorry, but there is no merging option available.

[warpman999]

Do you know if it would be possible to create a second SMF and run a test?
Thanks for the info.

I have a question, if I run these steps will the data on my new SMF forum will be overwritten?
If I can copy the members, PM and any attachments associated with the members that would be great.

Yes, the entire SMF data will be overwritten.. Sorry, but there is no merging option available.

[ThorstenE]

Do you know if it would be possible to create a second SMF and run a test?
Thanks for the info.

yes, you could install a second SMF in a different database, then convert your eBlah to this new SMF.

[confused1]

I ran the eblah10.3.6 converter and this is what I got


Converting membergroups... Successful.
Converting members... Successful.
Converting settings... Successful.
Converting personal messages... Successful.
Converting boards and categories... Successful.
Converting mark read data... Unsuccessful!
This query:
INSERT INTO `xxxxxxxx_smf`.smf_log_mark_read
(ID_MEMBER, ID_BOARD)
VALUES ('77', '1'),
('77', '2'),
('77', '3'),

this string continued until it reads

('102', '31');
Caused the error:

Duplicate entry '0-1' for key 1

any ideas?

[ThorstenE]

mhh, would you please try the attached version? This one will use "INSERT IGNORE" instead of a simple "INSERT" and should skip duplicates...

Attention: you have to re-install your destination SMF first,  the converter adds / removes some database indicies during conversion and the current state is  unfortunately broken 

[confused1]

Thankyou for the new file, it did the job. very happy.

One thing that did happen was that all our existing member numbers were all over the place due to some being deleted over the last few years, this resulted in posters names being incorrect through the entire forum.

It was easy to rectify in the database we manually changed every member to their correct number.

Everything else seems in order including private messages.

[Jade Elizabeth]

I got the same error as above, but with the second one I get this:

Code Select Expand

Converting membergroups... Unsuccessful!
This query:

    ALTER TABLE `smfforum`.smf_membergroups
    ADD COLUMN tempMembers longtext,
    ADD COLUMN tempID int NOT NULL default 0;

Caused the error:

    Duplicate column name 'tempID'

[ThorstenE]

Attention: you have to re-install your destination SMF first,  the converter adds / removes some database indicies during conversion and the current state is  unfortunately broken 

[Jade Elizabeth]

I did do that. All the first one did was emptied out of the database.

[ThorstenE]

I did do that. All the first one did was emptied out of the database.

I'm not sure I understand you right?!?
the first one modified some indices while converting your forum,but never finished the work.. a temporary needed index was added but due to a converter errror never removed.  that's the reason you get the " Duplicate column name 'tempID" error now.  You need a clean and unmodified database. The seconed one (http://www.simplemachines.org/community/index.php?action=dlattach;topic=406521.0;attach=166520) should work, as long as your database wasn't touched by the older version of the converter.

[CASMAN]

Me 10

[Jade Elizabeth]

I deleted the DB, reinstalled, and I get this:

Converting members... Unsuccessful!
This query:

    ALTER TABLE `smfforum`.smf_members
    CHANGE COLUMN ID_MEMBER ID_MEMBER mediumint( unsigned NOT NULL auto_increment PRIMARY KEY;

Caused the error:

    Multiple primary key defined

Did I do something wrong again? I'm all confused .

I feel bad cause I can't convert this damn forum lol.

[ThorstenE]

Did I do something wrong again? I'm all confused .

no, I don't think so.. the error message is a bit weird, sonds like the primary key on ID_MEMBER wasn't dropped before.. I believe this error is the result of a missing mysql permission, but that's only a guess.. Any chance to convert it "offline" on XAMPP?

[Jade Elizabeth]

No, sadly the eblah thing is like 200GB or so and it's all CGI files or something. When I tried to back it up the server only lets 3 files transfer at a time and has a wait period...put it this way...after 2 hours we werent even a quarter of the way through.

Is there something I can do? I'm pretty good with phpmyadmin.

[ThorstenE]

ouch, 200 GB??
you could add / drop the related indices manually whenever the converter stops.. but that's far from easy.

[caesarkent]

Thankyou for the new file, it did the job. very happy.

One thing that did happen was that all our existing member numbers were all over the place due to some being deleted over the last few years, this resulted in posters names being incorrect through the entire forum.

It was easy to rectify in the database we manually changed every member to their correct number.

Everything else seems in order including private messages.

I have the exact same problem.  I'm new to MySQL; can you show me the commands you used to manually change the member numbers?

Thanks!

Caesar