ElkArte Community

General => OpenImporter => Topic started by: hartiberlin on January 16, 2018, 08:57:27 pm

Title: OpenImporter FAQ ? SMF 2.0.15 to Elkarte problems
Post by: hartiberlin on January 16, 2018, 08:57:27 pm
Hi,
is there an Openimporter FAQ ?

I want to convert a SMF 2.0.15 forum to Elkarte inside the same
path of the domain....
As the Importer says, I need to have a working Elkarte installation first,
I would then overwrite a few folders from SMF with the Elkarte folders....

So what is then the best method ?
Should I first move the SMF files and folders to a new subfolder in the same domain
or how can I install Elkarte without affecting the SMF Folders and files, so the OpenImporter
can do its work ?

Many thanks.
Regards, Stefan.
Title: Re: OpenImporter FAQ ?
Post by: hartiberlin on January 16, 2018, 09:48:29 pm
Which Database password must I provide for the Importer ?

The SMF2.9.15 Database password or the Elkarte Database password ?
Title: Re: OpenImporter FAQ ?
Post by: hartiberlin on January 16, 2018, 09:55:41 pm
Hmm, I had moved the SMF installation into a subdirectory called /oldsmf/
but when I gave this directory to the Importer it did not find the old SMF installation....

Only when I gave the root directory for Source and Destination the same. althrough the old SMF files
were located in the subdirectory /oldmsf

Hmm, does the importer find the subdirectory itsself and then can read the attachment files from
/oldsmf/attachments/   ?

Strange it, started the conversion, but failed at :

Code: [Select]
Importing settings... ✔
Importing members...
Unsuccessful!
This query:

    SELECT
    id_member, member_name, date_registered, posts, id_group, lngfile, last_login,
    real_name, unread_messages, unread_messages, new_pm, buddy_list, pm_ignore_list,
    pm_prefs, mod_prefs, message_labels, passwd, email_address, personal_text,
    gender, birthdate, website_url, website_title, location, hide_email, show_online,
    time_format, signature, time_offset, avatar, pm_email_notify,
    usertitle, notify_announcements, notify_regularity, notify_send_body,
    notify_types, member_ip, member_ip2, secret_question, secret_answer, 1 AS id_theme, is_activated,
    validation_code, id_msg_last_visit, additional_groups, smiley_set, id_post_group,
    total_time_logged_in, password_salt, ignore_boards,
    IFNULL(warning, 0) AS warning, passwd_flood,
    pm_receive_from AS receive_from
    FROM `d0291212`.elkarte_members
    LIMIT 0, 500;

Caused the error:

    Unknown column 'personal_text' in 'field list'

Line: 117
File: /www/htdocs/xxxxx/blabla.de/importer/OpenImporter/Database.php

Unsuccessful!
This query:

    SELECT
    id_member, member_name, date_registered, posts, id_group, lngfile, last_login,
    real_name, unread_messages, unread_messages, new_pm, buddy_list, pm_ignore_list,
    pm_prefs, mod_prefs, message_labels, passwd, email_address, personal_text,
    gender, birthdate, website_url, website_title, location, hide_email, show_online,
    time_format, signature, time_offset, avatar, pm_email_notify,
    usertitle, notify_announcements, notify_regularity, notify_send_body,
    notify_types, member_ip, member_ip2, secret_question, secret_answer, 1 AS id_theme, is_activated,
    validation_code, id_msg_last_visit, additional_groups, smiley_set, id_post_group,
    total_time_logged_in, password_salt, ignore_boards,
    IFNULL(warning, 0) AS warning, passwd_flood,
    pm_receive_from AS receive_from
    FROM `d0291212`.elkarte_members
    LIMIT 0, 500;

Caused the error:

    Unknown column 'personal_text' in 'field list'


/www/htdocs/xxxx/blabla.de/importer/OpenImporter/ImportManager.php
571
Title: Re: OpenImporter FAQ ?
Post by: hartiberlin on January 16, 2018, 10:08:52 pm
Hmm, now it has imported all things, but not:
Members
and
Membergroups

