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?
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.
Thanks :D.
Will this do attachments too?
It should, yes. Not tested lately, though, I'm afraid.
Thanks Norv. I'm going to run it today!
QuoteConverting 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 :D.
It's also not converting right!!
How could you lie to me Norv? :'( :'( :'( :'( :'( :'(
Please try:
convert_query("
ALTER TABLE {$to_prefix}personal_messages
CHANGE COLUMN ID_PM ID_PM int(10) unsigned NOT NULL auto_increment PRIMARY KEY");
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.
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.
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?
QuoteConverting 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.
:D
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...
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;
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. :(
Lies! I loves you :D
I got another error too:
QuoteConverting 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:
QuoteCaused the error:
Column count doesn't match value count at row 173
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 ;)
I could do with this too.... Pleeeeaaassseeee HELP :-*
Working on it. I will post an updated converter ASAP!
Quote from: Norv on November 04, 2010, 01:46:41 PM
Working on it. I will post an updated converter ASAP!
You would instantly become a deity ;D
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
Gentle bump :).
I hope you arent being made to do this alone Norv. You do enough already without needing to do this too!!
Quote from: impished on November 05, 2010, 11:08:51 AM
Quote from: Norv on November 04, 2010, 01:46:41 PM
Working on it. I will post an updated converter ASAP!
You would instantly become a deity ;D
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
have there been any developments with this ? ;)
Quote from: MaxwellsHouse on November 21, 2010, 12:22:59 PM
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 :D
It's been 2 months so you're fine to bump ;).
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.
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..
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.
Quote from: TE on January 03, 2011, 11:37:09 AM
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... ;)
Quote from: warpman999 on January 10, 2011, 11:44:15 PM
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.
Do you know if it would be possible to create a second SMF and run a test?
Thanks for the info.
Quote from: TE on January 11, 2011, 11:59:21 AM
Quote from: warpman999 on January 10, 2011, 11:44:15 PM
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.
Quote from: warpman999 on January 12, 2011, 10:27:28 PM
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.
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?
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 :-[
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 got the same error as above, but with the second one I get this:
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'
Quote from: TE on January 16, 2011, 02:09:07 AM
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 :-[
I did do that. All the first one did was emptied out of the database.
Quote from: Jade Elizabeth on January 25, 2011, 01:35:41 AM
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.
Me 10
I deleted the DB, reinstalled, and I get this:
QuoteConverting members... Unsuccessful!
This query:
ALTER TABLE `smfforum`.smf_members
CHANGE COLUMN ID_MEMBER ID_MEMBER mediumint(8) 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.
Quote from: Jade Elizabeth on January 30, 2011, 06:26:16 AM
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 (http://www.apachefriends.org/en/index.html)?
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.
ouch, 200 GB??
you could add / drop the related indices manually whenever the converter stops.. but that's far from easy.
Quote from: confused1 on January 16, 2011, 07:16:23 PM
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
Quote from: TE on February 01, 2011, 10:39:59 AM
ouch, 200 GB??
you could add / drop the related indices manually whenever the converter stops.. but that's far from easy.
What causes them? Maybe there's some way I can work around it or avoid it or something?
I don't understand this at all, I'm no good with converters - only running them lol.
Quote from: Jade Elizabeth on February 03, 2011, 02:15:12 AM
What causes them?
I'd love to know that but unfortunately I have no clue, I'll check the converter again next week, hopefully I'll find these damn bugs. Cross your fingers ;)
If someone is willing to send me his eblah files please reply to this topic, my minimal eblah test-installation is good for nothing.
Any luck? :D
Quote from: Jade Elizabeth on February 14, 2011, 04:11:55 AM
Any luck? :D
[offtopic]Sorry Jade, but I have stopped my work on converters for now. I'm still waiting for a proper responce from a team member (especially the Doc Coordinator) regarding such a drastic change in the help section:
http://dev.simplemachines.org/mantis/view.php?id=2924#c13640
/me hates to be ignored..
[/offtopic]
I understand how you feel...but I can't read that. I don't like what's happening to the manual and I tried to fix it but I can almost guarantee the new doc co-ordinator hasnt looked at any work I've done. Probably fobbed it off as old hat to do new stuff, which would mean he's missed the organization I did too.
Doesnt matter :).
Is anyone still working on this converter? I have a decent size forum that I'd like to convert but I'm getting many of the same errors that are described in this thread.
Thanks!
Hello there.
I also have great interest in whether this converter works / was completed. I have several eBlah forums, all quite small with less than 50 members. I'm very keen to migrate away from eBlah, and since Simple Machines developers appear to have made the most headway in building a converter, embracing Simple Machines would seem the best approach.
Can anyone confirm whether the converter was ever completed for eBlah 10.3.6?
Quote from: Codenix on May 05, 2011, 01:51:09 AM
Can anyone confirm whether the converter was ever completed for eBlah 10.3.6?
Can't speak for the team but it looks (http://www.simplemachines.org/community/index.php?topic=431964.msg3036316#msg3036316) like nobody has taken my place regarding converters, thus I don't expect the converter to be finished anytime soon :'(
Anyone managed to figure this one out yet ? I'm still wanting to convert my eBlah forum :-\
I've got several people begging me to do something and I just do not have the skills :(.
Converter scripts need some loving.