Skip to main content
Topic: OpenImporter FAQ ? SMF 2.0.15 to Elkarte problems (Read 26403 times) previous topic - next topic
0 Members and 1 Guest are viewing this topic.

OpenImporter FAQ ? SMF 2.0.15 to Elkarte problems

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.

Re: OpenImporter FAQ ?

Reply #1

Which Database password must I provide for the Importer ?

The SMF2.9.15 Database password or the Elkarte Database password ?

Re: OpenImporter FAQ ?

Reply #2

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 [icode]d0291212[/icode].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 [icode]d0291212[/icode].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

Re: OpenImporter FAQ ?

Reply #3

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

Re: OpenImporter FAQ ?

Reply #4

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 ?

Re: OpenImporter FAQ ?

Reply #5

Do I need to use the upgrader.php
or the
install.php
when I try to install Elkarte into the same directory as SMF ??

Re: OpenImporter FAQ ?

Reply #6

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......

Re: OpenImporter FAQ ?

Reply #7

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

Re: OpenImporter FAQ ?

Reply #8

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....

Re: OpenImporter FAQ ? SMF 2.0.15 to Elkarte problems

Reply #9

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.....

Re: OpenImporter FAQ ? SMF 2.0.15 to Elkarte problems

Reply #10

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....

Re: OpenImporter FAQ ? SMF 2.0.15 to Elkarte problems

Reply #11

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
sorry for my bad english

Re: OpenImporter FAQ ? SMF 2.0.15 to Elkarte problems

Reply #12

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.

Re: OpenImporter FAQ ? SMF 2.0.15 to Elkarte problems

Reply #13

Quote from: hartiberlin – 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.

Re: OpenImporter FAQ ? SMF 2.0.15 to Elkarte problems

Reply #14

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. :)
Bugs creator.
Features destroyer.
Template killer.