SQL error after J.25 migrate
Posted: 04 Sep 2012, 21:17
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
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