Database Collate

  • Resolved Peter Wooster

    (@pkwooster)


    6 months ago

    The database tables created by WP Cookie Consent use a collating sequence that is not supported by MariaDB. This causes difficulties moving a site from a MySQL to MariaDB server. The unsupported collating sequence is utf8mb4_0900_ai_ci.

    An example is {prefix}gdpr_cookie_post_cookies

Viewing 3 replies - 1 through 3 (of 3 total)
  • ojas21

    (@ojas21)

    Hi there,

    Thanks for getting back to us.

    The issue you are facing is likely due to the the version of MySQL is different on live server and local server , please trying updating the version of MySQL .
    And if the issue still persist please raise the ticket at [email protected].

    Thanks for your understanding.

    Thread Starter Peter Wooster

    (@pkwooster)

    The issue is that the remote server is MySQL, the local server is MariaDB which doesn’t support the utf8mb4_0900_ai_ci collate. Something in your plugin is requesting that collate as it doesn’t appear in any other database tables.

    Hello, @pkwooster

    We apologise for the wait for my response.

    To receive assistance with this issue, kindly submit a support ticket to [email protected].
    We’ll quickly resolve your problem.

    We appreciate your understanding.

    Warm regards.

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