Re: OpenImporter FAQ ? SMF 2.0.15 to Elkarte problems Reply #15 – January 17, 2018, 08:28:32 am Quote from: radu81 – January 16, 2018, 07:40:40 pmWelcome 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#msg30000Hi 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.
Re: OpenImporter FAQ ? SMF 2.0.15 to Elkarte problems Reply #16 – January 17, 2018, 09:37:12 am Quote from: hartiberlin – January 17, 2018, 08:28:32 amSorry again, I did not expect very fast resonse...Not? You wrote:Quote from: hartiberlin – January 16, 2018, 06:40:46 pmWell I guess I am giving up, if I can´t get any help over here.......after four hours. Well, next time give @radu81 a little bit more time.
Re: OpenImporter FAQ ? SMF 2.0.15 to Elkarte problems Reply #17 – January 17, 2018, 02: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: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/openimporterpoint your web browser to yourdomain.com/openimporter and fill the requested information, than start the importeronce 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[1] with the Login block, so for now do not use the Login block on your portal1 more info here https://github.com/SimplePortal/SimplePortal_ElkArte/issues/20↵
Re: OpenImporter FAQ ? SMF 2.0.15 to Elkarte problems Reply #18 – January 17, 2018, 03:41:59 pm And that reminds me OI should be updated to support 1.1... meh. Always running behind the schedule...
Re: OpenImporter FAQ ? SMF 2.0.15 to Elkarte problems Reply #19 – January 18, 2018, 02:29:42 pm Many thanks @radu81 and @emanuele for your help. I will try it now and report back.Regards, Stefan.
Re: OpenImporter FAQ ? SMF 2.0.15 to Elkarte problems Reply #20 – January 18, 2018, 03: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 314error_file /www/htdocs/xxxxxx/blabla.de/importer/OpenImporter/Importer.phpWhen 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 351error_file /www/htdocs/xxxxxx/blabla.de/importer/OpenImporter/Importer.phpAlso 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.15was 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, soI 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" databaseso 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
Re: OpenImporter FAQ ? SMF 2.0.15 to Elkarte problems Reply #21 – January 18, 2018, 04:15:47 pm Hmm, I did now install it all exactly in the pathes it should be:old SMF in the root directoryElkarte in the /elkarte/ directoryand the Importer in the /openimporter/ pathHow 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 314error_file /www/htdocs/xxxxxx/blabla.de/openimporter/importer/OpenImporter/Importer.phpBut 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.
Re: OpenImporter FAQ ? SMF 2.0.15 to Elkarte problems Reply #22 – January 18, 2018, 04:16:30 pm Quote from: Jorin – January 17, 2018, 02:31:13 amBetter stay with PortaMX.Same questions on our forum .. but we offer no importer or upgrade at the current time. This comes later Fel
Re: OpenImporter FAQ ? SMF 2.0.15 to Elkarte problems Reply #23 – January 18, 2018, 05: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
Re: OpenImporter FAQ ? SMF 2.0.15 to Elkarte problems Reply #24 – January 18, 2018, 06:20:12 pm Quote from: hartiberlin – January 18, 2018, 03:18:49 pmHmm, 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.
Re: OpenImporter FAQ ? SMF 2.0.15 to Elkarte problems Reply #25 – January 19, 2018, 02: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.
Re: OpenImporter FAQ ? SMF 2.0.15 to Elkarte problems Reply #26 – January 19, 2018, 02:07:59 am To make it short: Yes.
Re: OpenImporter FAQ ? SMF 2.0.15 to Elkarte problems Reply #27 – January 19, 2018, 02:08:49 am Quote from: emanuele – January 18, 2018, 06:20:12 pmQuote from: hartiberlin – January 18, 2018, 03:18:49 pmHmm, 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...
Re: OpenImporter FAQ ? SMF 2.0.15 to Elkarte problems Reply #28 – January 19, 2018, 02:10:53 am Quote from: Jorin – January 19, 2018, 02:07:59 amTo 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....
Re: OpenImporter FAQ ? SMF 2.0.15 to Elkarte problems Reply #29 – January 19, 2018, 02: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.....