The Joomla! Forum ™



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.



Post new topic Reply to topic  [ 3 posts ] 
Author Message
PostPosted: Mon Apr 30, 2012 8:53 pm 
Joomla! Apprentice
Joomla! Apprentice

Joined: Sat Mar 31, 2012 11:59 am
Posts: 7
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:
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


Top
 Profile  
 
PostPosted: Tue May 08, 2012 12:34 am 
Joomla! Apprentice
Joomla! Apprentice

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


Top
 Profile  
 
PostPosted: Tue May 08, 2012 12:47 am 
Joomla! Apprentice
Joomla! Apprentice

Joined: Fri Jul 31, 2009 12:03 am
Posts: 5
I found it solved:

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

And worked for me. :)


Top
 Profile  
 
Display posts from previous:  Sort by  
Post new topic Reply to topic  [ 3 posts ] 



Who is online

Users browsing this forum: No registered users and 15 guests


You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot post attachments in this forum

Jump to:  
Powered by phpBB® Forum Software © phpBB Group