مشکل فوری. ارورهای فراوان در صفحه اصلی و قادر نبودن به تغییر دادن نوع گزارش خطا به هی

[specialagent 10]

سلام. این دومین بار که این مشکل برای من پیش میاد. که بدون نصب هیچ گونه افزونه ای سایت بی خودی دچار این مشکل میشه.

گزارش خطای سایت من در تنظیمات کلی جوملا بر نوع پیش فرض هستش و هر کاری می کنم نمی تونم بکنمش به (هیچ). یعنی اصلا تنظیمات کلی و سایر تنظیمات بخش مدیریت جوملا اصلا ذخیره نمیشه و این دو تا ارور رو میده

نمیتواند تاریخ را ذخیره کند خطا: تنظیمات کلی مشکل دارد، ذخیره متن فیلتر با مشکل مواجه شد.

Warning: Invalid argument supplied for foreach() in /home/cknlyccj/public_html/administrator/modules/mod_menu/tmpl/default_enabled.php on line 186

صفحه اصلی سایتم مشکلی نداشت الآن که بهش سر زدم این ارورها رو میده با کلی چیزای دیگه. سایر مطالب سایت بعضی هاشون بز میشن بعضی هاشون ارور 404 میدن

Warning: Invalid argument supplied for foreach() in /home/cknkkccj/public_html/components/com_content/models/articles.php on line 488

Warning: mysqli_num_rows() expects parameter 1 to be mysqli_result, boolean given in /home/cknkkccj/public_html/libraries/joomla/database/database/mysqli.php on line 263

لطفا فوری کمک کنید ممنون

[حجت مردانه زاده 596]

با سلام

به هاستتون برید و فایل configuration.php رو باز کنید .در این فایل دنبال تابع error reporting باشید در مقابلش ، مقدار "0" رو قرار بدید...

اگر باز هم ارور داشتید، در اینجا قرار بدید.

ضمناً مثل اینکه نوع دیتابیس هم اشتباه وارد شده!! داخل همون فایل مقدارش رو مثل زیر تغییر بدید.

    public $dbtype = 'mysql';

احتمالا الان برای شما به این صورت در اومده باشه!

 public $dbtype = 'mysqli';

موفق باشید و س ربلند یا حق

[specialagent 10]

ممنون

با code editor فایل config رو باز کردم و نوع پایگاه داده رو به mysql تغییر دادم و مقدار ارور رو هم کردم صفر.

یک سری از ارورها حذف شد . ولی وقتی به تنظیمات کلی سایتم میرم نوع پایگاه داده تغییر کرده اما گزارش خطا همچنان بر روی پیش فرض هستش و وقتی میخوام توش تغییر بدم و ذخیره کنم هنوز این ارور رو میده

و نمی ذاره ذخیره کنم و این ارور رو میده :

نمیتواند تاریخ را ذخیره کند خطا: تنظیمات کلی مشکل دارد، ذخیره متن فیلتر با مشکل مواجه شد.

دسترسی فایل کانفیگ روی 444 هستش الآن

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

Got error 28 from storage engine SQL=SELECT a.id, a.title, a.alias, a.title_alias, a.introtext, a.checked_out, a.checked_out_time, a.catid, a.created, a.created_by, a.created_by_alias, CASE WHEN a.modified = 0 THEN a.created ELSE a.modified END as modified, a.modified_by, uam.name as modified_by_name,CASE WHEN a.publish_up = 0 THEN a.created ELSE a.publish_up END as publish_up,a.publish_down, a.images, a.urls, a.attribs, a.metadata, a.metakey, a.metadesc, a.access, a.hits, a.xreference, a.featured, LENGTH(a.fulltext) AS readmore,CASE WHEN badcats.id is not null THEN 0 ELSE a.state END AS state,c.title AS category_title, c.path AS category_route, c.access AS category_access, c.alias AS category_alias,CASE WHEN a.created_by_alias > ' ' THEN a.created_by_alias ELSE ua.name END AS author,ua.email AS author_email,contact.id as contactid,parent.title as parent_title, parent.id as parent_id, parent.path as parent_route, parent.alias as parent_alias,ROUND(v.rating_sum / v.rating_count, 0) AS rating, v.rating_count as rating_count,c.published, CASE WHEN badcats.id is null THEN c.published ELSE 0 END AS parents_published FROM b7bck_content AS a LEFT JOIN b7bck_categories AS c ON c.id = a.catid LEFT JOIN b7bck_users AS ua ON ua.id = a.created_by LEFT JOIN b7bck_users AS uam ON uam.id = a.modified_by LEFT JOIN ( SELECT contact.user_id, MAX(contact.id) AS id, contact.language FROM b7bck_contact_details AS contact WHERE contact.published = 1 GROUP BY contact.user_id, contact.language) AS contact ON contact.user_id = a.created_by LEFT JOIN b7bck_categories as parent ON parent.id = c.parent_id LEFT JOIN b7bck_content_rating AS v ON a.id = v.content_id LEFT OUTER JOIN (SELECT cat.id as id FROM b7bck_categories AS cat JOIN b7bck_categories AS parent ON cat.lft BETWEEN parent.lft AND parent.rgt WHERE parent.extension = 'com_content' AND parent.published != 1 GROUP BY cat.id ) AS badcats ON badcats.id = c.id INNER JOIN b7bck_content_frontpage AS fp ON fp.content_id = a.id WHERE a.access IN (1,1) AND CASE WHEN badcats.id is null THEN a.state ELSE 0 END = 1 AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2012-09-26 05:27:20') AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2012-09-26 05:27:20') AND a.catid IN (17,18,19,20,21,23,24,25,26,22,27,28,29,30,31,32,33,34,35,36,37,38,39,40,41,42,43,44,45,47,48,49,50,51,56,57,58,59,52,60,61,62,63,53,54,64,65,55,66,67,68,69,70,71,72,74) GROUP BY a.id, a.title, a.alias, a.title_alias, a.introtext, a.checked_out, a.checked_out_time, a.catid, a.created, a.created_by, a.created_by_alias, a.created, a.modified, a.modified_by, uam.name, a.publish_up, a.attribs, a.metadata, a.metakey, a.metadesc, a.access, a.hits, a.xreference, a.featured, a.fulltext, a.state, a.publish_down, badcats.id, c.title, c.path, c.access, c.alias, uam.id, ua.name, ua.email, contact.id, parent.title, parent.id, parent.path, parent.alias, v.rating_sum, v.rating_count, c.published, c.lft, a.ordering, parent.lft, fp.ordering, c.id, a.images, a.urls ORDER BY a.created DESC , a.created DESC LIMIT 0, 16 Got error 28 from storage engine SQL=SELECT a.id, a.title, a.alias, a.title_alias, a.introtext, a.checked_out, a.checked_out_time, a.catid, a.created, a.created_by, a.created_by_alias, CASE WHEN a.modified = 0 THEN a.created ELSE a.modified END as modified, a.modified_by, uam.name as modified_by_name,CASE WHEN a.publish_up = 0 THEN a.created ELSE a.publish_up END as publish_up,a.publish_down, a.images, a.urls, a.attribs, a.metadata, a.metakey, a.metadesc, a.access, a.hits, a.xreference, a.featured, LENGTH(a.fulltext) AS readmore,CASE WHEN badcats.id is not null THEN 0 ELSE a.state END AS state,c.title AS category_title, c.path AS category_route, c.access AS category_access, c.alias AS category_alias,CASE WHEN a.created_by_alias > ' ' THEN a.created_by_alias ELSE ua.name END AS author,ua.email AS author_email,contact.id as contactid,parent.title as parent_title, parent.id as parent_id, parent.path as parent_route, parent.alias as parent_alias,ROUND(v.rating_sum / v.rating_count, 0) AS rating, v.rating_count as rating_count,c.published, CASE WHEN badcats.id is null THEN c.published ELSE 0 END AS parents_published FROM b7bck_content AS a LEFT JOIN b7bck_categories AS c ON c.id = a.catid LEFT JOIN b7bck_users AS ua ON ua.id = a.created_by LEFT JOIN b7bck_users AS uam ON uam.id = a.modified_by LEFT JOIN ( SELECT contact.user_id, MAX(contact.id) AS id, contact.language FROM b7bck_contact_details AS contact WHERE contact.published = 1 GROUP BY contact.user_id, contact.language) AS contact ON contact.user_id = a.created_by LEFT JOIN b7bck_categories as parent ON parent.id = c.parent_id LEFT JOIN b7bck_content_rating AS v ON a.id = v.content_id LEFT OUTER JOIN (SELECT cat.id as id FROM b7bck_categories AS cat JOIN b7bck_categories AS parent ON cat.lft BETWEEN parent.lft AND parent.rgt WHERE parent.extension = 'com_content' AND parent.published != 1 GROUP BY cat.id ) AS badcats ON badcats.id = c.id INNER JOIN b7bck_content_frontpage AS fp ON fp.content_id = a.id WHERE a.access IN (1,1) AND CASE WHEN badcats.id is null THEN a.state ELSE 0 END = 1 AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2012-09-26 05:27:20') AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2012-09-26 05:27:20') AND a.catid IN (17,18,19,20,21,23,24,25,26,22,27,28,29,30,31,32,33,34,35,36,37,38,39,40,41,42,43,44,45,47,48,49,50,51,56,57,58,59,52,60,61,62,63,53,54,64,65,55,66,67,68,69,70,71,72,74) GROUP BY a.id, a.title, a.alias, a.title_alias, a.introtext, a.checked_out, a.checked_out_time, a.catid, a.created, a.created_by, a.created_by_alias, a.created, a.modified, a.modified_by, uam.name, a.publish_up, a.attribs, a.metadata, a.metakey, a.metadesc, a.access, a.hits, a.xreference, a.featured, a.fulltext, a.state, a.publish_down, badcats.id, c.title, c.path, c.access, c.alias, uam.id, ua.name, ua.email, contact.id, parent.title, parent.id, parent.path, parent.alias, v.rating_sum, v.rating_count, c.published, c.lft, a.ordering, parent.lft, fp.ordering, c.id, a.images, a.urls ORDER BY a.created DESC , a.created DESC

