- Postagens: 1
- Obrigados Recebidos: 0
AJUDA ERRO 500 MENU. Ja tentei de tudo.
- evertonpellenz
-
Autor do Tópico
- Offline
- JCB! Novato
-
Menos
Mais
12 anos 3 meses atrás #90974
por evertonpellenz
evertonpellenz created the topic: AJUDA ERRO 500 MENU. Ja tentei de tudo.
Ola caros amigos,
Utilizo o template JA_LENS no joomla 2.5.11 e ultimamente obtive o erro 500 quando tento acessar o menu via administrador. As páginas do menu também saíram do ar...
O erro é:
500 - Ocorreu um erro.
Unknown column 'a.ordering' in 'field list' SQL=SELECT a.id, a.menutype, a.title, a.alias, a.note, a.path, a.link, a.type, a.parent_id, a.level, a.published as apublished, a.component_id, a.ordering, a.checked_out, a.checked_out_time, a.browserNav, a.access, a.img, a.template_style_id, a.params, a.lft, a.rgt, a.home, a.language, a.client_id,CASE a.type WHEN 'component' THEN a.published+2*(e.enabled-1) WHEN 'url' THEN a.published+2 WHEN 'alias' THEN a.published+4 WHEN 'separator' THEN a.published+6 END AS published,l.title AS language_title, l.image as image,u.name AS editor,c.element AS componentname,ag.title AS access_level,e.name AS name FROM `gi_menu` AS a LEFT JOIN `gi_languages` AS l ON l.lang_code = a.language LEFT JOIN `gi_users` AS u ON u.id = a.checked_out LEFT JOIN `gi_extensions` AS c ON c.extension_id = a.component_id LEFT JOIN gi_viewlevels AS ag ON ag.id = a.access LEFT JOIN gi_extensions AS e ON e.extension_id = a.component_id WHERE a.id > 1 AND a.client_id = 0 AND a.published = 1 AND a.menutype = 'mainmenu' ORDER BY a.lft asc Unknown column 'a.ordering' in 'field list' SQL=SELECT a.id, a.menutype, a.title, a.alias, a.note, a.path, a.link, a.type, a.parent_id, a.level, a.published as apublished, a.component_id, a.ordering, a.checked_out, a.checked_out_time, a.browserNav, a.access, a.img, a.template_style_id, a.params, a.lft, a.rgt, a.home, a.language, a.client_id,CASE a.type WHEN 'component' THEN a.published+2*(e.enabled-1) WHEN 'url' THEN a.published+2 WHEN 'alias' THEN a.published+4 WHEN 'separator' THEN a.published+6 END AS published,l.title AS language_title, l.image as image,u.name AS editor,c.element AS componentname,ag.title AS access_level,e.name AS name FROM `gi_menu` AS a LEFT JOIN `gi_languages` AS l ON l.lang_code = a.language LEFT JOIN `gi_users` AS u ON u.id = a.checked_out LEFT JOIN `gi_extensions` AS c ON c.extension_id = a.component_id LEFT JOIN gi_viewlevels AS ag ON ag.id = a.access LEFT JOIN gi_extensions AS e ON e.extension_id = a.component_id WHERE a.id > 1 AND a.client_id = 0 AND a.published = 1 AND a.menutype = 'mainmenu' ORDER BY a.lft asc LIMIT 0, 20 Unknown column 'a.ordering' in 'field list' SQL=SELECT a.id, a.menutype, a.title, a.alias, a.note, a.path, a.link, a.type, a.parent_id, a.level, a.published as apublished, a.component_id, a.ordering, a.checked_out, a.checked_out_time, a.browserNav, a.access, a.img, a.template_style_id, a.params, a.lft, a.rgt, a.home, a.language, a.client_id,CASE a.type WHEN 'component' THEN a.published+2*(e.enabled-1) WHEN 'url' THEN a.published+2 WHEN 'alias' THEN a.published+4 WHEN 'separator' THEN a.published+6 END AS published,l.title AS language_title, l.image as image,u.name AS editor,c.element AS componentname,ag.title AS access_level,e.name AS name FROM `gi_menu` AS a LEFT JOIN `gi_languages` AS l ON l.lang_code = a.language LEFT JOIN `gi_users` AS u ON u.id = a.checked_out LEFT JOIN `gi_extensions` AS c ON c.extension_id = a.component_id LEFT JOIN gi_viewlevels AS ag ON ag.id = a.access LEFT JOIN gi_extensions AS e ON e.extension_id = a.component_id WHERE a.id > 1 AND a.client_id = 0 AND a.published = 1 AND a.menutype = 'mainmenu' ORDER BY a.lft asc
Já tentei atualizar o joomla, reparar DB, já tentei de tudo... Alguma luz?
Utilizo o template JA_LENS no joomla 2.5.11 e ultimamente obtive o erro 500 quando tento acessar o menu via administrador. As páginas do menu também saíram do ar...
O erro é:
500 - Ocorreu um erro.
Unknown column 'a.ordering' in 'field list' SQL=SELECT a.id, a.menutype, a.title, a.alias, a.note, a.path, a.link, a.type, a.parent_id, a.level, a.published as apublished, a.component_id, a.ordering, a.checked_out, a.checked_out_time, a.browserNav, a.access, a.img, a.template_style_id, a.params, a.lft, a.rgt, a.home, a.language, a.client_id,CASE a.type WHEN 'component' THEN a.published+2*(e.enabled-1) WHEN 'url' THEN a.published+2 WHEN 'alias' THEN a.published+4 WHEN 'separator' THEN a.published+6 END AS published,l.title AS language_title, l.image as image,u.name AS editor,c.element AS componentname,ag.title AS access_level,e.name AS name FROM `gi_menu` AS a LEFT JOIN `gi_languages` AS l ON l.lang_code = a.language LEFT JOIN `gi_users` AS u ON u.id = a.checked_out LEFT JOIN `gi_extensions` AS c ON c.extension_id = a.component_id LEFT JOIN gi_viewlevels AS ag ON ag.id = a.access LEFT JOIN gi_extensions AS e ON e.extension_id = a.component_id WHERE a.id > 1 AND a.client_id = 0 AND a.published = 1 AND a.menutype = 'mainmenu' ORDER BY a.lft asc Unknown column 'a.ordering' in 'field list' SQL=SELECT a.id, a.menutype, a.title, a.alias, a.note, a.path, a.link, a.type, a.parent_id, a.level, a.published as apublished, a.component_id, a.ordering, a.checked_out, a.checked_out_time, a.browserNav, a.access, a.img, a.template_style_id, a.params, a.lft, a.rgt, a.home, a.language, a.client_id,CASE a.type WHEN 'component' THEN a.published+2*(e.enabled-1) WHEN 'url' THEN a.published+2 WHEN 'alias' THEN a.published+4 WHEN 'separator' THEN a.published+6 END AS published,l.title AS language_title, l.image as image,u.name AS editor,c.element AS componentname,ag.title AS access_level,e.name AS name FROM `gi_menu` AS a LEFT JOIN `gi_languages` AS l ON l.lang_code = a.language LEFT JOIN `gi_users` AS u ON u.id = a.checked_out LEFT JOIN `gi_extensions` AS c ON c.extension_id = a.component_id LEFT JOIN gi_viewlevels AS ag ON ag.id = a.access LEFT JOIN gi_extensions AS e ON e.extension_id = a.component_id WHERE a.id > 1 AND a.client_id = 0 AND a.published = 1 AND a.menutype = 'mainmenu' ORDER BY a.lft asc LIMIT 0, 20 Unknown column 'a.ordering' in 'field list' SQL=SELECT a.id, a.menutype, a.title, a.alias, a.note, a.path, a.link, a.type, a.parent_id, a.level, a.published as apublished, a.component_id, a.ordering, a.checked_out, a.checked_out_time, a.browserNav, a.access, a.img, a.template_style_id, a.params, a.lft, a.rgt, a.home, a.language, a.client_id,CASE a.type WHEN 'component' THEN a.published+2*(e.enabled-1) WHEN 'url' THEN a.published+2 WHEN 'alias' THEN a.published+4 WHEN 'separator' THEN a.published+6 END AS published,l.title AS language_title, l.image as image,u.name AS editor,c.element AS componentname,ag.title AS access_level,e.name AS name FROM `gi_menu` AS a LEFT JOIN `gi_languages` AS l ON l.lang_code = a.language LEFT JOIN `gi_users` AS u ON u.id = a.checked_out LEFT JOIN `gi_extensions` AS c ON c.extension_id = a.component_id LEFT JOIN gi_viewlevels AS ag ON ag.id = a.access LEFT JOIN gi_extensions AS e ON e.extension_id = a.component_id WHERE a.id > 1 AND a.client_id = 0 AND a.published = 1 AND a.menutype = 'mainmenu' ORDER BY a.lft asc
Já tentei atualizar o joomla, reparar DB, já tentei de tudo... Alguma luz?
Please Entrar ou Registrar to join the conversation.
- Aureo
-
- Offline
- JCB! Legend
-