Hmm.... how can I fix this ?
Also the trick using the SMF 2.1 Beta importer for these 2 items did not work for me.
I am still using the standard openimporter from:
OpenImporter-openimporter-199d92d.zip
Title: Re: OpenImporter FAQ ?
Post by: hartiberlin on January 16, 2018, 10:27:44 pm
Hmm, now it seems the Importer has deleted my username, so I can not login into Elkarte anymore...
Also it duplicated all attachments into the /oldsmf/attachments/
path and not into just the /attachments/ path....
This folder is still empty....

So I guess I must install Elkarte OVER the root directory and only keep the /attachments/
folder from the old SMF 2.0.15 installation ?
Title: Re: OpenImporter FAQ ?
Post by: hartiberlin on January 16, 2018, 10:57:25 pm
Do I need to use the upgrader.php
or the
install.php
when I try to install Elkarte into the same directory as SMF ??
Title: Re: OpenImporter FAQ ?
Post by: hartiberlin on January 16, 2018, 11:31:07 pm
How does the importer get the informations out of the old SMF database, if it does not ask for the
Database name and password of the old SMF 2.0.x installation ??
Hmm...
Especially when I have overwritten Settings.php from the old SMF installation with the new
Settings.php from Elkarte... hmmm......
Title: Re: OpenImporter FAQ ?
Post by: hartiberlin on January 16, 2018, 11:39:13 pm
Hmm, I installed now Elkarte completely new again and only s had the /attachments/
folder from the old SMF installation and the Database...

Then I uploaded the newer importer from
OpenImporter-openimporter-48f6063.zip

and when I started it, I got the error Message:

Code: [Select]
Warning: require_once(/www/htdocs/xxxx/blabla.de/importer/vendor/autoload.php): failed to open stream: No such file or directory in /www/htdocs/xxxx/blabla.de/importer/import.php on line 28

Fatal error: require_once(): Failed opening required '/www/htdocs/xxxx/blabla.de/importer/vendor/autoload.php' (include_path='.:/usr/share/php:..') in /www/htdocs/xxxx/blabla.de/importer/import.php on line 28
Title: Re: OpenImporter FAQ ?
Post by: hartiberlin on January 16, 2018, 11:52:00 pm
Have been going back to the old normal importer

but it seems it only imports somehow the data from Elkarte itsself and then crashes the user database....

So Do I need first to move my old SMF installation from the root directory to a subfolder and then need to use
the repair_settings.php tool to have a working SMF 2.0.15 inside the subfolder first, so the importer then also finds
the old Settings.php from SMF, so it knows the password to the SMF database ??

Too bad I did not find a FAQ how to do it....
Title: Re: OpenImporter FAQ ? SMF 2.0.15 to Elkarte problems
Post by: hartiberlin on January 17, 2018, 12:07:59 am
Hmm, one last thing I will test tommorow is to move the old SMF installation completely into a subdirectory and
use the repair_settings.php tool from SimpleMachines to set the pathes right, so the old SMF will run correctly from this
subdirectory and then try again with the importer.....
Title: Re: OpenImporter FAQ ? SMF 2.0.15 to Elkarte problems
Post by: hartiberlin on January 17, 2018, 12:40:46 am
Also from the correct working Subdirectory it does not work...
Well I guess I am giving up, if I can´t get any help over here....
Title: Re: OpenImporter FAQ ? SMF 2.0.15 to Elkarte problems
Post by: radu81 on January 17, 2018, 01:40:40 am
Welcome to elkarte!
No offence, but you posted 11 messages in a few hours and it's not easy to provide help in this way. If you solved some of the problems mentioned above, edit or delete those messages.

Have a look at this on how to setup smf, elkarte and openimporter folders:
https://www.elkarte.net/community/index.php?topic=3249.msg30000#msg30000
Title: Re: OpenImporter FAQ ? SMF 2.0.15 to Elkarte problems
Post by: ahrasis on January 17, 2018, 06:09:55 am
Agreed with @radu81. Elkarte is a free software with support provided by its developers and other members of its community for free. Please be patient and do not bump the forum with continous posts unless that is really necessary.
Title: Re: OpenImporter FAQ ? SMF 2.0.15 to Elkarte problems
Post by: Jorin on January 17, 2018, 08:31:13 am
Well I guess I am giving up, if I can´t get any help over here....

