Error message on Phoca Maps

[SIG]

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))

[Jan]

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

Jan

[SIG]

phocamaps_v3
Joomla! 3.6.5

[Jan]

Hi, which version exactly of the Phoca Maps?

[SIG]

com_phocamaps_v3.0.4
Joomla! 3.6.5

[Jan]

Hi, #__phocamaps_map table includes the column language:

Code: Select all

CREATE TABLE IF NOT EXISTS `#__phocamaps_map` (
  `id` int(11) NOT NULL auto_increment,
  ...
  `language` char(7) NOT NULL default '',
  PRIMARY KEY  (`id`),
  KEY `cat_idx` (`published`,`access`),
  KEY `idx_access` (`access`),
  KEY `idx_checkout` (`checked_out`)
) CHARACTER SET `utf8`;

Did you make some upgrade, etc. where the column can be lost?

Jan

[SIG]

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

[Jan]

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

[SIG]

Thanks Jan! I will look for that setting.