General > General > Illegal mix of collations > Community Forums > Phoenix Netology
Forum Index > General

Illegal mix of collations Reply to topic


I removed 9.0.5 and tried installing your 9.1.1 version but get this after installation when I use IP Tracker, otherwise it seemed to have installed ok:

includes/db/db.php

* CMS Warning line 75: On /IP_Tracker.html While executing query "SELECT i.ipusername, i.ip_address, i.hostname, MAX(date_time), COUNT(*), MIN(ipid), s.uname, u.username FROM nuke_iptracking AS i LEFT JOIN nuke_session AS s ON s.uname=i.ipusername LEFT JOIN nuke_users AS u ON u.username=i.ipusername WHERE 1=1 GROUP BY 1,2,3 ORDER BY 4 DESC LIMIT 0, 100" the following error occured: Illegal mix of collations (latin1_swedish_ci,IMPLICIT) and (utf8_general_ci,IMPLICIT) for operation '=' In: /home/user/domains/domain.us/public_html/modules/IP_Tracker/index.php on line: 283

American's server specs (Server OS / Apache / MySQL / PHP / DragonflyCMS)
FC4/2.0.59/4.1.12/4.4.4/9.1.1

Please enter your server specs in your user profile! 😢


That's your database issue, "illegal mix of collations".

You obviously have a different collation for IP Tracker when you installed it, compared to what you have for your session and users tables.

You need to ensure all your tables and fields are the same, otherwise you will have problems with any module you install that needs to interact with other tables in your database.

Plenty of examples of this on the DragonflyCMS site.

Donations & Audit for DragonflyCMS

Server specs (Server OS / Apache / MySQL / PHP / DragonflyCMS):


I'm confused.... could explain a bit more in layman's terms?

Please enter your server specs in your user profile! 😢


Sorry, but I won't deal with database support issues here.

It's beyond the scope of this site and forum and it's been covered many times on the DragonflyCMS site - it really is best dealt with there.

Check your database table and field structures in phpmyadmin.

Donations & Audit for DragonflyCMS

Server specs (Server OS / Apache / MySQL / PHP / DragonflyCMS):


Ok. FYI for anyone else that runs into this. I had to convert all of the tables in my db to utf8 from latin1. Works like a champ now and as Phoenix stated it's pretty well covered over at DragonflyCMS.

Please enter your server specs in your user profile! 😢

All times are Australia/Adelaide


Jump to: