بخش تمامی مطالب ومحتوا در مدیریت
سلام
متاسفانه وارد این بخش نمی شه و این پیغام را میده
DB function failed with error number 1054
Unknown column 'c.access' in 'on clause' SQL=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 FROM mos_content AS c, mos_categories AS cc, mos_sections AS s LEFT JOIN mos_groups AS g ON g.id = c.access LEFT JOIN mos_users AS u ON u.id = c.checked_out LEFT JOIN mos_users AS v ON v.id = c.created_by LEFT JOIN mos_content_frontpage AS f ON f.content_id = c.id WHERE c.state >= 0 AND c.catid=cc.id AND cc.section=s.id AND s.scope='content' ORDER BY s.title, c.catid, cc.ordering, cc.title, c.ordering LIMIT 0,10
پاسخ : بخش تمامی مطالب ومحتوا در مدیریت
شما از چه ورژنی استفاده میکنید؟
به ورژن 4.5.4 ارتقا بدید مشکلتون حل میشه!
پاسخ : بخش تمامی مطالب ومحتوا در مدیریت
موقع نصب ورژن 4.5.4 هم این پیغام را میده
Zend Optimizer not installed
This file was encoded by the Zend Encoder / Zend SafeGuard Suite
In order to run it, please install the freely available Zend Optimizer, version 2.1.0 or later.
What is the Zend Optimizer?
The Zend Optimizer is one of the most popular PHP plugins for performance-improvement, and has been freely available since the early days of PHP 4. It improves performance by taking PHP's intermediate code through multiple Optimization Passes, which replace inefficient code patterns with efficient code blocks. The replacement code blocks perform exactly the same operations as the original code, only faster.
In addition to performance-improvement, the Zend Optimizer also enables PHP to transparently load files encoded by the Zend Encoder or Zend SafeGuard Suite.
The Zend Optimizer is a freely-available product from Zend Technologies. Zend Technologies is the company that develops the scripting engine of PHP, also known as the Zend Engine.
پاسخ : بخش تمامی مطالب ومحتوا در مدیریت
دوست من
هر دو سوال شما بارها در انجمن پرسيده شده بود كه با يك جستجو ميتونستيد به جواب اونها برسيد .
در مورد سوال دوم شما :
اين موضوع كاملا مشخص هست :
Zend Optimizer not installed
روي سرور شما Zend Optimizer نصب نيست . بايد با پشتيباني هاستتون در اين رابطه صحبت كنيد
يا علي
پاسخ : بخش تمامی مطالب ومحتوا در مدیریت
اگه می خوای از همون ورژن اول استفاده کنی تو این فایل 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"
;
مشکل من که اینجوری حل شد.
فکر کنم به خاطر اختلاف ورژن مای اس کیو ال باشه....
من ازینجا پیداشکردم پیداش کردم
[مهمان/کاربر گرامی برای دیدن لینک ها ابتدا باید عضو سایت شوید و لاگین کنید برای ثبت نام اینجا کلیک کنید]