- Posts: 2
- Thank you received: 0
solved Language change
-
MELRAD
Inactive member -
Topic Author
- New Member
-
Less
More
12 years 3 months ago - 12 years 3 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: 12 years 3 months ago by MELRAD.
Please Log in to join the conversation.
-
ivan.milic
Support Staff -
- Moderator
-
Less
More
- Posts: 14116
- Thank you received: 1639
12 years 3 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.156 seconds