Phoca Forum

I am getting the following error message when trying to access/set up maps or markers.
Anyone know what to do? I deleted all the files and tried to reload the app, but got the same error!
Thank you, Steve

500 Unknown column 'a.language' in 'on clause' SQL=SELECT a.*,l.title AS language_title,uc.name AS editor FROM `#__phocamaps_map` AS a LEFT JOIN `#__languages` AS l ON l.lang_code = a.language LEFT JOIN #__users AS uc ON uc.id=a.checked_out WHERE (a.published IN (0, 1)) ORDER BY a.ordering asc LIMIT 100 Unknown column 'a.language' in 'on clause' SQL=SELECT COUNT(*) FROM `#__phocamaps_map` AS a LEFT JOIN `#__languages` AS l ON l.lang_code = a.language LEFT JOIN #__users AS uc ON uc.id=a.checked_out WHERE (a.published IN (0, 1))

Hi, which version of Phoca Maps and Joomla! do you use?

Jan

phocamaps_v3
Joomla! 3.6.5

Hi, which version exactly of the Phoca Maps?

com_phocamaps_v3.0.4
Joomla! 3.6.5

Hi, #__phocamaps_map table includes the column language:
Did you make some upgrade, etc. where the column can be lost?

Jan

Upgraded from Joomla 1.5 then deleted phocamaps then downloaded newest version. Getting same error message on v1.5 and v3.0.4

Did you really install the latest version:
https://www.phoca.cz/download/category/3 ... -component (3.0.4) here, just see the file inside the ZIP:

install/sql/mysql/install.utf8.sql and check the instructions for table phocamaps_map:

Do you see the column language: `language` char(7) NOT NULL default '',?

When you see your database e.g. with phpMyadmin, do you see the column in this table?

Jan

Thanks Jan! I will look for that setting.