Title: TABLE `wp_amr_reportcache`
Last modified: February 26, 2017

---

# TABLE `wp_amr_reportcache`

 *  [gsh2000](https://wordpress.org/support/users/gsh2000/)
 * (@gsh2000)
 * [9 years, 2 months ago](https://wordpress.org/support/topic/table-wp_amr_reportcache/)
 * Anna-marie hi,
 * amr users 4.3
    MySQL 5.6.32-78.1 phpMyAdmin 4.3.8 PHP:5.6.29
 * Have encountered a strange anomaly in exporting/importing my wordpress mysql 
   database in phpmyadmin.(migrating servers)
 * phpmyadmin does not like your wp_amr_reportcache table. It references an incompatible
   collation type of ‘utf8mb4_unicode_520_ci’
 * All other WP tables are utf8mb4_unicode_ci
 * Any suggestions? Did want to manually change (break?) anything prior to consulting
   with you. Have read quite a bit in various forums. Modifying phpmyadmin export/
   import parameters has not worked for me.
 * See error message below –
 * thanks – GARRY
 * CREATE TABLE `wp_amr_reportcachelogging` (
    `id` bigint(20) NOT NULL AUTO_INCREMENT,`
   eventtime` datetime NOT NULL, `eventdescription` text COLLATE utf8mb4_unicode_520_ci
   NOT NULL, PRIMARY KEY (`id`) ) ENGINE=MyISAM AUTO_INCREMENT=18 DEFAULT CHARSET
   =utf8mb4 COLLATE=utf8mb4_unicode_520_ci; MySQL said: Documentation #1273 – Unknown
   collation: ‘utf8mb4_unicode_520_ci’

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

 *  Thread Starter [gsh2000](https://wordpress.org/support/users/gsh2000/)
 * (@gsh2000)
 * [9 years, 2 months ago](https://wordpress.org/support/topic/table-wp_amr_reportcache/#post-8850579)
 * oops – it actually this table as you will see in error message:
 * wp_amr_reportcachelogging
 *  Thread Starter [gsh2000](https://wordpress.org/support/users/gsh2000/)
 * (@gsh2000)
 * [9 years, 2 months ago](https://wordpress.org/support/topic/table-wp_amr_reportcache/#post-8850598)
 * update:
 * — manually changing wp_amr_reportcachelogging and wp_amr_reportcachelogging->
   eventdescription to utf8mb4_unicode_ci in phpMyAdmin, does solve my WP data export/
   import problem, but yet to test if this has any effect on app functionality.
 * GARRY
 *  Plugin Author [anmari](https://wordpress.org/support/users/anmari/)
 * (@anmari)
 * [9 years, 2 months ago](https://wordpress.org/support/topic/table-wp_amr_reportcache/#post-8851081)
 * Hi Garry,
 * all those utf8mb4… collations are coming from your system.
 * The Plugin references the wp global $charset_collate and if it is empty, it sets
   a default for the sql statement ‘ DEFAULT CHARACTER SET utf8 DEFAULT COLLATE 
   utf8_general_ci ‘
 * So whatever was going on there, the collation was set by your sites environment.
   Hope it works for you now.
 * Aside:
    Since wp 3.5 there is now a function $wpdb->get_charset_collate(), which
   I will update the plugin to use next version. (Thanks for flagging)

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

The topic ‘TABLE `wp_amr_reportcache`’ is closed to new replies.

 * ![](https://s.w.org/plugins/geopattern-icon/amr-users_f6f6f4.svg)
 * [amr users](https://wordpress.org/plugins/amr-users/)
 * [Support Threads](https://wordpress.org/support/plugin/amr-users/)
 * [Active Topics](https://wordpress.org/support/plugin/amr-users/active/)
 * [Unresolved Topics](https://wordpress.org/support/plugin/amr-users/unresolved/)
 * [Reviews](https://wordpress.org/support/plugin/amr-users/reviews/)

 * 3 replies
 * 2 participants
 * Last reply from: [anmari](https://wordpress.org/support/users/anmari/)
 * Last activity: [9 years, 2 months ago](https://wordpress.org/support/topic/table-wp_amr_reportcache/#post-8851081)
 * Status: not resolved