- Posts: 2
- Thank you received: 0
solved Language change
-
MELRAD
Inactive member - Topic Author
- New Member
Less
More
11 years 11 months ago - 11 years 11 months ago #24161
by MELRAD
solved Language change was created by MELRAD
Hello all.
I have changed language in the template. And i have this error message.
If anyone know the solution. Thank you for reply.
Sorry for my bad english.
Cordialement
Unknown column 'a.access' in 'on clause' SQL=SELECT a.*,ag.title AS access_level,l.home AS home FROM `vksup_languages` AS a LEFT JOIN vksup_viewlevels AS ag ON ag.id = a.access LEFT JOIN `vksup_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 `vksup_languages` AS a LEFT JOIN vksup_viewlevels AS ag ON ag.id = a.access LEFT JOIN `vksup_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 `vksup_languages` AS a LEFT JOIN vksup_viewlevels AS ag ON ag.id = a.access LEFT JOIN `vksup_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
I have changed language in the template. And i have this error message.
If anyone know the solution. Thank you for reply.
Sorry for my bad english.
Cordialement
Unknown column 'a.access' in 'on clause' SQL=SELECT a.*,ag.title AS access_level,l.home AS home FROM `vksup_languages` AS a LEFT JOIN vksup_viewlevels AS ag ON ag.id = a.access LEFT JOIN `vksup_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 `vksup_languages` AS a LEFT JOIN vksup_viewlevels AS ag ON ag.id = a.access LEFT JOIN `vksup_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 `vksup_languages` AS a LEFT JOIN vksup_viewlevels AS ag ON ag.id = a.access LEFT JOIN `vksup_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
Last edit: 11 years 11 months ago by MELRAD.
Please Log in to join the conversation.
-
ivan.milic
Support Staff - Moderator
Less
More
- Posts: 14116
- Thank you received: 1639
11 years 11 months ago #24164
by ivan.milic
Replied by ivan.milic on topic Language change
Go to extension manager, under Database tab if you see some button or link saying something like "repair database" click on it.
The following user(s) said Thank You: MELRAD
Please Log in to join the conversation.
Time to create page: 0.158 seconds