500 - an error has occurred.

[omarelgazzar]

Dear all,
I have installed arabic language package for Joomla 2.5. When I try to access the content in the language manager, I got the following error

Code: Select all

Joomla!
500 - An error has occurred.

Unknown column 'a.access' in 'on clause' SQL=SELECT a.*,ag.title AS access_level,l.home AS home FROM `jos_languages` AS a LEFT JOIN jos_viewlevels AS ag ON ag.id = a.access LEFT JOIN `jos_menu` AS l ON l.language = a.lang_code AND l.home=1 AND l.language <> '*' WHERE (a.published IN (0, 1)) ORDER BY a.title asc Unknown column 'a.access' in 'on clause' SQL=SELECT a.*,ag.title AS access_level,l.home AS home FROM `jos_languages` AS a LEFT JOIN jos_viewlevels AS ag ON ag.id = a.access LEFT JOIN `jos_menu` AS l ON l.language = a.lang_code AND l.home=1 AND l.language <> '*' WHERE (a.published IN (0, 1)) ORDER BY a.title asc LIMIT 0, 20 Unknown column 'a.access' in 'on clause' SQL=SELECT a.*,ag.title AS access_level,l.home AS home FROM `jos_languages` AS a LEFT JOIN jos_viewlevels AS ag ON ag.id = a.access LEFT JOIN `jos_menu` AS l ON l.language = a.lang_code AND l.home=1 AND l.language <> '*' WHERE (a.published IN (0, 1)) ORDER BY a.title asc

Return to Control Panel

What should I do to install arabic language without such error?

Thanks in advance.
Omar

[OrchataLover]

Hi all. I have exactly the same problem. I have three languages installed and I'm trying to install another one. I installed it and didn't have a problem, but then, when I creat a new article the new language doesn't appear in the list of languages to choose. I go to Language-Contents and find exactly the same error than omarelgazzar.

Code: Select all

500 - An error has occurred.
Unknown column 'a.access' in 'on clause' SQL=SELECT a.*,ag.title AS access_level,l.home AS home FROM `nova_languages` AS a LEFT JOIN nova_viewlevels AS ag ON ag.id = a.access LEFT JOIN `nova_menu` AS l ON l.language = a.lang_code AND l.home=1 AND l.language <> '*' WHERE (a.published IN (0, 1)) ORDER BY a.title asc Unknown column 'a.access' in 'on clause' SQL=SELECT a.*,ag.title AS access_level,l.home AS home FROM `nova_languages` AS a LEFT JOIN nova_viewlevels AS ag ON ag.id = a.access LEFT JOIN `nova_menu` AS l ON l.language = a.lang_code AND l.home=1 AND l.language <> '*' WHERE (a.published IN (0, 1)) ORDER BY a.title asc LIMIT 0, 20 Unknown column 'a.access' in 'on clause' SQL=SELECT a.*,ag.title AS access_level,l.home AS home FROM `nova_languages` AS a LEFT JOIN nova_viewlevels AS ag ON ag.id = a.access LEFT JOIN `nova_menu` AS l ON l.language = a.lang_code AND l.home=1 AND l.language <> '*' WHERE (a.published IN (0, 1)) ORDER BY a.title asc

[OrchataLover]

I found it solved:

http://forum.joomla.org/viewtopic.php?f ... 5#p2803655

And worked for me.