Error message on Phoca Maps

Phoca Maps - displaying maps in Joomla! CMS
SIG
Phoca Newbie
Phoca Newbie
Posts: 5
Joined: 03 Apr 2017, 23:33

Error message on Phoca Maps

Post by 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))
User avatar
Jan
Phoca Hero
Phoca Hero
Posts: 47810
Joined: 10 Nov 2007, 18:23
Location: Czech Republic
Contact:

Re: Error message on Phoca Maps

Post by Jan »

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

Jan
If you find Phoca extensions useful, please support the project
SIG
Phoca Newbie
Phoca Newbie
Posts: 5
Joined: 03 Apr 2017, 23:33

Re: Error message on Phoca Maps

Post by SIG »

phocamaps_v3
Joomla! 3.6.5
User avatar
Jan
Phoca Hero
Phoca Hero
Posts: 47810
Joined: 10 Nov 2007, 18:23
Location: Czech Republic
Contact:

Re: Error message on Phoca Maps

Post by Jan »

Hi, which version exactly of the Phoca Maps?
If you find Phoca extensions useful, please support the project
SIG
Phoca Newbie
Phoca Newbie
Posts: 5
Joined: 03 Apr 2017, 23:33

Re: Error message on Phoca Maps

Post by SIG »

com_phocamaps_v3.0.4
Joomla! 3.6.5
User avatar
Jan
Phoca Hero
Phoca Hero
Posts: 47810
Joined: 10 Nov 2007, 18:23
Location: Czech Republic
Contact:

Re: Error message on Phoca Maps

Post by 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
If you find Phoca extensions useful, please support the project
SIG
Phoca Newbie
Phoca Newbie
Posts: 5
Joined: 03 Apr 2017, 23:33

Re: Error message on Phoca Maps

Post by SIG »

Upgraded from Joomla 1.5 then deleted phocamaps then downloaded newest version. Getting same error message on v1.5 and v3.0.4
User avatar
Jan
Phoca Hero
Phoca Hero
Posts: 47810
Joined: 10 Nov 2007, 18:23
Location: Czech Republic
Contact:

Re: Error message on Phoca Maps

Post by 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
If you find Phoca extensions useful, please support the project
SIG
Phoca Newbie
Phoca Newbie
Posts: 5
Joined: 03 Apr 2017, 23:33

Re: Error message on Phoca Maps

Post by SIG »

Thanks Jan! I will look for that setting.
Post Reply