Ошибка Out of sort memory, consider increasing server sort buffer size SQL=SELECT a.id, a.title, a.

Уважаемые коллеги!
Подскажите, пожалуйста, что значит ошибка в joomla, в админке:
"
Ошибка
Out of sort memory, consider increasing server sort buffer size SQL=SELECT a.id, a.title, a.alias, a.checked_out, a.checked_out_time, a.catid, a.state, a.access, a.created, a.created_by, a.created_by_alias, a.ordering, a.featured, a.language, a.hits, a.publish_up, a.publish_down,l.title AS language_title, l.image AS language_image,uc.name AS editor,ag.title AS access_level,c.title AS category_title,ua.name AS author_name,COUNT(asso2.id)>1 as association FROM #__content AS a LEFT JOIN `#__languages` AS l ON l.lang_code = a.language LEFT JOIN #__users AS uc ON uc.id=a.checked_out LEFT JOIN #__viewlevels AS ag ON ag.id = a.access LEFT JOIN #__categories AS c ON c.id = a.catid LEFT JOIN #__users AS ua ON ua.id = a.created_by LEFT JOIN #__associations AS asso ON asso.id = a.id AND asso.context='com_content.item' LEFT JOIN #__associations AS asso2 ON asso2.key = asso.key WHERE (a.state = 0 OR a.state = 1) GROUP BY a.id, l.title, l.image, uc.name, ag.title, c.title, ua.name ORDER BY a.id desc LIMIT 20 Out of sort memory, consider increasing server sort buffer size SQL=SELECT a.id, a.title, a.alias, a.checked_out, a.checked_out_time, a.catid, a.state, a.access, a.created, a.created_by, a.created_by_alias, a.ordering, a.featured, a.language, a.hits, a.publish_up, a.publish_down,l.title AS language_title, l.image AS language_image,uc.name AS editor,ag.title AS access_level,c.title AS category_title,ua.name AS author_name,COUNT(asso2.id)>1 as association FROM #__content AS a LEFT JOIN `#__languages` AS l ON l.lang_code = a.language LEFT JOIN #__users AS uc ON uc.id=a.checked_out LEFT JOIN #__viewlevels AS ag ON ag.id = a.access LEFT JOIN #__categories AS c ON c.id = a.catid LEFT JOIN #__users AS ua ON ua.id = a.created_by LEFT JOIN #__associations AS asso ON asso.id = a.id AND asso.context='com_content.item' LEFT JOIN #__associations AS asso2 ON asso2.key = asso.key WHERE (a.state = 0 OR a.state = 1) GROUP BY a.id, l.title, l.image, uc.name, ag.title, c.title, ua.name ORDER BY a.id desc
Обнаружена ошибка.
Спасибо за помощь. Очень надеюсь на Вашу помощь

 

Здравствуйте!
У меня тоже вышла такая же ошибка в админке в Менеджере модулей.
Помогите исправить. [B][/B]
[B][/B]
Ошибка
Out of sort memory, consider increasing server sort buffer size SQL=SELECT a.id, a.title, a.note, a.position, a.module, a.language,a.checked_out, a.checked_out_time, a.published AS published, e.enabled AS enabled, a.access, a.ordering, a.publish_up, a.publish_down,`l`.`title` AS `language_title`,`l`.`image` AS `language_image`,`uc`.`name` AS `editor`,`ag`.`title` AS `access_level`,MIN(mm.menuid) AS pages,`e`.`name` AS `name` FROM `#__modules` AS `a` LEFT JOIN `#__languages` AS `l` ON `l`.`lang_code` = `a`.`language` LEFT JOIN `#__users` AS `uc` ON `uc`.`id` = `a`.`checked_out` LEFT JOIN `#__viewlevels` AS `ag` ON `ag`.`id` = `a`.`access` LEFT JOIN `#__modules_menu` AS `mm` ON `mm`.`moduleid` = `a`.`id` LEFT JOIN `#__extensions` AS `e` ON `e`.`element` = `a`.`module` WHERE `a`.`client_id` = 0 AND `e`.`client_id` = 0 AND `a`.`published` IN (0, 1) GROUP BY a.id, a.title, a.note, a.position, a.module, a.language, a.checked_out, a.checked_out_time, a.published, a.access, a.ordering, l.title, l.image, uc.name, ag.title, e.name, l.lang_code, uc.id, ag.id, mm.moduleid, e.element, a.publish_up, a.publish_down, e.enabled
Обнаружена ошибка.

 

Ну так draff написал же. У вас не хватает памяти, добавьте, параметр sort_buffer_size

 

Спасибо за подсказку!
Не можете подсказать "чайнику", что это за параметр, где его взять, куда и как вставить?
Так, чтобы пошагово можно было сделать.

 

https://habrahabr.ru/post/108418/

Если на хостинге, пишите хостеру или меняйте его. Если на локалке, поднимите объем памяти через конфиг базы. Не поленитесь погуглить по запросу sort_buffer_size.