- Posts: 6
- Thank you received: 0
SOLVED!Problem installing new language
-
migliosj
Inactive member - Topic Author
- New Member
Less
More
11 years 9 months ago - 11 years 8 months ago #27534
by migliosj
SOLVED!Problem installing new language was created by migliosj
hello, I downloaded some days ago this template, I saw that is only in English, so I installed Italian language. Admin control panel changed from Englis to Italian without problem, but when I click on language management and after on language contents I have this problem:
"500 - Si è verificato un errore.
Unknown column 'a.access' in 'on clause' SQL=SELECT a.*,ag.title AS access_level,l.home AS home FROM `wnc09_languages` AS a LEFT JOIN wnc09_viewlevels AS ag ON ag.id = a.access LEFT JOIN `wnc09_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 `wnc09_languages` AS a LEFT JOIN wnc09_viewlevels AS ag ON ag.id = a.access LEFT JOIN `wnc09_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 `wnc09_languages` AS a LEFT JOIN wnc09_viewlevels AS ag ON ag.id = a.access LEFT JOIN `wnc09_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"
How can I fix it? Have I to do another method to install another language? Can you help me, please? thanks in advance
"500 - Si è verificato un errore.
Unknown column 'a.access' in 'on clause' SQL=SELECT a.*,ag.title AS access_level,l.home AS home FROM `wnc09_languages` AS a LEFT JOIN wnc09_viewlevels AS ag ON ag.id = a.access LEFT JOIN `wnc09_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 `wnc09_languages` AS a LEFT JOIN wnc09_viewlevels AS ag ON ag.id = a.access LEFT JOIN `wnc09_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 `wnc09_languages` AS a LEFT JOIN wnc09_viewlevels AS ag ON ag.id = a.access LEFT JOIN `wnc09_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"
How can I fix it? Have I to do another method to install another language? Can you help me, please? thanks in advance
Last edit: 11 years 8 months ago by migliosj.
Please Log in to join the conversation.
-
ivan.milic
Support Staff - Moderator
Less
More
- Posts: 14116
- Thank you received: 1639
11 years 9 months ago #27552
by ivan.milic
Replied by ivan.milic on topic Problem installing new language
Do to Extension Manager "Database" tab and check is there any button saying something like "click here to fix database" if yes click on it
Please Log in to join the conversation.
-
migliosj
Inactive member - Topic Author
- New Member
Less
More
- Posts: 6
- Thank you received: 0
11 years 9 months ago #27555
by migliosj
Replied by migliosj on topic Problem installing new language
Thank you, now there is no longer that error. I clicked on contents language and I read English, while in Installed Site there are both English and Italian. I tried to write a new article and I can select only English or All Languages but not Italianivan.milic wrote: Do to Extension Manager "Database" tab and check is there any button saying something like "click here to fix database" if yes click on it
Please Log in to join the conversation.
-
ivan.milic
Support Staff - Moderator
Less
More
- Posts: 14116
- Thank you received: 1639
11 years 9 months ago #27557
by ivan.milic
Replied by ivan.milic on topic Problem installing new language
Do you have it defined in language manager?
Please Log in to join the conversation.
-
migliosj
Inactive member - Topic Author
- New Member
Less
More
- Posts: 6
- Thank you received: 0
-
ivan.milic
Support Staff - Moderator
Less
More
- Posts: 14116
- Thank you received: 1639
11 years 9 months ago #27572
by ivan.milic
Replied by ivan.milic on topic Problem installing new language
There is no attachment. Make sure posted images are less that 400kb, use jpg format and re-size image .
Please Log in to join the conversation.
Time to create page: 0.152 seconds