Title: WordPress database error Illegal mix
Last modified: December 31, 2022

---

# WordPress database error Illegal mix

 *  Resolved [Manu](https://wordpress.org/support/users/cultd3ad/)
 * (@cultd3ad)
 * [3 years, 5 months ago](https://wordpress.org/support/topic/wordpress-database-error-illegal-mix/)
 * Hello Support,
 * i have some issue on my Blog and i found in my error log this entries, any body
   can help me to fix this?
 * thanks in advance
 * `mod_fcgid: stderr: WordPress database error Illegal mix of collations (utf8_general_ci,
   IMPLICIT) and (utf8mb4_unicode_520_ci,COERCIBLE) for operation '=' for query 
   SELECT li._, CONCAT("https://**.**","/",li.slug) AS pretty\_url, referer: https://**.**/
   wp-admin/edit.php?category\_name=valorant-tips-tricks&paged=5 [Sat Dec 31 08:
   51:22.145623 2022] [fcgid:warn] [pid 20565:tid 140529979320064] [client **.**:
   51404] mod\_fcgid: stderr: FROM wpoa\_prli\_links AS li, referer: https://**.**/
   wp-admin/edit.php?category\_name=valorant-tips-tricks&paged=5 [Sat Dec 31 08:
   51:22.145629 2022] [fcgid:warn] [pid 20565:tid 140529979320064] [client **.**:
   51404] mod\_fcgid: stderr: WHERE slug='valorant-freefire-\xf0\x9f\xa4\xa9-keyboard-
   and-mouse-asmr-1', referer: https://**.**/wp-admin/edit.php?category\_name=valorant-
   tips-tricks&paged=5 [Sat Dec 31 08:51:22.145632 2022] [fcgid:warn] [pid 20565:
   tid 140529979320064] [client **.**:51404] mod\_fcgid: stderr: , referer: https://**.**/
   wp-admin/edit.php?category\_name=valorant-tips-tricks&paged=5 [Sat Dec 31 08:
   51:22.145635 2022] [fcgid:warn] [pid 20565:tid 140529979320064] [client **.**:
   51404] mod\_fcgid: stderr: AND link\_status='enabled', referer: https://**.**/
   wp-admin/edit.php?category\_name=valorant-tips-tricks&paged=5 [Sat Dec 31 08:
   51:22.145638 2022] [fcgid:warn] [pid 20565:tid 140529979320064] [client **.**:
   51404] mod\_fcgid: stderr: made by require('wp-blog-header.php'), 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, PrliAppController-
   >redirect, PrliLink->is\_pretty\_link, PrliLink->is\_pretty\_link\_slug, PrliLink-
   >getOneFromSlug, PrliLink->get\_one\_by, wpdb->get\_row, wpdb->print\_error, 
   referer: https://**.**/wp-admin/edit.php?category\_name=valorant-tips-tricks&
   paged=5 [Sat Dec 31 08:51:22.570015 2022] [fcgid:warn] [pid 20565:tid 140529962534656][
   client 157.90.182.28:51406] mod\_fcgid: stderr: PHP Warning: file\_exists(): 
   open\_basedir restriction in effect. File(/var/www/vhosts/**.**/public\_html/
   wp-content/plugins/modeltheme-listings-manager/inc/templates/taxonomy-bonus-archive.
   php/) is not within the allowed path(s): (/var/www/vhosts/**.**/:/tmp/) in /var/
   www/vhosts/**.**_*/public_html/wp-content/plugins/modeltheme-listings-manager/
   modeltheme-listings-manager.php on line 246`

Viewing 1 replies (of 1 total)

 *  [Tyler](https://wordpress.org/support/users/tylerthedude/)
 * (@tylerthedude)
 * [3 years, 5 months ago](https://wordpress.org/support/topic/wordpress-database-error-illegal-mix/#post-16339133)
 * Hi there,
 * This message is logged whenever one or more tables use different collations in
   the database. Could you please reach out to your hosting provider and see if 
   they can change the tables so they all use the same collation? Once the collations
   match, then this message should no longer be logged.
   Kind regards,

Viewing 1 replies (of 1 total)

The topic ‘WordPress database error Illegal mix’ is closed to new replies.

 * ![](https://ps.w.org/pretty-link/assets/icon-256x256.png?rev=2503434)
 * [PrettyLinks - Affiliate Links, Link Branding, Link Tracking, Marketing and Stripe Payments Plugin](https://wordpress.org/plugins/pretty-link/)
 * [Frequently Asked Questions](https://wordpress.org/plugins/pretty-link/#faq)
 * [Support Threads](https://wordpress.org/support/plugin/pretty-link/)
 * [Active Topics](https://wordpress.org/support/plugin/pretty-link/active/)
 * [Unresolved Topics](https://wordpress.org/support/plugin/pretty-link/unresolved/)
 * [Reviews](https://wordpress.org/support/plugin/pretty-link/reviews/)

 * 1 reply
 * 2 participants
 * Last reply from: [Tyler](https://wordpress.org/support/users/tylerthedude/)
 * Last activity: [3 years, 5 months ago](https://wordpress.org/support/topic/wordpress-database-error-illegal-mix/#post-16339133)
 * Status: resolved