Jump to content
Alejandro

How to solve the illegal collation mix database error? (Joomla)

Recommended Posts

Alejandro

If you are seeing this error on your site after upgrading JReviews, it's most likely caused by the media module or it happens on the media list page. This is where other clients have seen the problem and it happens because the collation of columns in the #__jreviews_media table doesn't match the collation of table columns that are joined in the same query.

 

To solve the problem, first check the collation of the columns of the #__content table, typically utf8_unicode_ci, and then run the following query using phpMyAdmin:

ALTER TABLE `#__jreviews_media` CONVERT TO CHARACTER SET utf8 COLLATE utf8_unicode_ci;

If the collation is different in #__content, then replace it in the above query so it matches what you see. Also make sure you replace #__ with the database prefix for your site.

 

Two more queries added below to fix the collation issue for some review pages:

ALTER TABLE `#__jreviews_reviewer_ranks` CONVERT TO CHARACTER SET utf8 COLLATE utf8_unicode_ci;
ALTER TABLE `#__jreviews_comments` CONVERT TO CHARACTER SET utf8 COLLATE utf8_unicode_ci;

Share this post


Link to post
contact-1448039172

This section is only visible with a valid subscription. If you have a valid subscription, please login.

Share this post


Link to post
Alejandro

This section is only visible with a valid subscription. If you have a valid subscription, please login.

Share this post


Link to post
contact-1448039172

This section is only visible with a valid subscription. If you have a valid subscription, please login.

Share this post


Link to post
Alejandro

This section is only visible with a valid subscription. If you have a valid subscription, please login.

Share this post


Link to post
contact-1448039172

This section is only visible with a valid subscription. If you have a valid subscription, please login.

Share this post


Link to post
warenbewertung.de

This section is only visible with a valid subscription. If you have a valid subscription, please login.

Edited by warenbewertung.de

Share this post


Link to post
Alejandro

This section is only visible with a valid subscription. If you have a valid subscription, please login.

Share this post


Link to post
andragor

This section is only visible with a valid subscription. If you have a valid subscription, please login.

Share this post


Link to post
Alejandro

This section is only visible with a valid subscription. If you have a valid subscription, please login.

Share this post


Link to post

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue. Please refer to our Privacy Policy.