database Collation error

  • Resolved stupidchief

    (@stupidchief)


    8 years, 1 month ago

    When trying to install I get this error:

    Fatal error: Uncaught exception ‘PDOException’ with message ‘SQLSTATE[42000]: Syntax error or access violation: 1253 COLLATION ‘utf8_general_ci’ is not valid for CHARACTER SET ‘utf8mb4”

Viewing 2 replies - 1 through 2 (of 2 total)
  • Thread Starter stupidchief

    (@stupidchief)

    I know I can just change DB_CHARSET to utf8 but thats not ideal

    Plugin Author flycart

    (@flycart)

    Axis Subscriptions uses the Herbert framework and Eloquent ORM from Laravel which makes the connection
    This was a known issue and it could be fixed by two ways

    1. As you mentioned, you can change the DB_CHARSET

    or
    2. Edit /vendor/getherbert/framework/Herbert/Framework/Providers/HerbertServiceProvider.php

    Around line 140, you will find

    ‘collation’ => $wpdb->collate,

    Change this to

    ‘collation’ => ‘utf8’,

    I guess the first will be the easy one to do.

    We have given a pull request making a conditional check and set the charset to utf8 event if the wordpress config has it as utf8mb4

Viewing 2 replies - 1 through 2 (of 2 total)
  • The topic ‘database Collation error’ is closed to new replies.