بخش تمامی مطالب ومحتوا در مدیریت

[abnormind]

اگه می خوای از همون ورژن اول استفاده کنی تو این فایل admin.content.php

این کوئری رو

$query = "SELECT c.*, g.name AS groupname, cc.name, u.name AS editor, f.content_id AS frontpage, s.title AS section_name, v.name AS author"
. "\n FROM #__content AS c, #__categories AS cc, #__sections AS s"
. "\n LEFT JOIN #__groups AS g ON g.id = c.access"
. "\n LEFT JOIN #__users AS u ON u.id = c.checked_out"
. "\n LEFT JOIN #__users AS v ON v.id = c.created_by"
. "\n LEFT JOIN #__content_frontpage AS f ON f.content_id = c.id"
. ( count( $where ) ? "\nWHERE " . implode( ' AND ', $where ) : '' )
. $order
. "\n LIMIT $pageNav->limitstart,$pageNav->limit"
;

با این یکی عوض کن

$query = "SELECT c.*, g.name AS groupname, cc.name, u.name AS editor, f.content_id AS frontpage, s.title AS section_name, v.name AS author"
. "\n FROM #__content AS c" //, #__categories AS cc, #__sections AS s"
. "\n LEFT JOIN #__groups AS g ON g.id = c.access"
. "\n LEFT JOIN #__users AS u ON u.id = c.checked_out"
. "\n LEFT JOIN #__users AS v ON v.id = c.created_by"
. "\n LEFT JOIN #__content_frontpage AS f ON f.content_id = c.id"
. "\n LEFT OUTER JOIN #__categories AS cc ON c.catid=cc.id"
. "\n LEFT OUTER JOIN #__sections AS s ON cc.section=s.id"
. ( count( $where ) ? "\nWHERE " . implode( ' AND ', $where ) : '' )
. $order
. "\n LIMIT $pageNav->limitstart,$pageNav->limit"
;

مشکل من که اینجوری حل شد.
فکر کنم به خاطر اختلاف ورژن مای اس کیو ال باشه....

من ازینجا پیداشکردم پیداش کردم


[مهمان/کاربر گرامی برای دیدن لینک ها ابتدا باید عضو سایت شوید و لاگین کنید برای ثبت نام اینجا کلیک کنید]