miter121
22-04-2016, 15:34
Witam,
Aktualizowałem ostatnio Joomlę i po aktualizacji nie mogę nic zrobić z modułami, bo gdy próbuję wejść w zakłatkę "Moduły" to wyświetla się taki komunikat:
"Błąd Out of sort memory; increase 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 `ezdyf_modules` AS a LEFT JOIN `ezdyf_languages` AS l ON l.lang_code = a.language LEFT JOIN ezdyf_users AS uc ON uc.id=a.checked_out LEFT JOIN ezdyf_viewlevels AS ag ON ag.id = a.access LEFT JOIN ezdyf_modules_menu AS mm ON mm.moduleid = a.id LEFT JOIN ezdyf_extensions AS e ON e.element = a.module WHERE (a.published IN (0, 1)) AND a.client_id = 0 AND e.client_id =0 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
Nieznany błąd"
Nie wiem jak to naprawić, proszę o pomoc.
Aktualizowałem ostatnio Joomlę i po aktualizacji nie mogę nic zrobić z modułami, bo gdy próbuję wejść w zakłatkę "Moduły" to wyświetla się taki komunikat:
"Błąd Out of sort memory; increase 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 `ezdyf_modules` AS a LEFT JOIN `ezdyf_languages` AS l ON l.lang_code = a.language LEFT JOIN ezdyf_users AS uc ON uc.id=a.checked_out LEFT JOIN ezdyf_viewlevels AS ag ON ag.id = a.access LEFT JOIN ezdyf_modules_menu AS mm ON mm.moduleid = a.id LEFT JOIN ezdyf_extensions AS e ON e.element = a.module WHERE (a.published IN (0, 1)) AND a.client_id = 0 AND e.client_id =0 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
Nieznany błąd"
Nie wiem jak to naprawić, proszę o pomoc.