كاربردي نمايش يك مطلب در چند مجموعه با Multicategories سازگار با جوملا
|
۸-۷-۱۳۹۱, ۰۶:۴۵ عصر
ارسال: #16
|
|||
|
|||
RE: نمايش يك مطلب در چند مجموعه با Multicategories سازگار با جوملا 1.5
سلام
من نسخه 2.5 این افزونه رو نصب کردم تو منو کامپوننت قسمت categories این ارور میده -------------------------- 500 - یک خطا رخ داده است کد: (انتخاب همه) Unknown column 'm.aid' in 'field list' SQL=SELECT a.id, a.title, a.alias, a.note, a.published, a.access, a.checked_out, a.checked_out_time, a.created_user_id, a.path, a.parent_id, a.level, a.lft, a.rgt, a.language,l.title AS language_title,uc.name AS editor,ag.title AS access_level,ua.name AS author_name,count(m.aid) AS articles_count FROM j17_categories AS a LEFT JOIN `j17_languages` AS l ON l.lang_code = a.language LEFT JOIN j17_users AS uc ON uc.id=a.checked_out LEFT JOIN j17_viewlevels AS ag ON ag.id = a.access LEFT JOIN j17_users AS ua ON ua.id = a.created_user_id LEFT JOIN `j17_multicategories` AS m ON m.catid = a.id WHERE a.extension = 'com_content' AND (a.published IN (0, 1)) GROUP BY a.id ORDER BY a.lft asc Unknown column 'm.aid' in 'field list' SQL=SELECT a.id, a.title, a.alias, a.note, a.published, a.access, a.checked_out, a.checked_out_time, a.created_user_id, a.path, a.parent_id, a.level, a.lft, a.rgt, a.language,l.title AS language_title,uc.name AS editor,ag.title AS access_level,ua.name AS author_name,count(m.aid) AS articles_count FROM j17_categories AS a LEFT JOIN `j17_languages` AS l ON l.lang_code = a.language LEFT JOIN j17_users AS uc ON uc.id=a.checked_out LEFT JOIN j17_viewlevels AS ag ON ag.id = a.access LEFT JOIN j17_users AS ua ON ua.id = a.created_user_id LEFT JOIN `j17_multicategories` AS m ON m.catid = a.id WHERE a.extension = 'com_content' AND (a.published IN (0, 1)) GROUP BY a.id ORDER BY a.lft asc LIMIT 0, 100 Unknown column 'm.aid' in 'field list' SQL=SELECT a.id, a.title, a.alias, a.note, a.published, a.access, a.checked_out, a.checked_out_time, a.created_user_id, a.path, a.parent_id, a.level, a.lft, a.rgt, a.language,l.title AS language_title,uc.name AS editor,ag.title AS access_level,ua.name AS author_name,count(m.aid) AS articles_count FROM j17_categories AS a LEFT JOIN `j17_languages` AS l ON l.lang_code = a.language LEFT JOIN j17_users AS uc ON uc.id=a.checked_out LEFT JOIN j17_viewlevels AS ag ON ag.id = a.access LEFT JOIN j17_users AS ua ON ua.id = a.created_user_id LEFT JOIN `j17_multicategories` AS m ON m.catid = a.id WHERE a.extension = 'com_content' AND (a.published IN (0, 1)) GROUP BY a.id ORDER BY a.lft asc چطور این مشکل برطرف میشه؟ |
|||
|
|
کاربرانِ درحال بازدید از این موضوع: 1 مهمان