Page 1 of 1

Phocamaps control panel

Posted: 14 Jan 2014, 12:55
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

Re: Phocamaps control panel

Posted: 14 Jan 2014, 17:56
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

Re: Phocamaps control panel

Posted: 15 Jan 2014, 00:21
by myronlee
Thank you very much, you gave me the idea to re-install and that worked.

Re: Phocamaps control panel

Posted: 15 Jan 2014, 17:11
by Benno
You're welcome!

Kind regards,
Benno