Title: database Collation error
Last modified: February 3, 2017

---

# database Collation error

 *  Resolved [stupidchief](https://wordpress.org/support/users/stupidchief/)
 * (@stupidchief)
 * [9 years, 3 months ago](https://wordpress.org/support/topic/database-collation-error/)
 * 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](https://wordpress.org/support/users/stupidchief/)
 * (@stupidchief)
 * [9 years, 3 months ago](https://wordpress.org/support/topic/database-collation-error/#post-8733696)
 * I know I can just change DB_CHARSET to utf8 but thats not ideal
 *  Plugin Author [flycart](https://wordpress.org/support/users/flycart/)
 * (@flycart)
 * [9 years, 3 months ago](https://wordpress.org/support/topic/database-collation-error/#post-8749373)
 * 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.

 * ![](https://s.w.org/plugins/geopattern-icon/axis-subscriptions_c3b9d9.svg)
 * [Membership & Subscription with Content Restriction - Axis Subscriptions](https://wordpress.org/plugins/axis-subscriptions/)
 * [Frequently Asked Questions](https://wordpress.org/plugins/axis-subscriptions/#faq)
 * [Support Threads](https://wordpress.org/support/plugin/axis-subscriptions/)
 * [Active Topics](https://wordpress.org/support/plugin/axis-subscriptions/active/)
 * [Unresolved Topics](https://wordpress.org/support/plugin/axis-subscriptions/unresolved/)
 * [Reviews](https://wordpress.org/support/plugin/axis-subscriptions/reviews/)

 * 2 replies
 * 2 participants
 * Last reply from: [flycart](https://wordpress.org/support/users/flycart/)
 * Last activity: [9 years, 3 months ago](https://wordpress.org/support/topic/database-collation-error/#post-8749373)
 * Status: resolved