I have this warning when I try to add categories in Russian

user warning: Illegal mix of collations (latin1_swedish_ci,IMPLICIT) and (utf8_general_ci,COERCIBLE) for operation '=' query: aggregator_summary_form_section_validate SELECT sname FROM aggregator_summary_section WHERE (sname = '*******' ) AND sid != 1 in /home/*****/public_html/*****/includes/database.mysql.inc on line 172.

My site is configued in UTF-8. Two tables of your module were in latin 1. I changed chartset for UTF-8 but there is still this problem.
Thank you.

Comments

info@zrix.com’s picture

info@zrix.com commented

Please make the following changes in Aggregator_Summary.install file:

Replace this

db_query("CREATE TABLE {aggregator_summary_category_section} (
cid int(10) NOT NULL default '0',
sid int(10) NOT NULL default '0'
) ");
db_query("CREATE TABLE {aggregator_summary_section} (
sid integer NOT NULL default '0',
sname varchar(32) NOT NULL default '',
item_perpage integer NOT NULL default '0',
PRIMARY KEY (sid)
)");

with the following:

db_query("CREATE TABLE {aggregator_summary_category_section} (
cid int(10) NOT NULL default '0',
sid int(10) NOT NULL default '0'
)/*!40100 DEFAULT CHARACTER SET UTF8 */ ");
db_query("CREATE TABLE {aggregator_summary_section} (
sid integer NOT NULL default '0',
sname varchar(32) NOT NULL default '',
item_perpage integer NOT NULL default '0',
PRIMARY KEY (sid)
)/*!40100 DEFAULT CHARACTER SET UTF8 */ ");

info@zrix.com’s picture

info@zrix.com commented
Status: Active » Closed (fixed)