Simple Machines Community Forum

SMF Support => Converting to SMF => Topic started by: AndypVW on December 28, 2020, 10:29:12 AM

Title: E107 covert SMF . I only have the DB from E107 site
Post by: AndypVW on December 28, 2020, 10:29:12 AM
Not much success searching ...

I have an E107 database (no access to the actual site) that I have co loaded on the SMF server.
Is there a quick edit to covert.php that would get me underway , or at least get the bulk of the conversion done?

Many Thanks

Andy
Title: Re: E107 covert SMF . I only have the DB from E107 site
Post by: shadav on December 28, 2020, 10:46:49 AM
*not to sound silly but have you tried the converter? https://download.simplemachines.org/index.php?converters;id=32

and if so, how is it not working, any errors?

I don't think you need actual access to the old files, as long as you have the db
Title: Re: E107 covert SMF . I only have the DB from E107 site
Post by: AndypVW on December 29, 2020, 03:44:41 AM
This is basis of my question , since the converter ( essentially two files , a convert.php and a .sql file) asks for the E107site path (e.g. localhost:/E107). I assume it then deduces the DB connection (since I can't get past the E107 site path question I can't be certain that is the case).
Again my assumption is that the bulk of the work is done by the .sql file invoked from convert.php.

That will be my next step , to review the .sql file and determine if that will do the bulk of my conversion and use the SQL within.

Just hoping that someone had been down this road before.

Thanks
Title: Re: E107 covert SMF . I only have the DB from E107 site
Post by: GL700Wing on December 29, 2020, 05:34:26 AM
This is basis of my question , since the converter ( essentially two files , a convert.php and a .sql file) asks for the E107site path (e.g. localhost:/E107). I assume it then deduces the DB connection (since I can't get past the E107 site path question I can't be certain that is the case).
I've just done a forum conversion as follows (it wasn't E107 but the process is essentially the same):

Title: Re: E107 covert SMF . I only have the DB from E107 site
Post by: AndypVW on January 09, 2021, 10:11:24 AM
Thought I'd complete what worked for me , in case others walk this path.

The main challenge initially was that all I had was the database from the an old version of the E107 forum.
Thanks to GL700wing for getting me off the mark, I've added to that sequence:-

Create a new SMF 2.0.17 database and forum.
Import a backup of the E107 data to the new MySQL database (same server)
Install E107 to see an example of config.php so created ( and invoked via the SMF convert.php 'path_from' )
Edit config.php file and configure the required variables (for E107 the details details on lines 7-9 in the e107_to_smf.sql file). 
Turn off strict mode on the mySQL server
Run the convert.php script from the SMF 2.0.17 forum folder/directory.  turn on the debug option (?debug=1)
Covert.php invokes e107_to_smf.sql to fetch the data.
My database was missing a number of tables/columns that e107_to_smf.sql was looking for , presumably features added in a later release of E107. Editing e107_to_smf.sql as each error as thrown was the quickest way to proceed.

Job Done
Title: Re: E107 covert SMF . I only have the DB from E107 site
Post by: Aleksi "Lex" Kilpinen on January 10, 2021, 04:36:59 AM
Sounds good, marking this solved then. :)
And thanks for sharing your solution!