500 - an error has occurred.

Everything to do with Joomla! 2.5 templates and templating.

Moderator: General Support Moderators

Forum rules
Forum Rules
Absolute Beginner's Guide to Joomla! <-- please read before posting, this means YOU.
Forum Post Assistant - If you are serious about wanting help, you will use this tool to help you post.
omarelgazzar
Joomla! Apprentice
Joomla! Apprentice
Posts: 7
Joined: Sat Mar 31, 2012 11:59 am

500 - an error has occurred.

Postby omarelgazzar » Mon Apr 30, 2012 8:53 pm

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
Joomla! Apprentice
Joomla! Apprentice
Posts: 5
Joined: Fri Jul 31, 2009 12:03 am

Re: 500 - an error has occurred.

Postby OrchataLover » Tue May 08, 2012 12:34 am

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
Joomla! Apprentice
Joomla! Apprentice
Posts: 5
Joined: Fri Jul 31, 2009 12:03 am

Re: 500 - an error has occurred.

Postby OrchataLover » Tue May 08, 2012 12:47 am

I found it solved:

viewtopic.php?f=617&t=711911&p=2803655#p2803655

And worked for me. :)


Return to “Templates for Joomla! 2.5”

Who is online

Users browsing this forum: No registered users and 5 guests