SOLVED!Problem installing new language

  • migliosj
    Inactive member
  • Topic Author
  • New Member
  • New Member
More
11 years 9 months ago - 11 years 8 months ago #27534 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
Last edit: 11 years 8 months ago by migliosj.

Please Log in to join the conversation.

More
11 years 9 months ago #27552 by ivan.milic
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
  • New Member
More
11 years 9 months ago #27555 by migliosj

ivan.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

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 Italian

Please Log in to join the conversation.

More
11 years 9 months ago #27557 by ivan.milic
Do you have it defined in language manager?

Please Log in to join the conversation.

  • migliosj
    Inactive member
  • Topic Author
  • New Member
  • New Member
More
11 years 9 months ago - 11 years 9 months ago #27561 by migliosj
I attached my screenshot so I can explain

better, thanks
Last edit: 11 years 9 months ago by migliosj.

Please Log in to join the conversation.

More
11 years 9 months ago #27572 by ivan.milic
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
Powered by Kunena Forum