I'm in a good mood today, so: if you can't wait more then four hours for someone offering his time to help, bye bye. Better stay with PortaMX.
Title: Re: OpenImporter FAQ ? SMF 2.0.15 to Elkarte problems
Post by: emanuele on January 17, 2018, 11:58:55 am
hmm...
Welcome. :)
I'd suggest you to go for either xenforo or IPS or vBuletin, any of them have paid support that will answer you pretty timely (I'm sure).
Other free software you may or may not have answers in seconds, so you'll always be bound to find a new one every so often.

Goodbye. :)
Title: Re: OpenImporter FAQ ? SMF 2.0.15 to Elkarte problems
Post by: hartiberlin on January 17, 2018, 02:28:32 pm
Welcome to elkarte!
No offence, but you posted 11 messages in a few hours and it's not easy to provide help in this way. If you solved some of the problems mentioned above, edit or delete those messages.

Have a look at this on how to setup smf, elkarte and openimporter folders:
https://www.elkarte.net/community/index.php?topic=3249.msg30000#msg30000

Hi All,
sorry for posting so many messages here... I only wanted to document my trials and errors over the time I had done it....
Should I better next time edit always only 1 message and add the new content to the buttom ?

;Many thanks @radu81 to point me to some help.
I will try these settings now.
Sorry again, I did not expect very fast resonse, I just wanted to document my steps for later review, if I have to convert another forum to Elkarte too...
Many thanks again.
Regards, Stefan.
Title: Re: OpenImporter FAQ ? SMF 2.0.15 to Elkarte problems
Post by: Jorin on January 17, 2018, 03:37:12 pm
Sorry again, I did not expect very fast resonse...

Not? You wrote:

Well I guess I am giving up, if I can´t get any help over here....

...after four hours.  :o

Well, next time give @radu81 a little bit more time.  ;)
Title: Re: OpenImporter FAQ ? SMF 2.0.15 to Elkarte problems
Post by: radu81 on January 17, 2018, 08:14:57 pm
I was a bit in hurry last night and forgot to mention, you need to use elkarte 1.0.10 and not 1.1.1. Once your forum is migrated to 1.0.10 you can update to 1.1.1 version.

So to recap, the steps you need to do are:


Follow the steps mentioned above, and if you have problems let us know.

p.s. I see you are using a portal on your forum, for elkarte you can use Simple Portal, download it from here https://github.com/SimplePortal/SimplePortal_ElkArte/tree/development . Pay attention, there is a small bug[1] with the Login block, so for now do not use the Login block on your portal
more info here https://github.com/SimplePortal/SimplePortal_ElkArte/issues/20
Title: Re: OpenImporter FAQ ? SMF 2.0.15 to Elkarte problems
Post by: emanuele on January 17, 2018, 09:41:59 pm
And that reminds me OI should be updated to support 1.1... meh. Always running behind the schedule... :'(
Title: Re: OpenImporter FAQ ? SMF 2.0.15 to Elkarte problems
Post by: hartiberlin on January 18, 2018, 08:29:42 pm
Many thanks @radu81 and @emanuele for your help. 
I will try it now and report back.

Regards, Stefan.
      
Title: Re: OpenImporter FAQ ? SMF 2.0.15 to Elkarte problems
Post by: hartiberlin on January 18, 2018, 09:18:49 pm
Hmm, what Database password must I supply ?
If I gave the password of the old SMF 2.0.15 database, it says:


The database password you entered was incorrect. Please make sure you are using the right password and try it again. If in doubt, use the password from Settings.php.
error_line 314
error_file /www/htdocs/xxxxxx/blabla.de/importer/OpenImporter/Importer.php


When I gave at the importer the password of the Elkarte database , it says:


Sorry, the database connection information used in the specified installation of your forum cannot access the installation of SMF 2.0. This may either mean that the installation doesn't exist, or that the MySQL account used does not have permissions to access it.

The error MySQL gave was: SELECT command denied to user 'dxxx1212'@'localhost' for table 'smf_members''
error_line 351
error_file /www/htdocs/xxxxxx/blabla.de/importer/OpenImporter/Importer.php


