Support » Plugin: LiteSpeed Cache » Convert to InnoDB

  • Resolved dimalifragis



    I run WP 5.7.x and LS Cache latest and 10.3.28-MariaDB-log-cll-lve.

    Trying to convert ANY myIsam to InnoDB, i get

    [09-Jul-2021 15:55:09 UTC] WordPress database error You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ‘-wp.

    for all tables i try.

    Any ideas?

Viewing 4 replies - 1 through 4 (of 4 total)
  • Plugin Support qtwrk



    first of all , make a backup , then please try run, in mysql cli or phpmyadmin on your WP databse , with following query


    where wp_xx is the table name in your tables that is myisam

    and post result

    Best regards

    Thread Starter dimalifragis


    That worked ok, converted

    “MySQL returned an empty result set (i.e. zero rows). (Query took 0.0198 seconds.)”

    Plugin Support qtwrk


    now that is weird, because that query was what I extracted from plugin’s source code

    maybe you can try follow this to convert them all

    Thread Starter dimalifragis


    Well thanks, i already found a WP plugin to do that and worked well.

Viewing 4 replies - 1 through 4 (of 4 total)
  • You must be logged in to reply to this topic.