Conversation
supportHi, i like to port my spip site to WordPress but before buying your product (as i want to move the keywords too) i like to know whether this will work with a spip site with a sqlite database. If not could someone me point to a resource which explains how to move spip from sqlite to mysql first. Yes searched the internet but was not able to find anything on this hnzz
This is a good idea. I have developed this feature in the latest version: https://www.fredericgilles.net/fg-spip-to-wordpress/
My bad, was not aware of this possibility. So it just should work ? I am gonna retry the proces today. I have tried it once some time ago but no avail… Should the new version of the site reside on the same sever ?
You just have to update the plugin to the latest version (2.36.0) and choose the “SQLite” database driver in the settings. Should the new version of the site reside on the same sever ? Yes, it is preferable. If it is not located on the same server, you must first copy the SPIP database to the WordPress server.
That is indeed very good news. Perfect way to start work on a sunny Saturday ! Thnx hnzz
Ok copied the database (spip.sqlite) to the test server and changed ownership to www-data. After that I have chosen for de Sqlite driver in the plugin Filled in the path to the db file (/tmp/spip.sqlite) And then I get the following error: Connection failed See the errors in the log below And the errors are: === START test_database 2019-03-24 14:29:55 === [ERROR] Couldn’t read the SPIP database SQLite file: /tmp/spip.sqlite === END test_database 2019-03-24 14:29:55 === Obviusly I do something wrong NB: the user www-data owns the file permissions of the file are set to 777 I also tried the import with a backup from the spip site also not working Any help much appreciated ! hnzz
Could you open a ticket on https://www.fredericgilles.net/support/ and send me your SQLite database? I’ll do the test.
Ticket created
Update: I have imported successfully your SPIP database to WordPress. You must check the database location of the SQLite file and the tables prefix.
Ok found it, it was the location of the file, moved it to the root of the site and now it works ! Thanks for the support sofar Hnzz
This is a good idea. I have developed this feature in the latest version: https://www.fredericgilles.net/fg-spip-to-wordpress/
My bad, was not aware of this possibility. So it just should work ? I am gonna retry the proces today. I have tried it once some time ago but no avail… Should the new version of the site reside on the same sever ?
You just have to update the plugin to the latest version (2.36.0) and choose the “SQLite” database driver in the settings. Should the new version of the site reside on the same sever ? Yes, it is preferable. If it is not located on the same server, you must first copy the SPIP database to the WordPress server.
That is indeed very good news. Perfect way to start work on a sunny Saturday ! Thnx hnzz
Ok copied the database (spip.sqlite) to the test server and changed ownership to www-data. After that I have chosen for de Sqlite driver in the plugin Filled in the path to the db file (/tmp/spip.sqlite) And then I get the following error: Connection failed See the errors in the log below And the errors are: === START test_database 2019-03-24 14:29:55 === [ERROR] Couldn’t read the SPIP database SQLite file: /tmp/spip.sqlite === END test_database 2019-03-24 14:29:55 === Obviusly I do something wrong NB: the user www-data owns the file permissions of the file are set to 777 I also tried the import with a backup from the spip site also not working Any help much appreciated ! hnzz
Could you open a ticket on https://www.fredericgilles.net/support/ and send me your SQLite database? I’ll do the test.
Ticket created
Update: I have imported successfully your SPIP database to WordPress. You must check the database location of the SQLite file and the tables prefix.
Ok found it, it was the location of the file, moved it to the root of the site and now it works ! Thanks for the support sofar Hnzz