[specialagent 10]

از همون فایل config سایت رو در حالت آفلاین قرار دادم که آفلاین کرد سایت رو ولی اون ارور عریض و طویل انگلیسی که در بالا گذاشتم هنوز در صفحه آفلاین هم هستش

[حجت مردانه زاده 596]

قبل از هرکار دیگری، از دیتابیستون یک بکآپ بگیرید. بعد برید کل دیتابیستون رو Repair کنین.ببنید بازم ارور میده یا نه...

[specialagent 10]

باز هم ممنون

با تعمیر کردن دیتابیشس یه سری دیگه از مشکلات هم رفع شد

فعلا سرور سایت در حال تعمیر هست. و دسترسی به سایت ندارم.

نتیجه رو بهتون گزارش می دم

خیلی ممنون

[specialagent 10]

فوق العاده سپاس گذارم

مشکلات کاملا حل شد.

موفق باشید

[حجت مردانه زاده 596]

خواهش میکنم.

برای تشکر نیازی به ارسال پست نیست .از دکمه تشکر استفاده کنید....

موفق و سربلند و پایدار باشید

یا حق

[shell7x 10]

سلام مهندس خسته نباشید

من روی سایتم ارور زیر دارم فقط در قسمت مطالب هیچی دیده نمیشه ... بکاپ دیتابیس رو داشتم ری استور کردم از سی پنل اما یک روز سایت مشکل نداشت

دوباره همون مشکل بوجود اومده /// لطفا یک راهنمایی بفرمائید

