yoogii
28-09-2008, 23:10
Przy próbie wejścia w kategorię np. Reklama -> kategorie, Kontakty -> kategorie wyskakuje następujący komunikat błędu:
DB function failed with error number 1054
Nieznana kolumna 'section_name' w order clause SQL=SELECT c.*, c.checked_out as checked_out_contact_category, g.name AS groupname, u.name AS editor, COUNT( DISTINCT s2.checked_out ) AS checked_out_count FROM jos_categories AS c LEFT JOIN jos_users AS u ON u.id = c.checked_out LEFT JOIN jos_groups AS g ON g.id = c.access LEFT JOIN jos_contact_details AS s2 ON s2.catid = c.id AND s2.checked_out > 0 WHERE c.section = 'com_contact_details' AND c.published != -2 GROUP BY c.id ORDER BY section_name desc, c.ordering LIMIT 0, 20
Jak można to naprawić?
DB function failed with error number 1054
Nieznana kolumna 'section_name' w order clause SQL=SELECT c.*, c.checked_out as checked_out_contact_category, g.name AS groupname, u.name AS editor, COUNT( DISTINCT s2.checked_out ) AS checked_out_count FROM jos_categories AS c LEFT JOIN jos_users AS u ON u.id = c.checked_out LEFT JOIN jos_groups AS g ON g.id = c.access LEFT JOIN jos_contact_details AS s2 ON s2.catid = c.id AND s2.checked_out > 0 WHERE c.section = 'com_contact_details' AND c.published != -2 GROUP BY c.id ORDER BY section_name desc, c.ordering LIMIT 0, 20
Jak można to naprawić?