Converting eBlah to SMF

[Jade Elizabeth]

I'm trying to help out a friend and convert his forum from [the latest version of] eBlah...but the person who tried before royally screwed it up. I'm worried that will happen to me too.

The screw ups consist of no topics or posts, all the members are called "last active=|##########|" and a bunch of other things that's just wrong information in the database.

I'm not familiar with pearl at all, I was hoping I could run the converter and all would be sunshine and lollypops and rainbows and all that stuff but it seems the last guy did that and it looks like there was a nuclear war with bodies piled up. I've checked that this  guys server is good and it's above the requirements....so I guess I'm just wondering if there's something he did wrong or something I need to look out for?

[Norv]

Sorry for the delay.
As discussed elsewhere, the converter on the downloads page only works with eblah 9.

Please, feel free to try the attached converter instead, if you're converting to SMF 1.1.x. If not, I will post the adapted one.

[Jade Elizabeth]

Thanks .

Will this do attachments too?

[Norv]

It should, yes. Not tested lately, though, I'm afraid.

[Jade Elizabeth]

Thanks Norv. I'm going to run it today!

[Jade Elizabeth]

Converting personal messages... Unsuccessful!
This query:
ALTER TABLE `web170-smfforum`.smf_personal_messages
CHANGE COLUMN ID_PM ID_PM int(10) unsigned NOT NULL auto_increment PRIMARY KEY;
Caused the error:
Multiple primary key defined

Help please .

[Jade Elizabeth]

It's also not converting right!!

How could you lie to me Norv?

[Norv]

Please try:

Code (find) Select Expand


         convert_query("
            ALTER TABLE {$to_prefix}personal_messages
            CHANGE COLUMN ID_PM ID_PM int(10) unsigned NOT NULL auto_increment PRIMARY KEY");


Code (replace) Select Expand


         convert_query("
            ALTER TABLE {$to_prefix}personal_messages
            CHANGE COLUMN ID_PM ID_PM int(10) unsigned NOT NULL auto_increment PRIMARY KEY", true);


You might have more of these cases... for all I can see the algorithm is not very robust, it could fail in various cases which shouldn't really lead to failure. I had them too, and I had a practically empty installation to test with. (so much less surprises than a real-world database could actually have)
The "true" added as second parameter to convert_query() will stop the grumbling and let it try to continue - it really doesn't hurt in this case.


Cross-posted ... How it's not converting right?...
Ah. Could you please see the change still, I'll try to look into that.

[Jade Elizabeth]

Okay, thanks .


Dunno if it matters but we're converting from 10.3.5, not 10.3.6 but I don't think there would be any real changes to structure. I can't find a changelog but I dunno if that would even help me.

[Jade Elizabeth]

Norv, I appologise. Turns out I used convert.php instead of eblah_etc.php so that's why it converted wrong...I'm sorry about that .

Seems to do it right now!! Just got another error. Did I mention I love you?

Converting membergroups... Successful.
Converting members... Successful.
Converting settings... Successful.
Unsuccessful!
This query:
ALTER TABLE `web170-smfforum`.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:
Can't DROP 'PRIMARY'; check that column/key exists

With the "true" part in there it errors too.

[Norv]

 
Actually it should have worked, as run from convert.php... All converters should be written to work that way, it's the documented way too...
Ahwell, noted, thank you.

Let's fool it one more time please...

Code Select Expand


            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;


Code (replace) Select Expand


            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", true);
         convert_query("
            DROP PRIMARY KEY", true);
         convert_query("
            ADD temp_toName tinytext", true);



Though, you not loves me, me knows.

[Jade Elizabeth]

Lies! I loves you

I got another error too:

Converting personal messages... Unsuccessful!
This query:
INSERT INTO `web170-smfforum`.smf_personal_messages
(fromName)
VALUES (''),
(''),
(''),

It does that for like 50 lines, then it has actual PMs...like 5 years from the top it has this:

Caused the error:
Column count doesn't match value count at row 173

[MaxwellsHouse]

Did you guys get any further with this ?

I'm having the exact same issues   

Thanks for the input so far, it's been a great help 

[impished]

I could do with this too....  Pleeeeaaassseeee  HELP

[Norv]

Working on it. I will post an updated converter ASAP!

[impished]

Working on it. I will post an updated converter ASAP!

You would instantly become a deity

There are lots of Eblah users that are feeling a bit nervous since the developers posted that they wouldn't be supporting it anymore.

Looking forward to being a SMF'er

[Jade Elizabeth]

Gentle bump .

I hope you arent being made to do this alone Norv. You do enough already without needing to do this too!!

[austin_1100]

Working on it. I will post an updated converter ASAP!

You would instantly become a deity

There are lots of Eblah users that are feeling a bit nervous since the developers posted that they wouldn't be supporting it anymore.

Looking forward to being a SMF'er

Here here!! I'm concerned that eBlah is not longer having any further changes made to it, plus have wanted to get away from a flat file forum for some months now...

Cheers,

Michael T

[MaxwellsHouse]

have there been any developments with this ? 

[MaxwellsHouse]

have there been any developments with this ? 

has anyone managed to do a successful eBlah to SMF conversion yet ? (including PM's, attachments etc)

sorry for bumping this up again, I'm trying to be patient but I'm also anxious to convert to SMF