500 error after reinstall in multi-language environment

[klabog]

Hi Jan,
after some intents to get guest-book accessible for registered users only in my multi-language environment I get stuck and decided to reinstall. Now I have a real problem - get the following error 500:

Code: Select all

Unknown column 'a.language' in 'on clause' SQL=SELECT a.*,l.title AS language_title,uc.name AS editor FROM `jos_phocaguestbook_books` 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 Unknown column 'a.language' in 'on clause' SQL=SELECT a.*,l.title AS language_title,uc.name AS editor FROM `jos_phocaguestbook_books` 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 Unknown column 'a.language' in 'on clause' SQL=SELECT a.*,l.title AS language_title,uc.name AS editor FROM `jos_phocaguestbook_books` 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 Unknown column 'a.language' in 'on clause' SQL=SELECT a.*,l.title AS language_title,uc.name AS editor FROM `jos_phocaguestbook_books` 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

Do you have a hint how I can repair this? It seems that there wasn't uninstalled part of the database.

Klaus

[klabog]

ARRGGH
My fault - after a new reinstall the error 500 got away and it seems that I clicked on update the last time. I'm not sure but could be a logical reason.
But! Shouldn't there be an error message during the installation when there is nothing to update and you only pushed the wrong button?
Is there a button here to mark the thread solved?

Regards, Klaus

[Jan]

Hi, 500 mean a php error, mostly this is a database + php error, with debug mode enabled, the error will be displayed.

Marked as solved.

Jan