Spip and Sqlite

  • Resolved hnzz

    (@hnzz)


    5 years, 8 months ago

    Hi, 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

Viewing 9 replies - 1 through 9 (of 9 total)
  • Plugin Author Kerfred

    (@kerfred)

    This is a good idea.
    I have developed this feature in the latest version: https://www.fredericgilles.net/fg-spip-to-wordpress/

    Thread Starter hnzz

    (@hnzz)

    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 ?

    Plugin Author Kerfred

    (@kerfred)

    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.

    Thread Starter hnzz

    (@hnzz)

    That is indeed very good news. Perfect way to start work on a sunny Saturday !
    Thnx
    hnzz

    Thread Starter hnzz

    (@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

    Plugin Author Kerfred

    (@kerfred)

    Could you open a ticket on https://www.fredericgilles.net/support/ and send me your SQLite database? I’ll do the test.

    Thread Starter hnzz

    (@hnzz)

    Ticket created

    Plugin Author Kerfred

    (@kerfred)

    Update:
    I have imported successfully your SPIP database to WordPress.
    You must check the database location of the SQLite file and the tables prefix.

    Thread Starter hnzz

    (@hnzz)

    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

Viewing 9 replies - 1 through 9 (of 9 total)
  • The topic ‘Spip and Sqlite’ is closed to new replies.