Title: Unknown collation
Last modified: April 13, 2024

---

# Unknown collation

 *  Resolved [JoyceD6](https://wordpress.org/support/users/joyced6/)
 * (@joyced6)
 * [2 years, 6 months ago](https://wordpress.org/support/topic/unknown-collation/)
 * I getting this error: Potential Problems**WordPress Memory Limit: 40MB    |  
   Your usage now: 57MB **
 * This is a partial list of the errors found.
   **error_log**
 *     ```wp-block-code
       -----------y-------------[13-Apr-2024 01:59:37 UTC] WordPress database error Unknown collation: '' for query ALTER TABLE wp_statistics_events DEFAULT CHARSET='utf8' COLLATE '' ROW_FORMAT = COMPACT; made by require_once('wp-load.php'), require_once('wp-config.php'), require_once('wp-settings.php'), do_action('init'), WP_Hook->do_action, WP_Hook->apply_filters, WP_STATISTICS\Install->plugin_upgrades-----------y-----------------------y-------------[13-Apr-2024 01:59:37 UTC] WordPress database error Unknown collation: '' for query ALTER TABLE wp_statistics_visitor_relationships DEFAULT CHARSET='utf8' COLLATE '' ROW_FORMAT = COMPACT; made by require_once('wp-load.php'), require_once('wp-config.php'), require_once('wp-settings.php'), do_action('init'), WP_Hook->do_action, WP_Hook->apply_filters, WP_STATISTICS\Install->plugin_upgrades-----------y-----------------------y-------------[13-Apr-2024 01:59:37 UTC] WordPress database error Unknown collation: '' for query ALTER TABLE wp_statistics_historical DEFAULT CHARSET='utf8' COLLATE '' ROW_FORMAT = COMPACT; made by require_once('wp-load.php'), require_once('wp-config.php'), require_once('wp-settings.php'), do_action('init'), WP_Hook->do_action, WP_Hook->apply_filters, WP_STATISTICS\Install->plugin_upgrades-----------y-----------------------y-------------[13-Apr-2024 01:59:37 UTC] WordPress database error Unknown collation: '' for query ALTER TABLE wp_statistics_search DEFAULT CHARSET='utf8' COLLATE '' ROW_FORMAT = COMPACT; made by require_once('wp-load.php'), require_once('wp-config.php'), require_once('wp-settings.php'), do_action('init'), WP_Hook->do_action, WP_Hook->apply_filters, WP_STATISTICS\Install->plugin_upgrades-----------y-----------------------y-------------[13-Apr-2024 01:59:37 UTC] WordPress database error Unknown collation: '' for query ALTER TABLE wp_statistics_pages DEFAULT CHARSET='utf8' COLLATE '' ROW_FORMAT = COMPACT; made by require_once('wp-load.php'), require_once('wp-config.php'), require_once('wp-settings.php'), do_action('init'), WP_Hook->do_action, WP_Hook->apply_filters, WP_STATISTICS\Install->plugin_upgrades-----------y-----------------------y-------------[13-Apr-2024 01:59:37 UTC] WordPress database error Unknown collation: '' for query ALTER TABLE wp_statistics_exclusions DEFAULT CHARSET='utf8' COLLATE '' ROW_FORMAT = COMPACT; made by require_once('wp-load.php'), require_once('wp-config.php'), require_once('wp-settings.php'), do_action('init'), WP_Hook->do_action, WP_Hook->apply_filters, WP_STATISTICS\Install->plugin_upgrades-----------y-----------------------y-------------[13-Apr-2024 01:59:37 UTC] WordPress database error Unknown collation: '' for query ALTER TABLE wp_statistics_visitor DEFAULT CHARSET='utf8' COLLATE '' ROW_FORMAT = COMPACT; made by require_once('wp-load.php'), require_once('wp-config.php'), require_once('wp-settings.php'), do_action('init'), WP_Hook->do_action, WP_Hook->apply_filters, WP_STATISTICS\Install->plugin_upgrades-----------y-----------------------y-------------[13-Apr-2024 01:59:37 UTC] WordPress database error Unknown collation: '' for query ALTER TABLE wp_statistics_visit DEFAULT CHARSET='utf8' COLLATE '' ROW_FORMAT = COMPACT; made by require_once('wp-load.php'), require_once('wp-config.php'), require_once('wp-settings.php'), do_action('init'), WP_Hook->do_action, WP_Hook->apply_filters, WP_STATISTICS\Install->plugin_upgrades-----------y-----------------------y-------------[13-Apr-2024 01:59:37 UTC] WordPress database error Unknown collation: '' for query ALTER TABLE wp_statistics_useronline DEFAULT CHARSET='utf8' COLLATE '' ROW_FORMAT = COMPACT; made by require_once('wp-load.php'), require_once('wp-config.php'), require_once('wp-settings.php'), do_action('init'), WP_Hook->do_action, WP_Hook->apply_filters, WP_STATISTICS\Install->plugin_upgrades-----------y------------
       ```
   
 * The page I need help with: _[[log in](https://login.wordpress.org/?redirect_to=https%3A%2F%2Fwordpress.org%2Fsupport%2Ftopic%2Funknown-collation%2F%3Foutput_format%3Dmd&locale=en_US)
   to see the link]_

Viewing 2 replies - 1 through 2 (of 2 total)

 *  Thread Starter [JoyceD6](https://wordpress.org/support/users/joyced6/)
 * (@joyced6)
 * [2 years, 6 months ago](https://wordpress.org/support/topic/unknown-collation/#post-17683745)
 * I guess I’ll have to disable this plugin.
 *  Plugin Author [VeronaLabs](https://wordpress.org/support/users/veronalabs/)
 * (@veronalabs)
 * [2 years, 6 months ago](https://wordpress.org/support/topic/unknown-collation/#post-17684025)
 * Hello,
 * Thank you for reporting the issue. We have already fixed it in the development
   version which will be released soon.
 * [https://github.com/wp-statistics/wp-statistics/commit/425e91b9325490ca45372adba25ef92c68d2dac5](https://github.com/wp-statistics/wp-statistics/commit/425e91b9325490ca45372adba25ef92c68d2dac5)
 * Best

Viewing 2 replies - 1 through 2 (of 2 total)

 The topic ‘Unknown collation’ is closed to new replies.

 * ![](https://ps.w.org/wp-statistics/assets/icon.svg?rev=3081064)
 * [WP Statistics – Simple, privacy-friendly Google Analytics alternative](https://wordpress.org/plugins/wp-statistics/)
 * [Frequently Asked Questions](https://wordpress.org/plugins/wp-statistics/#faq)
 * [Support Threads](https://wordpress.org/support/plugin/wp-statistics/)
 * [Active Topics](https://wordpress.org/support/plugin/wp-statistics/active/)
 * [Unresolved Topics](https://wordpress.org/support/plugin/wp-statistics/unresolved/)
 * [Reviews](https://wordpress.org/support/plugin/wp-statistics/reviews/)

 * 2 replies
 * 2 participants
 * Last reply from: [VeronaLabs](https://wordpress.org/support/users/veronalabs/)
 * Last activity: [2 years, 6 months ago](https://wordpress.org/support/topic/unknown-collation/#post-17684025)
 * Status: resolved