Also must I put a slash / in the pathnames or not ?
It comes up with no Slash at the end when starting the importer script.....

I started with Elkarte being installed in the root directory and  the old SMF 2.0.15
was running in a subdirectory  okay, like /oldsmf/   ( I had used the repair_settings.php)
to move it there and get it running okay there....
I did it this way, so I don´t have to move Elkarte from a subdirectory to the root again...
Might this be the error ?
Does it only work, if Elkarte is installed in a subdirectory first ??
Also the Databases were not limited to only localhost access, so
I don´t understand, why the importer script can not access the old database....

if you update the importer, Please also add in the startscreen of the importer the name "Old" or "previous" database
so it gets right to give in the password of the old SMF 2.0.x database...so it is not confusing...
Many thanks.
Regards, Stefan.

I

Title: Re: OpenImporter FAQ ? SMF 2.0.15 to Elkarte problems
Post by: hartiberlin on January 18, 2018, 10:15:47 pm
Hmm, I did now install it all exactly in the pathes it should be:
old SMF in the root directory
Elkarte in the /elkarte/ directory
and the Importer in the /openimporter/ path

How it says:

The database password you entered was incorrect. Please make sure you are using the right password and try it again. If in doubt, use the password from Settings.php.
error_line 314
error_file /www/htdocs/xxxxxx/blabla.de/openimporter/importer/OpenImporter/Importer.php

But I checked several times the password from the old SMF and also compared it to the Settings.php file...all correct...
Hmm, why does the importer script not ask for the name of the SMF database ?
Does it try to get it from the Settings.php or where does it get from ??

Regards, Stefan.

Title: Re: OpenImporter FAQ ? SMF 2.0.15 to Elkarte problems
Post by: Feline on January 18, 2018, 10:16:30 pm
Better stay with PortaMX.
Same questions on our forum  :D  .. but we offer no importer or upgrade at the current time.
This comes later  ;)

Fel
Title: Re: OpenImporter FAQ ? SMF 2.0.15 to Elkarte problems
Post by: radu81 on January 18, 2018, 11:00:41 pm
Did you used the same database for SMF and elkarte, or did you used different databases? If the second option you need to be sure that your database user has permission to that database
Title: Re: OpenImporter FAQ ? SMF 2.0.15 to Elkarte problems
Post by: emanuele on January 19, 2018, 12:20:12 am
Hmm, what Database password must I supply ?
hmm... in theory it should not ask for any password, it should pick...hmm... maybe not, because even the original converter I'm not really sure how could have worked with two databases provided it was doing strange joins in certain conversions.

The best scenario is: set up the two databases with the same user, then "fake" a Settings.php in the "SMF" folder with the configuration data (i.e. pick the same Settings.php of elkarte and move it there.), then run the importer and it should work. Should.
Title: Re: OpenImporter FAQ ? SMF 2.0.15 to Elkarte problems
Post by: hartiberlin on January 19, 2018, 08:01:22 am
Hmm, I used 2 databases, as the SMF Database was already there and I created a new database for the Elkarte installation....

Do you mean, I should use the same database SMF is running on during installation of Elkarte then ?
Will the elkarte 1.10 installer just add their tables to the SMF databse then and don´t delete the old tables ??
Can I afterwords delete all tables starting with "smf_ " ??

Many thanks.
Title: Re: OpenImporter FAQ ? SMF 2.0.15 to Elkarte problems
Post by: Jorin on January 19, 2018, 08:07:59 am
To make it short: Yes.  ;)
Title: Re: OpenImporter FAQ ? SMF 2.0.15 to Elkarte problems
Post by: hartiberlin on January 19, 2018, 08:08:49 am
Hmm, what Database password must I supply ?


The best scenario is: set up the two databases with the same user, then "fake" a Settings.php in the "SMF" folder with the configuration data (i.e. pick the same Settings.php of elkarte and move it there.), then run the importer and it should work. Should.