Got error 28 from storage engine SQL=SELECT a.id, a.title, a.alias, a.title_alias, a.introtext, a.checked_out, a.checked_out_time, a.catid, a.created, a.created_by, a.created_by_alias, CASE WHEN a.modified = 0 THEN a.created ELSE a.modified END as modified, a.modified_by, uam.name as modified_by_name,CASE WHEN a.publish_up = 0 THEN a.created ELSE a.publish_up END as publish_up, a.publish_down, a.attribs, a.metadata, a.metakey, a.metadesc, a.access, a.hits, a.xreference, a.featured, LENGTH(a.fulltext) AS readmore ,CASE WHEN badcats.id is not null THEN 0 ELSE a.state END AS state,c.title AS category_title, c.path AS category_route, c.access AS category_access, c.alias AS category_alias,CASE WHEN a.created_by_alias > ' ' THEN a.created_by_alias ELSE ua.name END AS author,ua.email AS author_email,contact.id as contactid,parent.title as parent_title, parent.id as parent_id, parent.path as parent_route, parent.alias as parent_alias,ROUND( v.rating_sum / v.rating_count ) AS rating, v.rating_count as rating_count,c.published, CASE WHEN badcats.id is null THEN c.published ELSE 0 END AS parents_published FROM jos_content AS a LEFT JOIN jos_categories AS c ON c.id = a.catid LEFT JOIN jos_users AS ua ON ua.id = a.created_by LEFT JOIN jos_users AS uam ON uam.id = a.modified_by LEFT JOIN jos_contact_details AS contact on contact.user_id = a.created_by LEFT JOIN jos_categories as parent ON parent.id = c.parent_id LEFT JOIN jos_content_rating AS v ON a.id = v.content_id LEFT OUTER JOIN (SELECT cat.id as id FROM jos_categories AS cat JOIN jos_categories AS parent ON cat.lft BETWEEN parent.lft AND parent.rgt WHERE parent.extension = 'com_content' AND parent.published != 1 GROUP BY cat.id ) AS badcats ON badcats.id = c.id INNER JOIN jos_content_frontpage AS fp ON fp.content_id = a.id WHERE a.access IN (1,1) AND CASE WHEN badcats.id is null THEN a.state ELSE 0 END = 1 AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2013-01-23 20:39:06') AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2013-01-23 20:39:06') ORDER BY c.lft, CASE WHEN a.publish_up = 0 THEN a.created ELSE a.publish_up END DESC , a.created DESC LIMIT 0, 5 Got error 28 from storage engine SQL=SELECT a.id, a.title, a.alias, a.title_alias, a.introtext, a.checked_out, a.checked_out_time, a.catid, a.created, a.created_by, a.created_by_alias, CASE WHEN a.modified = 0 THEN a.created ELSE a.modified END as modified, a.modified_by, uam.name as modified_by_name,CASE WHEN a.publish_up = 0 THEN a.created ELSE a.publish_up END as publish_up, a.publish_down, a.attribs, a.metadata, a.metakey, a.metadesc, a.access, a.hits, a.xreference, a.featured, LENGTH(a.fulltext) AS readmore ,CASE WHEN badcats.id is not null THEN 0 ELSE a.state END AS state,c.title AS category_title, c.path AS category_route, c.access AS category_access, c.alias AS category_alias,CASE WHEN a.created_by_alias > ' ' THEN a.created_by_alias ELSE ua.name END AS author,ua.email AS author_email,contact.id as contactid,parent.title as parent_title, parent.id as parent_id, parent.path as parent_route, parent.alias as parent_alias,ROUND( v.rating_sum / v.rating_count ) AS rating, v.rating_count as rating_count,c.published, CASE WHEN badcats.id is null THEN c.published ELSE 0 END AS parents_published FROM jos_content AS a LEFT JOIN jos_categories AS c ON c.id = a.catid LEFT JOIN jos_users AS ua ON ua.id = a.created_by LEFT JOIN jos_users AS uam ON uam.id = a.modified_by LEFT JOIN jos_contact_details AS contact on contact.user_id = a.created_by LEFT JOIN jos_categories as parent ON parent.id = c.parent_id LEFT JOIN jos_content_rating AS v ON a.id = v.content_id LEFT OUTER JOIN (SELECT cat.id as id FROM jos_categories AS cat JOIN jos_categories AS parent ON cat.lft BETWEEN parent.lft AND parent.rgt WHERE parent.extension = 'com_content' AND parent.published != 1 GROUP BY cat.id ) AS badcats ON badcats.id = c.id INNER JOIN jos_content_frontpage AS fp ON fp.content_id = a.id WHERE a.access IN (1,1) AND CASE WHEN badcats.id is null THEN a.state ELSE 0 END = 1 AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2013-01-23 20:39:06') AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2013-01-23 20:39:06') ORDER BY c.lft, CASE WHEN a.publish_up = 0 THEN a.created ELSE a.publish_up END DESC , a.created DESC

[حجت مردانه زاده 596]

با سلام و عرض تبریک جهت پیوستن به گروه جوملافروم.

لطفا تیبل و یا دیتابیس رو repair بفرمایین. احتمالا باید درست بشه. اگر نشد.یکبار empty کنین و بعد دوباره ایمپورت کنین. نتیجه رو گزارش بدین...

موفق و سربلند و پایدار باشید

بامدادنیکــــ....