display category problem

[reza6367]

hi
when i create a category after save , can not see that on back-end .its for file too happen , but i can see thats on front-end!

[Jan]

Hi, if you enable php error reporting, do you get any error on that site?

[reza6367]

JDatabaseMySQLi::query: 1267 - Illegal mix of collations (utf8_unicode_ci,IMPLICIT) and (utf8_general_ci,IMPLICIT) for operation '=' SQL=SELECT a.*,l.title AS language_title,uc.name AS editor,ag.title AS access_level,c.title AS parentcat_title, c.id AS parentcat_id,cc.countid AS countid FROM `k4xv8_phocadownload_categories` AS a LEFT JOIN `k4xv8_languages` AS l ON l.lang_code = a.language LEFT JOIN k4xv8_users AS uc ON uc.id=a.checked_out LEFT JOIN k4xv8_viewlevels AS ag ON ag.id = a.access LEFT JOIN k4xv8_phocadownload_categories AS c ON c.id = a.parent_id LEFT JOIN (SELECT cc.parent_id, count(*) AS countid FROM k4xv8_phocadownload_categories AS cc GROUP BY cc.parent_id ) AS cc ON a.parent_id = cc.parent_id WHERE (a.published IN (0, 1)) GROUP BY a.id ORDER BY a.title asc

[Jan]

Hi, this seems like you need to fix collation (language character settings) in your database - convert all the database to utf-8, try to see this one (not sure if this can help, needs to be tested):
https://www.phoca.cz/phoca-changing-collation
https://www.phoca.cz/documents/38-tools/ ... n-database
Jan