Hmm, on my hoster all-inkl.com I can not setup 2 databases with the same username as the database username is always the databasename itsself...
How can I patch the Importer.php to use the right 2 databases ? in which variables are these values stored ?
It seems the PHP script just can not start the conversion as it does not find the right databases...
Title: Re: OpenImporter FAQ ? SMF 2.0.15 to Elkarte problems
Post by: hartiberlin on January 19, 2018, 08:10:53 am
To make it short: Yes.  ;)
Okay, many thanks, then I will try now this method now...
First need to backup my SMF database, if something goes wrong with the Elkarte installation in it then....
Title: Re: OpenImporter FAQ ? SMF 2.0.15 to Elkarte problems
Post by: hartiberlin on January 19, 2018, 08:33:27 am
Wow, it worked on the first try ! ;) I am very happy now... Many many thanks for the help...
So just using just ONE database is the way to go..... O:-)  O:-)  O:-)
Title: Re: OpenImporter FAQ ? SMF 2.0.15 to Elkarte problems
Post by: emanuele on January 19, 2018, 01:07:21 pm
In theory it should work even with two, but apparently my suspects were right and the current "stable" version is not really able to cope with that and needs to have just one database then.
The development should, but then again it's development and is broken since a while because of some intervention of the Bug Creator. O:-)
Title: Re: OpenImporter FAQ ? SMF 2.0.15 to Elkarte problems
Post by: radu81 on January 19, 2018, 01:14:36 pm
IIRC the importer asks for SMF database password, I don't have an importer installed to check... I also did the import using the same database.
Glad you solved it  ;)
Title: Re: OpenImporter FAQ ? SMF 2.0.15 to Elkarte problems
Post by: emanuele on January 19, 2018, 08:51:37 pm
@radu81 yep, OI asks for the password like the old converter asked, but I always had the feeling (never actually bothered to check) that this request is used only if the password of the settings is not working, but it doesn't allow you to use two databases with two different users/password, because the php db connection is always one in SMF (and current Elk), it cannot be instantiated multiple times and since the converter follows more or less the original design, it has the same limitations.
Additionally (for the original converter and OI 1.x) certain conversions require the JOIN of tables from both databases (the one to import from and the one to import to), and this doesn't work if the databases do not have the same credentials.
So, basically, you mush have the same user/password pair for both databases, and anyway if you can have only one database is much better (and sure to work).
Title: Re: OpenImporter FAQ ? SMF 2.0.15 to Elkarte problems
Post by: radu81 on January 19, 2018, 09:22:52 pm
That explains why I was not able to migrate using different databases, thanks for pointing out  ;)
Title: Re: OpenImporter FAQ ? SMF 2.0.15 to Elkarte problems
Post by: Mrs. Chaos on April 17, 2018, 11:30:24 am
And that reminds me OI should be updated to support 1.1... meh. Always running behind the schedule... :'(

Is the OI update already done? ;)
I want to migrate a SMF 2.0.15 to ElkArte 1.1.3.
Title: Re: OpenImporter FAQ ? SMF 2.0.15 to Elkarte problems
Post by: radu81 on April 17, 2018, 11:54:46 am
I want to migrate a SMF 2.0.15 to ElkArte 1.1.3.
You can go trough elkarte 1.0 and then update to elkarte 1.1.3. It should work, otherwise report the problems.
Maybe this post can be useful https://www.elkarte.net/community/index.php?topic=4868.msg35438#msg35438
Title: Re: OpenImporter FAQ ? SMF 2.0.15 to Elkarte problems
Post by: Mrs. Chaos on April 17, 2018, 12:13:23 pm
The 1.0  I'll find here?:
https://www.elkarte.net/community/index.php?topic=1958.0

There's a download link in the first post.
Title: Re: OpenImporter FAQ ? SMF 2.0.15 to Elkarte problems
Post by: radu81 on April 17, 2018, 03:41:53 pm
The 1.0  I'll find here?:
I wasn't very clear, but I was referring to 1.0.x series, so you should use the latest version which is 1.0.10. You can use all the links indicated here, they are still valid:
https://www.elkarte.net/community/index.php?topic=4868.msg35438#msg35438
Title: Re: OpenImporter FAQ ? SMF 2.0.15 to Elkarte problems
Post by: Mrs. Chaos on April 18, 2018, 02:52:13 pm
I've installed the 1.0.10 and tried to upgrade to the 1.1 , but there's an error now.
I replaced all files and then I ran the install/upgrade.php.

As you can see on the image, two errors are displayed. The line at the top and the "Error retrieving information on step: Remove any old file left and check if the table is empty..." at the bottom.
If I click "continue", step 4 (Database Changes) starts again from the beginning with 1 of 13.

What's wrong there? What should I change in line 546? The permissions for the CommonCode.php and all other files in the install folder I set to 777.
(/www/htdocs/w00xxx/forumxxx/install/CommonCode.php on line 546)
Title: Re: OpenImporter FAQ ? SMF 2.0.15 to Elkarte problems
Post by: Mrs. Chaos on April 18, 2018, 04:29:02 pm
The second row is line 546 of the CommonCode.php.

Code: [Select]
// Clear out the db_last_error file
file_put_contents(TMP_BOARDDIR . '/db_last_error.txt', '0');


EDIT:
I tried it again. Maybe it worked now, but now I have this message:
Maintenance Mode
Okay faithful users ... we're trying to restore an old backup of the database.


I didn't put the forum in maintenance mode during the upgrade. How can I get out of this mode? I've already tried cleaning the browser cache.
.
Title: Re: OpenImporter FAQ ? SMF 2.0.15 to Elkarte problems
Post by: Mrs. Chaos on April 18, 2018, 10:41:55 pm

Does anyone have a suggestion, what I should try now?
Title: Re: OpenImporter FAQ ? SMF 2.0.15 to Elkarte problems
Post by: tino on April 18, 2018, 10:50:39 pm
There is a setting in your settings.php called maintenance mode, change that to 0 I think it is and it will take it out of that mode.
Title: Re: OpenImporter FAQ ? SMF 2.0.15 to Elkarte problems
Post by: Mrs. Chaos on April 18, 2018, 11:10:19 pm
The maintenance mode is already set there on 0 ...

$maintenance = 0;
Title: Re: OpenImporter FAQ ? SMF 2.0.15 to Elkarte problems
Post by: Mrs. Chaos on April 19, 2018, 03:25:33 pm
I started again from the beginning and the import into 1.0.10 worked. :)

I'm at step 5 now.
Now I can update to 1.1.1, not to the 1.1 Final before?
And it's always the install.zip for the next versions and not the patch.zip?
Title: Re: OpenImporter FAQ ? SMF 2.0.15 to Elkarte problems
Post by: Mrs. Chaos on April 19, 2018, 07:37:16 pm
Okay, I upgraded now to 1.1.1,
For the next versions, 1.1.2 and 1.1.13, do I need also the install.zips or from now on just the patch,zips ?
Title: Re: OpenImporter FAQ ? SMF 2.0.15 to Elkarte problems
Post by: radu81 on April 19, 2018, 09:05:37 pm
Once you're on 1.1.1 you can update to 1.1.2 and then to 1.1.3. You can find the patches in the Anouncements board or here:
https://www.elkarte.net/community/index.php?topic=5090.0
https://www.elkarte.net/community/index.php?topic=5116.0

You could also update from 1.0.10 directly to 1.1.3, when I wrote that post the latest version was 1.1.1.
Title: Re: OpenImporter FAQ ? SMF 2.0.15 to Elkarte problems
Post by: Mrs. Chaos on April 19, 2018, 09:53:45 pm
I arrived at 1.1.3 now!  :)
Thank you for your help!! Mille grazie!!
Title: Re: OpenImporter FAQ ? SMF 2.0.15 to Elkarte problems
Post by: hartiberlin on May 13, 2018, 08:13:59 pm
Hi,
I have on my other bigger overunity.com site 3 different attchment directories for the attachments,
because I already have over 60 GB of files there, so the loading from one directory does not take too long, if there are too many
files in one directory....

