SQL error after J.25 migrate

Phoca Maps - displaying maps in Joomla! CMS
bendict
Phoca Newbie
Phoca Newbie
Posts: 8
Joined: 14 Dec 2010, 22:25

SQL error after J.25 migrate

Post by bendict »

Hi

I've just migrated a client website from J1.5 to J2.5. Unfortunately when updating my Phoca Maps no maps or markers are showing and I get this SQL 500 Error:

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

Any help will be appriciated guys :|

THX for all the great phoca stuff
User avatar
Benno
Phoca Hero
Phoca Hero
Posts: 9440
Joined: 04 Dec 2008, 11:58
Location: Germany
Contact:

Re: SQL error after J.25 migrate

Post by Benno »

Hi,
see: Phoca Maps Migration https://www.phoca.cz/documents/50-phoca/ ... -joomla-25

Kind regards,
Benno
Post Reply