Title: Burst Statistics maybe causing a Database Error
Last modified: September 4, 2024

---

# Burst Statistics maybe causing a Database Error

 *  Resolved [CarstenTimm](https://wordpress.org/support/users/carstentimm/)
 * (@carstentimm)
 * [1 year, 9 months ago](https://wordpress.org/support/topic/burst-statistics-maybe-causing-a-database-error/)
 * Please help 🙂
   Not sure if this is a dubble post, as I made one that seems to
   have disapeared..
 * Not sure if this is caused by Burst Statistics, but it looks like that to me,
   if not, please point me in the right direction to solve this 🙂
   This is reported
   after every Cron Job:
 *     ```wp-block-code
       WordPress database error Illegal mix of collations (utf8mb4_unicode_ci,IMPLICIT) and (utf8mb4_unicode_520_ci,IMPLICIT) for operation '=' for query UPDATE wp_burst_statistics AS t                                                JOIN (                                                    SELECT p.platform, p.ID, COALESCE(m.ID, 0) as platform_id                                                    FROM wp_burst_statistics p                                                    LEFT JOIN wp_burst_platforms m ON p.platform = m.name                                                    WHERE p.platform_id = 999999                                                LIMIT 100000                                                ) AS s ON t.ID = s.ID                                                SET t.platform_id = s.platform_id; made by include('phar:///usr/bin/wp-cli/php/boot-phar.php'), include('phar:///usr/bin/wp-cli/vendor/wp-cli/wp-cli/php/wp-cli.php'), WP_CLI\bootstrap, WP_CLI\Bootstrap\LaunchRunner->process, WP_CLI\Runner->start, WP_CLI\Runner->run_command_and_exit, WP_CLI\Runner->run_command, WP_CLI\Dispatcher\Subcommand->invoke, call_user_func, WP_CLI\Dispatcher\CommandFactory::WP_CLI\Dispatcher\{closure}, call_user_func, Cron_Event_Command->run, Cron_Event_Command::run_event, do_action_ref_array('burst_upgrade_iteration'), WP_Hook->do_action, WP_Hook->apply_filters, burst_db_upgrade->upgrade, burst_db_upgrade->upgrade_lookup_tables
       ```
   
 * Let me know if you need any more information.
   Thank you for looking into this
   🙂

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

 *  Thread Starter [CarstenTimm](https://wordpress.org/support/users/carstentimm/)
 * (@carstentimm)
 * [1 year, 9 months ago](https://wordpress.org/support/topic/burst-statistics-maybe-causing-a-database-error/#post-17993990)
 * Sorry, this is a second post on the same problem, as I did not see that the first
   one was held for moderation, Sorry
 * Please feel free to release the one that you find best 🙂
 *  Plugin Author [Hessel de Jong](https://wordpress.org/support/users/hesseldejong/)
 * (@hesseldejong)
 * [1 year, 9 months ago](https://wordpress.org/support/topic/burst-statistics-maybe-causing-a-database-error/#post-17994311)
 * I have replied to your other post, so I will resolve this one! 🙂

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

The topic ‘Burst Statistics maybe causing a Database Error’ is closed to new replies.

 * ![](https://ps.w.org/burst-statistics/assets/icon-256x256.png?rev=2672964)
 * [Burst Statistics – Simple WordPress Analytics (Google Analytics Alternative)](https://wordpress.org/plugins/burst-statistics/)
 * [Frequently Asked Questions](https://wordpress.org/plugins/burst-statistics/#faq)
 * [Support Threads](https://wordpress.org/support/plugin/burst-statistics/)
 * [Active Topics](https://wordpress.org/support/plugin/burst-statistics/active/)
 * [Unresolved Topics](https://wordpress.org/support/plugin/burst-statistics/unresolved/)
 * [Reviews](https://wordpress.org/support/plugin/burst-statistics/reviews/)

 * 2 replies
 * 2 participants
 * Last reply from: [Hessel de Jong](https://wordpress.org/support/users/hesseldejong/)
 * Last activity: [1 year, 9 months ago](https://wordpress.org/support/topic/burst-statistics-maybe-causing-a-database-error/#post-17994311)
 * Status: resolved