Error 500
Posted: 04 Apr 2013, 18:09
I installed Phoca Guestbook successfully, and a language pack. But when I want to manage the guestbook I get this error.
Unknown column 'a.language' in 'on clause' SQL=SELECT a.*,l.title AS language_title,uc.name AS editor FROM `efdb6_phocaguestbook_books` AS a LEFT JOIN `efdb6_languages` AS l ON l.lang_code = a.language LEFT JOIN efdb6_users AS uc ON uc.id=a.checked_out WHERE (a.published IN (0, 1)) ORDER BY a.ordering asc Unknown column 'a.language' in 'on clause' SQL=SELECT a.*,l.title AS language_title,uc.name AS editor FROM `efdb6_phocaguestbook_books` AS a LEFT JOIN `efdb6_languages` AS l ON l.lang_code = a.language LEFT JOIN efdb6_users AS uc ON uc.id=a.checked_out WHERE (a.published IN (0, 1)) ORDER BY a.ordering asc LIMIT 0, 20 Unknown column 'a.language' in 'on clause' SQL=SELECT a.*,l.title AS language_title,uc.name AS editor FROM `efdb6_phocaguestbook_books` AS a LEFT JOIN `efdb6_languages` AS l ON l.lang_code = a.language LEFT JOIN efdb6_users AS uc ON uc.id=a.checked_out WHERE (a.published IN (0, 1)) ORDER BY a.ordering asc
I've tried to uninstall and reinstall the guestbook. It did not help.
Unknown column 'a.language' in 'on clause' SQL=SELECT a.*,l.title AS language_title,uc.name AS editor FROM `efdb6_phocaguestbook_books` AS a LEFT JOIN `efdb6_languages` AS l ON l.lang_code = a.language LEFT JOIN efdb6_users AS uc ON uc.id=a.checked_out WHERE (a.published IN (0, 1)) ORDER BY a.ordering asc Unknown column 'a.language' in 'on clause' SQL=SELECT a.*,l.title AS language_title,uc.name AS editor FROM `efdb6_phocaguestbook_books` AS a LEFT JOIN `efdb6_languages` AS l ON l.lang_code = a.language LEFT JOIN efdb6_users AS uc ON uc.id=a.checked_out WHERE (a.published IN (0, 1)) ORDER BY a.ordering asc LIMIT 0, 20 Unknown column 'a.language' in 'on clause' SQL=SELECT a.*,l.title AS language_title,uc.name AS editor FROM `efdb6_phocaguestbook_books` AS a LEFT JOIN `efdb6_languages` AS l ON l.lang_code = a.language LEFT JOIN efdb6_users AS uc ON uc.id=a.checked_out WHERE (a.published IN (0, 1)) ORDER BY a.ordering asc
I've tried to uninstall and reinstall the guestbook. It did not help.