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.
Which Database password must I provide for the Importer ?
The SMF2.9.15 Database password or the Elkarte Database password ?
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 :
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
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
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 ?
Do I need to use the upgrader.php
or the
install.php
when I try to install Elkarte into the same directory as SMF ??
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......
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:
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
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....
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.....
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....
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
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.
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.
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. :)
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.
Not? You wrote:
...after four hours. :o
Well, next time give
@radu81 a little bit more time. ;)
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:
- do a full backup of your SMF forum, files and database. The importer should not overwrite your files or your database but it's always better to have a backup.
- download a copy of elkarte from https://github.com/elkarte/Elkarte/releases/download/v1.0.10/ElkArte_v1-0-10_install.zip and install it in a new folder of your webiste (let's say yourdomain.com/elkarte).
You can use a new database, or you can install it into the same database of SMF, but use a different prefix than your SMF installation. You need to install elkarte in the same database of your SMF forum, but be careful to use different prefixes for tables. - once you have elkarte 1.0.x forum installed download the importer from https://github.com/OpenImporter/openimporter and unzip the content to a folder, let's say yourdomain.com/openimporter
- point your web browser to yourdomain.com/openimporter and fill the requested information, than start the importer
- once you have migrated to 1.0.10 you can update to elkarte 1.1.1. Download the files from https://github.com/elkarte/Elkarte/releases (ElkArte_v1-1-1_install.zip ) unzip and upload to yourdomain.com/elkarte . Overwrite the existing files.
- Point your browser to yourdomain.com/elkarte and you will be redirected to the upgrade procedure.
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 with the Login block, so for now do not use the Login block on your portal
And that reminds me OI should be updated to support 1.1... meh. Always running behind the schedule... :'(
Many thanks
@radu81 and
@emanuele for your help.
I will try it now and report back.
Regards, Stefan.
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
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.
Same questions on our forum :D .. but we offer no importer or upgrade at the current time.
This comes later ;)
Fel
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
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.
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.
To make it short: Yes. ;)
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...
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....
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:-)
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:-)
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 ;)
@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).
That explains why I was not able to migrate using different databases, thanks for pointing out ;)
Is the OI update already done? ;)
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
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.
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
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)
The second row is line 546 of the CommonCode.php.
// 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.
.
Does anyone have a suggestion, what I should try now?
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.
The maintenance mode is already set there on 0 ...
$maintenance = 0;
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?
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 ?
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.
I arrived at 1.1.3 now! :)
Thank you for your help!! Mille grazie!!
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...
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. ;)
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?
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. :(
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 ;-)
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?
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;
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.
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.
using a 2nd database would indeed be the best way to do it.
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.
That's why I said "in theory". :P
I'm currently handling this. At least for SMF 2.0.
Done : ) https://github.com/OpenImporter/openimporter/pull/106
Awesome !!