Buszmen
04-03-2017, 08:33
PO instalacji nowej joomli wyskakuje mi pusty komunikat błędu. Jak wchodzę w artykuły to wyskakuje mi błąd
Out of sort memory; increase 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; increase 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
Wystąpił błąd.
Out of sort memory; increase 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; increase 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
Wystąpił błąd.