Problems in Components => Phoca Maps => Maps

Phoca Maps - displaying maps in Joomla! CMS
muscarina88
Phoca Newbie
Phoca Newbie
Posts: 3
Joined: 24 Mar 2011, 18:49

Problems in Components => Phoca Maps => Maps

Post by muscarina88 »

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!
Last edited by muscarina88 on 26 Mar 2011, 19:31, edited 1 time in total.
muscarina88
Phoca Newbie
Phoca Newbie
Posts: 3
Joined: 24 Mar 2011, 18:49

Re: Problems in Components => Phoca Maps => Maps

Post by muscarina88 »

Hi,
I solved the problem re-writting the tables because It had a mistake.
Now I have a popular problem with the languages of "From address" and "Get Route".
I think I try all the post relationated with that but I don't get the change.

Has anyone got?

Thank you!
Post Reply