500 Error

[lordtheydon]

Hi there,

I have just downloaded, and installed the Phoca Maps Component, and also the Plugin (which
I have also made sure it is published), and when I go to create a Map I get the following error
code appearing:

Code: Select all

500 - An error has occurred.

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 `jos_phocamaps_map` AS a LEFT JOIN `jos_languages` AS l ON l.lang_code = a.language LEFT JOIN jos_users AS uc ON uc.id=a.checked_out WHERE (a.published IN (0, 1)) ORDER BY a.ordering asc 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 `jos_phocamaps_map` AS a LEFT JOIN `jos_languages` AS l ON l.lang_code = a.language LEFT JOIN jos_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 a.*,l.title AS language_title,uc.name AS editor FROM `jos_phocamaps_map` AS a LEFT JOIN `jos_languages` AS l ON l.lang_code = a.language LEFT JOIN jos_users AS uc ON uc.id=a.checked_out WHERE (a.published IN (0, 1)) ORDER BY a.ordering asc 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 `jos_phocamaps_map` AS a LEFT JOIN `jos_languages` AS l ON l.lang_code = a.language LEFT JOIN jos_users AS uc ON uc.id=a.checked_out WHERE (a.published IN (0, 1)) ORDER BY a.ordering asc

Return to Control Panel

It is showing on the Joomla Admin page, so I am assuming it is a problem on the Msql installation.

Any advice would be appreciated as your Map looks perfect for adding to my website.

Many thanks,


John

[Jan]

Hi, you need to recheck if your database uses unique encoding.

Jan

[baysoft]

hi john
same problem i face. any update in solving it. pl share.

[BigD]

HI

Not sure if this is related but I also experienced a 500 Error when I installed the latest version for 1.7.

Unknown column 'a.language' in 'on clause' SQL=SELECT a.*,l.title AS language_title,uc.name AS editor FROM `ezrj7_phocamaps_map` AS a LEFT JOIN `ezrj7_languages` AS l ON l.lang_code = a.language LEFT JOIN ezrj7_users AS uc ON uc.id=a.checked_out WHERE (a.published IN (0, 1)) ORDER BY a.ordering asc Unknown column 'a.language' in 'on clause' SQL=SELECT a.*,l.title AS language_title,uc.name AS editor FROM `ezrj7_phocamaps_map` AS a LEFT JOIN `ezrj7_languages` AS l ON l.lang_code = a.language LEFT JOIN ezrj7_users AS uc ON uc.id=a.checked_out WHERE (a.published IN (0, 1)) ORDER BY a.ordering asc LIMIT 0, 20 Unknown column 'a.language' in 'on clause' SQL=SELECT a.*,l.title AS language_title,uc.name AS editor FROM `ezrj7_phocamaps_map` AS a LEFT JOIN `ezrj7_languages` AS l ON l.lang_code = a.language LEFT JOIN ezrj7_users AS uc ON uc.id=a.checked_out WHERE (a.published IN (0, 1)) ORDER BY a.ordering asc Unknown column 'a.language' in 'on clause' SQL=SELECT a.*,l.title AS language_title,uc.name AS editor FROM `ezrj7_phocamaps_map` AS a LEFT JOIN `ezrj7_languages` AS l ON l.lang_code = a.language LEFT JOIN ezrj7_users AS uc ON uc.id=a.checked_out WHERE (a.published IN (0, 1)) ORDER BY a.ordering asc

That means nothing to me?

Does anybody have a solution or an idea what needs to be done?

Thanks

[BigD]

Anybody have a solution?

[Jan]

Hi, language column is missiong in your database, you should install the Phoca Maps as new installation (current data will be lost) or you need to run the sql queries manually, see e.g. guide for Phoca Gallery (it is similar for all components):
https://www.phoca.cz/documents/2-phoca-g ... em-solving

Or search this forum, there are some instructions too.

Jan

[BigD]

Hi, I reinstalled Phoca Maps and it is now working. Thanks
BD

[Jan]

Ok

[Topaz]

Have the same error as BigD, tried reinstalling no avail. The install.sql is empty zero bytes and install.bak.sql gives
"#1136 - Column count doesn't match value count at row 1 "
when manually inserted

Please advise

[Jan]

Hi, you need to change the prefixes to your own, see e.g.:
https://www.phoca.cz/documents/2-phoca-g ... em-solving (it is for phoca gallery but is the same for every extension)

Jan