Does Elkarte also support multiple attachment directories ? will this convert correctly then with Openimporter ? Have not tried it yet...
Title: Re: OpenImporter FAQ ? SMF 2.0.15 to Elkarte problems
Post by: badmonkey on May 13, 2018, 08:59:29 pm
Yes and yes, but if memory serves a little work was necessary.  I successfully converted a forum that had in the range of 150,000 attachments.  ;)
Title: Re: OpenImporter FAQ ? SMF 2.0.15 to Elkarte problems
Post by: bea on May 23, 2018, 12:48:11 am
Do i really need to downgrade to 1.0.x of I want to import an SMF 1.1.16 to a fesh Elk 1.13 install?
Title: Re: OpenImporter FAQ ? SMF 2.0.15 to Elkarte problems
Post by: emanuele on May 23, 2018, 08:27:30 am
Unfortunately, I didn't have time to look after OI and be sure it works for 1.1.
Going by memory I don't remember any big change that would break the conversion, but my memory is not that reliable.
As soon as 1.1.4 is out I'll take a look at OI as well.
Anyway, if you can just try the import that would work as well: if it breaks, then it's not possible. :(
Title: Re: OpenImporter FAQ ? SMF 2.0.15 to Elkarte problems
Post by: bea on May 23, 2018, 03:07:54 pm
Unfortunately, I didn't have time to look after OI and be sure it works for 1.1.

I know...

... it failed on 1.1.13.
But meanwhile i almost succeeded going back to 1.0.10 and then upgrading.
I "just" need to delete the old smf tables from the database.
Is there an easy SQL for this? My old experience with Fortran IV and C is not very helpful in this respect ;-)
Title: Re: OpenImporter FAQ ? SMF 2.0.15 to Elkarte problems
Post by: bea on May 23, 2018, 07:32:37 pm
Please let me answer myself: success again - apparently; the database is not the smallest as the site has been established 12 years ago. I searched the web, and the following approach worked for me. In this case the databse is named tgf_db and the table prefix is tgf_

Maybe an optional cleanup step in openimporter?

Code: [Select]
use [b]tgf_db[/b];

SET GROUP_CONCAT_MAX_LEN=10000;

SET @del = (
    SELECT      CONCAT('DROP TABLE ', GROUP_CONCAT(TABLE_NAME), ';')
    FROM        information_schema.TABLES

    WHERE       TABLE_SCHEMA = 'tgf_db'
    AND         TABLE_NAME LIKE 'tgf_%'
);

PREPARE stmt FROM @del;
EXECUTE stmt;
DEALLOCATE PREPARE stmt;
Title: Re: OpenImporter FAQ ? SMF 2.0.15 to Elkarte problems
Post by: emanuele on May 25, 2018, 08:08:50 am
Arg... I started writing an answer, but I didn't push post... :-[ xD

Oh well, it was anyway a link to stackoverflow, so nothing more than what you found.

Maybe an optional cleanup step in openimporter?
Dunno.
My idea (that may not be the original one, because I started working on it later) about openimporter was to have non-destructive importer, with the idea that you can do and re-do the import and try it out, etc. any time you want and the original data are not touched at all. Unfortunately right now there may be (still) some limitations, but in theory you can have the two sets of tables in two different databases with two different users and passwords.

Providing it with a nuclear weapon... I don't know.
Title: Re: OpenImporter FAQ ? SMF 2.0.15 to Elkarte problems
Post by: bea on May 25, 2018, 12:43:51 pm
using a 2nd database would indeed be the best way to do it.
Title: Re: OpenImporter FAQ ? SMF 2.0.15 to Elkarte problems
Post by: radu81 on May 25, 2018, 02:42:35 pm
I've tried several times to do it with 2 databases, but didn't work for me, so I end up using the same database with different prefixes tables.
Title: Re: OpenImporter FAQ ? SMF 2.0.15 to Elkarte problems
Post by: emanuele on May 25, 2018, 03:30:48 pm
That's why I said "in theory". :P
Title: Re: OpenImporter FAQ ? SMF 2.0.15 to Elkarte problems
Post by: Vekseid on August 31, 2019, 04:44:50 am
And that reminds me OI should be updated to support 1.1... meh. Always running behind the schedule... :'(

I'm currently handling this. At least for SMF 2.0.

Done : ) https://github.com/OpenImporter/openimporter/pull/106
Title: Re: OpenImporter FAQ ? SMF 2.0.15 to Elkarte problems
Post by: Spuds on September 01, 2019, 01:30:31 am
Awesome !!