Page 1 of 1

500 error after reinstall in multi-language environment

Posted: 30 May 2011, 18:28
by 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

Re: 500 error after reinstall in multi-language environment

Posted: 30 May 2011, 21:35
by klabog
ARRGGH :oops:
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

Re: 500 error after reinstall in multi-language environment

Posted: 01 Jun 2011, 11:12
by 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