Title: rvg optimize database DB errors
Last modified: August 22, 2016

---

# rvg optimize database DB errors

 *  Resolved [Eyup Sonmez](https://wordpress.org/support/users/eyup-sonmez/)
 * (@eyup-sonmez)
 * [11 years, 4 months ago](https://wordpress.org/support/topic/rvg-optimize-database-db-errors/)
 * **The following errors, constant “error_log” is generating. File size is growing
   and swelling. Do you think the fix?**
 * ————–
    [31-Jan-2015 15:18:35 UTC] do_action_ref_array, call_user_func_array, 
   rvg_optimize_db_cron, rvg_get_trash, W3_Db->query, W3_DbCache->query, W3_DbCallUnderlying-
   >query, W3_Db->query, W3_DbProcessor->query, W3_Db->default_query tarafından 
   oluşturulan SELECT `ID` AS id, ‘post’ AS post_type, `post_title` AS title, `post_modified`
   AS modified FROM eb_posts WHERE `post_status` = ‘trash’ UNION ALL SELECT `comment_ID`
   AS id, ‘comment’ AS post_type, `comment_author_IP` AS title, `comment_date` AS
   modified FROM eb_comments WHERE `comment_approved` = ‘trash’ ORDER BY post_type,
   UCASE(title) sorgusu için WordPress veritabanı hatası Illegal mix of collations
   for operation ‘UNION’ [31-Jan-2015 16:19:29 UTC] do_action_ref_array, call_user_func_array,
   rvg_optimize_db_cron, rvg_get_trash, W3_Db->query, W3_DbCache->query, W3_DbCallUnderlying-
   >query, W3_Db->query, W3_DbProcessor->query, W3_Db->default_query tarafından 
   oluşturulan SELECT `ID` AS id, ‘post’ AS post_type, `post_title` AS title, `post_modified`
   AS modified FROM eb_posts WHERE `post_status` = ‘trash’ UNION ALL SELECT `comment_ID`
   AS id, ‘comment’ AS post_type, `comment_author_IP` AS title, `comment_date` AS
   modified FROM eb_comments WHERE `comment_approved` = ‘trash’ ORDER BY post_type,
   UCASE(title) sorgusu için WordPress veritabanı hatası Illegal mix of collations
   for operation ‘UNION’
 * [https://wordpress.org/plugins/rvg-optimize-database/](https://wordpress.org/plugins/rvg-optimize-database/)

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

 *  Plugin Contributor [cageehv](https://wordpress.org/support/users/cageehv/)
 * (@cageehv)
 * [11 years, 4 months ago](https://wordpress.org/support/topic/rvg-optimize-database-db-errors/#post-5735918)
 * Hey Eyup,
 * It seems that it’s a problem with your WordPress setup.
 * The tables ‘ep_posts’ and ‘ep_comments’ seem to have a different collation…
    (
   for instance: one is UTF8 and the other one LATIN or so…)
 * Can you check and let me know if that’s the case?
 * Ciao,
    Rolf
 *  Thread Starter [Eyup Sonmez](https://wordpress.org/support/users/eyup-sonmez/)
 * (@eyup-sonmez)
 * [11 years, 4 months ago](https://wordpress.org/support/topic/rvg-optimize-database-db-errors/#post-5736136)
 * **Problem solved ..**
 * Previous cases (collation was different):
    ——- TABLE> eb_post ——————> **utf8_turkish_ci**——-
   TABLE> eb_comments ———> utf8_general_ci
 * Recent Status (collation same challenge as correct.):
    ——- TABLE> eb_post ——————
   > **utf8_general_ci** ——- TABLE> eb_comments ———> utf8_general_ci
 * Thank you very much
 *  Plugin Contributor [cageehv](https://wordpress.org/support/users/cageehv/)
 * (@cageehv)
 * [11 years, 4 months ago](https://wordpress.org/support/topic/rvg-optimize-database-db-errors/#post-5736137)
 * Hey Eyup,
 * Glad I could help!
 * Ciao,
    Rolf

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

The topic ‘rvg optimize database DB errors’ is closed to new replies.

 * ![](https://ps.w.org/rvg-optimize-database/assets/icon-256x256.png?rev=3350597)
 * [Optimize Database after Deleting Revisions](https://wordpress.org/plugins/rvg-optimize-database/)
 * [Frequently Asked Questions](https://wordpress.org/plugins/rvg-optimize-database/#faq)
 * [Support Threads](https://wordpress.org/support/plugin/rvg-optimize-database/)
 * [Active Topics](https://wordpress.org/support/plugin/rvg-optimize-database/active/)
 * [Unresolved Topics](https://wordpress.org/support/plugin/rvg-optimize-database/unresolved/)
 * [Reviews](https://wordpress.org/support/plugin/rvg-optimize-database/reviews/)

 * 3 replies
 * 2 participants
 * Last reply from: [cageehv](https://wordpress.org/support/users/cageehv/)
 * Last activity: [11 years, 4 months ago](https://wordpress.org/support/topic/rvg-optimize-database-db-errors/#post-5736137)
 * Status: resolved