Web Hosting
  1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

WordPress fix Reply To: Importing a Drupal SQLite DB?

Discussion in 'Misc WordPress Requests' started by tgp1994, Oct 30, 2017.

  1. tgp1994


    Reply To: Importing a Drupal SQLite DB?, by tgp1994

    Thank you! I’m actually familiar with that plugin, that’s one of the first things I tried (should have mentioned that, sorry). It doesn’t seem to support importing from Drupal if drupal is configured to use a sqlite database. I felt the need to move my drupal installation over to mysql, but that introduces its own set of problems.

    Regarding the syntax errors, here’s an example. One line that stops the import is;

    INSERT INTO "variable" VALUES('theme_default','s:9:"newsflash";');

    And the error is;

    #1064 – You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ‘”variable” VALUES(‘theme_default’,’s:9:”newsflash”;’)’ at line 1

    Thinking it may have been the semicolon within the string, I tried escaping it with \; which didn’t work. Guessing it may have been the nested double quotes, I tried changing them over to single quotes, and that didn’t work either.

    I’m starting to have flashbacks to programming with MySQL…

    Reply To: Importing a Drupal SQLite DB?

Share This Page

Web Hosting