Error opening Phoca maps

[sri28]

Hi,
I am using joomla 3.x . I downloaded Phoca map plugin and phoca map component 3.0.1 . I installed it in my Joomla backend. But when I click on any tab such as "maps ,markers" I get this error message.

Error
Illegal mix of collations (utf8_unicode_ci,IMPLICIT) and (utf8_general_ci,IMPLICIT) for operation '=' SQL=SELECT COUNT(*) FROM `b9jbi_phocamaps_map` AS a LEFT JOIN `b9jbi_languages` AS l ON l.lang_code = a.language LEFT JOIN b9jbi_users AS uc ON uc.id=a.checked_out WHERE (a.published IN (0, 1)) 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 FROM `b9jbi_phocamaps_map` AS a LEFT JOIN `b9jbi_languages` AS l ON l.lang_code = a.language LEFT JOIN b9jbi_users AS uc ON uc.id=a.checked_out WHERE (a.published IN (0, 1)) ORDER BY a.ordering asc LIMIT 0, 20 Illegal mix of collations (utf8_unicode_ci,IMPLICIT) and (utf8_general_ci,IMPLICIT) for operation '=' SQL=SELECT COUNT(*) FROM `b9jbi_phocamaps_map` AS a LEFT JOIN `b9jbi_languages` AS l ON l.lang_code = a.language LEFT JOIN b9jbi_users AS uc ON uc.id=a.checked_out WHERE (a.published IN (0, 1))


Can anyone please help ?

[Jan]

Hi, hmm, I think you need to ask your server hosting provider, what can be wrong in the database. Phoca Maps like whole Joomla! or Joomla! components uses standard utf-8 encoding but why in your database are two different (utf8_unicode_ci,IMPLICIT) and (utf8_general_ci,IMPLICIT) formats, really no idea

The only one thing which is defined by the component, is utf-8, see last line:

Code: Select all

CREATE TABLE IF NOT EXISTS `#__phocamaps_icon` (
  `id` int(11) unsigned NOT NULL auto_increment,
  `title` varchar(250) NOT NULL default '',
  `alias` varchar(255) NOT NULL default '',
  `url` text NOT NULL,
  `urls` text NOT NULL,
  `object` varchar(255) NOT NULL default '',
  `objects` varchar(255) NOT NULL default '',
  `objectshape` varchar(255) NOT NULL default '',
  `published` tinyint(1) NOT NULL default '0',
  `checked_out` int(11) unsigned NOT NULL default '0',
  `checked_out_time` datetime NOT NULL default '0000-00-00 00:00:00',
  `ordering` int(11) NOT NULL default '0',
  `access` tinyint(3) unsigned NOT NULL default '0',
  `hits` int(11) NOT NULL default '0',
  `params` text NOT NULL,
  `language` char(7) NOT NULL default '',
  PRIMARY KEY  (`id`)
) CHARACTER SET `utf8`;

nothing about general or unicode

Jan