Phocamaps control panel

Phoca Maps - displaying maps in Joomla! CMS
myronlee
Phoca Newbie
Phoca Newbie
Posts: 2
Joined: 14 Jan 2014, 12:49

Phocamaps control panel

Post by myronlee »

Hi, I just installed on 2.5.17m inside map panel whenever i click on Maps, Markers, Icons I get this database message.

Table 'urb1400907545359.jos_phocamaps_map' doesn't exist SQL=SELECT a.*,l.title AS language_title,uc.name AS editor FROM `jos_phocamaps_map` AS a LEFT JOIN `jos_languages` AS l ON l.lang_code = a.language LEFT JOIN jos_users AS uc ON uc.id=a.checked_out WHERE (a.published IN (0, 1)) ORDER BY a.ordering asc Table 'urb1400907545359.jos_phocamaps_map' doesn't exist SQL=SELECT a.*,l.title AS language_title,uc.name AS editor FROM `jos_phocamaps_map` AS a LEFT JOIN `jos_languages` AS l ON l.lang_code = a.language LEFT JOIN jos_users AS uc ON uc.id=a.checked_out WHERE (a.published IN (0, 1)) ORDER BY a.ordering asc LIMIT 0, 100 Table 'urb1400907545359.jos_phocamaps_map' doesn't exist SQL=SELECT a.*,l.title AS language_title,uc.name AS editor FROM `jos_phocamaps_map` AS a LEFT JOIN `jos_languages` AS l ON l.lang_code = a.language LEFT JOIN jos_users AS uc ON uc.id=a.checked_out WHERE (a.published IN (0, 1)) ORDER BY a.ordering asc

Thank you
User avatar
Benno
Phoca Hero
Phoca Hero
Posts: 9440
Joined: 04 Dec 2008, 11:58
Location: Germany
Contact:

Re: Phocamaps control panel

Post by Benno »

Hi,
jos_phocamaps_map' doesn't exist
means, this table was not created during installation process.

But you can install this table manually:
1. Download http://joomlacode.org/gf/download/frsre ... v2.0.6.zip
2. Unzip this package local on your pc.
3. You will find the file install.bak.sql in the root directory.
4. Open this file with an Editor like e.g. Notepad ++
5. In this file you find all queries to create all Phoca Maps tables.
6. Create the missing table(s) manually with help of phpMyAdmin.

Kind regards,
Benno
myronlee
Phoca Newbie
Phoca Newbie
Posts: 2
Joined: 14 Jan 2014, 12:49

Re: Phocamaps control panel

Post by myronlee »

Thank you very much, you gave me the idea to re-install and that worked.
User avatar
Benno
Phoca Hero
Phoca Hero
Posts: 9440
Joined: 04 Dec 2008, 11:58
Location: Germany
Contact:

Re: Phocamaps control panel

Post by Benno »

You're welcome!

Kind regards,
Benno
Post Reply