Page 1 of 2

500 Error

Posted: 28 May 2011, 06:07
by 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

Re: 500 Error

Posted: 26 Jul 2011, 20:34
by Jan
Hi, you need to recheck if your database uses unique encoding.

Jan

Re: 500 Error

Posted: 14 Aug 2011, 19:19
by baysoft
hi john
same problem i face. any update in solving it. pl share.

Re: 500 Error

Posted: 22 Aug 2011, 12:20
by 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

Re: 500 Error

Posted: 25 Aug 2011, 12:40
by BigD
Anybody have a solution?

Re: 500 Error

Posted: 25 Aug 2011, 18:52
by 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

Re: 500 Error

Posted: 26 Aug 2011, 08:28
by BigD
Hi, I reinstalled Phoca Maps and it is now working. Thanks
BD

Re: 500 Error

Posted: 26 Aug 2011, 17:09
by Jan
Ok

Re: 500 Error

Posted: 01 Sep 2011, 05:43
by 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

Re: 500 Error

Posted: 06 Sep 2011, 22:48
by 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