Problems in Components => Phoca Maps => Maps
Posted: 24 Mar 2011, 19:12
Hi!
I want to use Phoca Maps in my web because it have look great. Congratulations for the component.
I installed Phoca Maps but I had problems with table prefix. My prefix is cac_ and not jos_
Well, I followed the instructions of https://www.phoca.cz/documents/2-phoca-g ... em-solving
I created the tables manually in my database of phpmyadmin (It's my first time) but I follow having problems. When I try Components => Phoca Maps => Maps, I have the following error:
500 - Ha ocurrido un error.
Unknown column 'a.language' in 'on clause' SQL=SELECT a.*,l.title AS language_title,uc.name AS editor FROM `cac_phocamaps_map` AS a LEFT JOIN `cac_languages` AS l ON l.lang_code = a.language LEFT JOIN cac_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 `cac_phocamaps_map` AS a LEFT JOIN `cac_languages` AS l ON l.lang_code = a.language LEFT JOIN cac_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 `cac_phocamaps_map` AS a LEFT JOIN `cac_languages` AS l ON l.lang_code = a.language LEFT JOIN cac_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 `cac_phocamaps_map` AS a LEFT JOIN `cac_languages` AS l ON l.lang_code = a.language LEFT JOIN cac_users AS uc ON uc.id=a.checked_out WHERE (a.published IN (0, 1)) ORDER BY a.ordering asc
Can you help me please?
Sorry but, I don't have experience and sorry for my English too.
Thank you!
I want to use Phoca Maps in my web because it have look great. Congratulations for the component.
I installed Phoca Maps but I had problems with table prefix. My prefix is cac_ and not jos_
Well, I followed the instructions of https://www.phoca.cz/documents/2-phoca-g ... em-solving
I created the tables manually in my database of phpmyadmin (It's my first time) but I follow having problems. When I try Components => Phoca Maps => Maps, I have the following error:
500 - Ha ocurrido un error.
Unknown column 'a.language' in 'on clause' SQL=SELECT a.*,l.title AS language_title,uc.name AS editor FROM `cac_phocamaps_map` AS a LEFT JOIN `cac_languages` AS l ON l.lang_code = a.language LEFT JOIN cac_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 `cac_phocamaps_map` AS a LEFT JOIN `cac_languages` AS l ON l.lang_code = a.language LEFT JOIN cac_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 `cac_phocamaps_map` AS a LEFT JOIN `cac_languages` AS l ON l.lang_code = a.language LEFT JOIN cac_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 `cac_phocamaps_map` AS a LEFT JOIN `cac_languages` AS l ON l.lang_code = a.language LEFT JOIN cac_users AS uc ON uc.id=a.checked_out WHERE (a.published IN (0, 1)) ORDER BY a.ordering asc
Can you help me please?
Sorry but, I don't have experience and sorry for my English too.
Thank you!