Joomla 2.5 500 - Обнаружена ошибка.

Discussion in 'Ошибки при работе с Joomla' started by Fokintof, Sep 16, 2014.

  1. Offline

    Fokintof Недавно здесь

    Joined:
    Sep 10, 2014
    Messages:
    14
    Likes Received:
    0
    Gender:
    Male
    При заходе в Меню-Менеджер меню после выбора одного любого из пунктов меню перекидывает на ошибку:

    500 - Обнаружена ошибка.
    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 `geat9_menu` AS a LEFT JOIN `geat9_languages` AS l ON l.lang_code = a.language LEFT JOIN `geat9_users` AS u ON u.id = a.checked_out LEFT JOIN `geat9_extensions` AS c ON c.extension_id = a.component_id LEFT JOIN geat9_viewlevels AS ag ON ag.id = a.access LEFT JOIN geat9_extensions AS e ON e.extension_id = a.component_id WHERE a.id > 1 AND a.client_id = 0 AND (a.published IN (0, 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 `geat9_menu` AS a LEFT JOIN `geat9_languages` AS l ON l.lang_code = a.language LEFT JOIN `geat9_users` AS u ON u.id = a.checked_out LEFT JOIN `geat9_extensions` AS c ON c.extension_id = a.component_id LEFT JOIN geat9_viewlevels AS ag ON ag.id = a.access LEFT JOIN geat9_extensions AS e ON e.extension_id = a.component_id WHERE a.id > 1 AND a.client_id = 0 AND (a.published IN (0, 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 `geat9_menu` AS a LEFT JOIN `geat9_languages` AS l ON l.lang_code = a.language LEFT JOIN `geat9_users` AS u ON u.id = a.checked_out LEFT JOIN `geat9_extensions` AS c ON c.extension_id = a.component_id LEFT JOIN geat9_viewlevels AS ag ON ag.id = a.access LEFT JOIN geat9_extensions AS e ON e.extension_id = a.component_id WHERE a.id > 1 AND a.client_id = 0 AND (a.published IN (0, 1)) AND a.menutype = 'mainmenu' ORDER BY a.lft asc

    Какая то огромная ошибка, где, что посмотреть?

    Спасибо.
     
  2.  
  3. OlegM
    Offline

    OlegM Russian Joomla! Team Staff Member

    Joined:
    Apr 12, 2007
    Messages:
    4,310
    Likes Received:
    375
    Gender:
    Male
    Менеджер расширений - База данных -- проверить отсутствие ошибок. Если есть - исправить.
     
  4. Offline

    Fokintof Недавно здесь

    Joined:
    Sep 10, 2014
    Messages:
    14
    Likes Received:
    0
    Gender:
    Male
    Структура таблиц базы данных в актуальном состоянии.

    Другая информация
    • Версия схемы базы данных (из #__schemas): 2.5.24.
    • Версия обновления (из #__extensions): 2.5.24.
    • Драйвер БД: mysqli.
    • 66 изменений базы данных были успешно проверены.
    • 45 изменений базы данных не изменили структуру таблиц и были пропущены.
     
  5. OlegM
    Offline

    OlegM Russian Joomla! Team Staff Member

    Joined:
    Apr 12, 2007
    Messages:
    4,310
    Likes Received:
    375
    Gender:
    Male
    А ошибка после чего появилась?
     

Share This Page

Loading...