اشکال در مجموعه ها

[napster 10]

سلام.من برای ایجاد مجموعه از کامپوننت ایجاد انبوه مجموعه استفاده میکنم.اوایل هیچ مشکلی نداشتم ولی تعداد مجموعه هام که زیاد شد ( بالای 500 تا) با ارور زیر مواجه میشم :Query execution was interrupted SQL=SELECT a.id AS value, a.title AS text, a.level FROM bj683_categories AS a LEFT JOIN `bj683_categories` AS b ON a.lft > b.lft AND a.rgt < b.rgt WHERE (a.extension = "com_content" OR a.parent_id = 0) AND a.published IN (0,1) GROUP BY a.id ORDER BY a.lft ASC

ایراد در بارگذاری ماژول MySQL server has gone away SQL=SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid FROM bj683_modules AS m LEFT JOIN bj683_modules_menu AS mm ON mm.moduleid = m.id LEFT JOIN bj683_extensions AS e ON e.element = m.module AND e.client_id = m.client_id WHERE m.published = 1 AND e.enabled = 1 AND (m.publish_up = '0000-00-00 00:00:00' OR m.publish_up <= '2012-09-02 15:17:18') AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2012-09-02 15:17:18') AND m.access IN (1,1,2,3,4) AND m.client_id = 1 AND (mm.menuid = 0 OR mm.menuid <= 0) ORDER BY m.position, m.ordering

MySQL server has gone away SQL=SELECT a.id AS value, a.title AS text FROM `bj683_viewlevels` AS a GROUP BY a.id, a.title, a.ordering ORDER BY a.ordering ASC

وقتی هم از قسمت خود محتوا - ایجاد مجموعه رو میزنم ارور زیر رو میده :

Query execution was interrupted SQL=SELECT a.id AS value, a.title AS text, a.level, a.published FROM bj683_categories AS a LEFT JOIN `bj683_categories` AS b ON a.lft > b.lft AND a.rgt < b.rgt WHERE (a.extension = 'com_content' OR a.parent_id = 0) AND a.published IN (0,1) GROUP BY a.id, a.title, a.level, a.lft, a.rgt, a.extension, a.parent_id, a.published ORDER BY a.lft ASC

MySQL server has gone away SQL=SELECT a.id AS value, a.title AS text FROM bj683_viewlevels AS a GROUP BY a.id, a.title, a.ordering ORDER BY a.ordering ASC,`title` ASC

MySQL server has gone away SQL=SELECT a.lang_code AS value, a.title AS text, a.title_native FROM bj683_languages AS a WHERE a.published >= 0 ORDER BY a.title

ایراد در بارگذاری کامپوننت: com_media, 1

MySQL server has gone away SQL=SELECT e.element, e.name FROM bj683_extensions as e WHERE e.client_id = 0 AND e.type = 'template' AND e.enabled = 1

ایراد در بارگذاری کامپوننت: com_media, 1

ایراد در بارگذاری کامپوننت: com_content, 1

ایراد در بارگذاری ماژول MySQL server has gone away SQL=SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid FROM bj683_modules AS m LEFT JOIN bj683_modules_menu AS mm ON mm.moduleid = m.id LEFT JOIN bj683_extensions AS e ON e.element = m.module AND e.client_id = m.client_id WHERE m.published = 1 AND e.enabled = 1 AND (m.publish_up = '0000-00-00 00:00:00' OR m.publish_up <= '2012-09-02 15:23:44') AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2012-09-02 15:23:44') AND m.access IN (1,1,2,3,4) AND m.client_id = 1 AND (mm.menuid = 0 OR mm.menuid <= 0) ORDER BY m.position, m.ordering

اگه میشه بهم کمک کنید.ممنون میشم

ویرایش شده در شهریور 91 توسط napster

[ابوالفضل طالبی 280]

گویا مشکل از هاست شماست که میزان کوئری های اجرا شده زیاد شده خطا میده .. با مدیر هاست خودتون تماس بگیرید