I have some components with database collation hungarian and I had some problems with mixed collations so I decided to change all of them to UTF8_general_ci. First time I had serious problems because I received erorr messages such as mixed collation and I could not even get back my backend so I had to modify manually some database tables's collation. Finally the error disappeared but still some tables had the hungarian collation so Idecided to continue and try againto change the database collation. This time I receive this error.
1062 Duplicate entry 'sort' for key 'idx_term' SQL=ALTER TABLE `dzsum_finder_terms` MODIFY COLUMN `term` varchar(75) NOT NULL COLLATE utf8_general_ci, MODIFY COLUMN `stem` varchar(75) NOT NULL COLLATE utf8_general_ci, MODIFY COLUMN `soundex` varchar(75) NOT NULL COLLATE utf8_general_ci, MODIFY COLUMN `language` char(3) NOT NULL DEFAULT '' COLLATE utf8_general_ci, DEFAULT CHARACTER SET UTF8 COLLATE utf8_general_ci
What could be the problem?
Apparently my site works OK.
Thanks.
Zoltán
1062 Duplicate entry 'sort' for key 'idx_term' SQL=ALTER TABLE `dzsum_finder_terms` MODIFY COLUMN `term` varchar(75) NOT NULL COLLATE utf8_general_ci, MODIFY COLUMN `stem` varchar(75) NOT NULL COLLATE utf8_general_ci, MODIFY COLUMN `soundex` varchar(75) NOT NULL COLLATE utf8_general_ci, MODIFY COLUMN `language` char(3) NOT NULL DEFAULT '' COLLATE utf8_general_ci, DEFAULT CHARACTER SET UTF8 COLLATE utf8_general_ci
What could be the problem?
Apparently my site works OK.
Thanks.
Zoltán
