3.4.5 - Driver Error

[Errors]

Добрый день,

 

Выручайте друзья! Разработчики скриптов посылают в поддержку хостинга. Хостинг правил таблицы уже раз 5. Но проблемы снова вылаезают. То была 502 ошибка, сайт не грузился, после починки теперь выдает Driver Error

 

Главная страница форума работает нормально. В разделы заходим тоже нормально. Но при попытке открыть топики выдает - Driver Error

There appears to be an error with the database.

 

If you are seeing this page, it means there was a problem communicating with our database. Sometimes this error is temporary and will go away when you refresh the page. Sometimes the error will need to be fixed by an administrator before the site will become accessible again.

 

You can try to refresh the page by clicking here

 

Последние ошибки в логах:

 

Date: Sun, 20 Oct 2013 23:59:37 +0000 Error: 144 - Table './psp/posts' is marked as crashed and last (automatic?) repair failed IP Address: 157.56.93.83 - /topic/1083699/page-2 ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- mySQL query error: SELECT p.*,m.member_id as mid,m.name,m.member_group_id,m.email,m.joined,m.posts, m.last_visit, m.last_activity,m.login_anonymous,m.title as member_title, m.warn_level, m.warn_lastwarn, m.members_display_name, m.members_seo_name, m.member_banned, m.has_gallery, m.has_blog, m.members_bitoptions,m.mgroup_others,pp.*,w.wl_id,pc.*,rep_index.rep_rating as has_given_rep,rep_cache.rep_points, rep_cache.rep_like_cache,cca.*,ccb.cache_content as cache_content_sig, ccb.cache_updated as cache_updated_sig FROM ( SELECT pid, post_date FROM posts WHERE topic_id=1083699 AND queued=0 ORDER BY pid asc LIMIT 20,20 ) z LEFT JOIN posts p ON ( p.pid=z.pid ) LEFT JOIN members m ON ( m.member_id=p.author_id ) LEFT JOIN profile_portal pp ON ( m.member_id=pp.pp_member_id ) LEFT JOIN members_warn_logs w ON ( w.wl_content_app='forums' and w.wl_content_id1=p.pid ) LEFT JOIN pfields_content pc ON ( pc.member_id=p.author_id ) LEFT JOIN reputation_index rep_index ON ( rep_index.app='forums' AND rep_index.type='pid' AND rep_index.type_id=p.pid AND rep_index.member_id=0 ) LEFT JOIN reputation_cache rep_cache ON ( rep_cache.app='forums' AND rep_cache.type='pid' AND rep_cache.type_id=p.pid ) LEFT JOIN content_cache_posts cca ON ( cca.cache_content_id=p.pid ) LEFT JOIN content_cache_sigs ccb ON ( ccb.cache_content_id=m.member_id ) ORDER BY z.pid asc .--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------. | File | Function | Line No. | |----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------| | admin_168/applications/forums/modules_public/forums/topics.php | [public_forums_forums_topics]._getPosts | 211 | '----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------' | admin_168/sources/base/ipsController.php | [public_forums_forums_topics].doExecute | 306 | '----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'

 

похожих ошибок много. и вот еще одна, которая отличается от большинства:

 

Date: Sun, 20 Oct 2013 23:59:40 +0000 Error: 144 - Table './psp/posts' is marked as crashed and last (automatic?) repair failed IP Address: 96.47.238.39 - /topic/1041345/?view=getnewpost ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- mySQL query error: SELECT MIN(pid) as pid FROM posts WHERE topic_id=1041345 AND post_date > 1382240825 AND queued=0 LIMIT 0,1 .--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------. | File | Function | Line No. | |----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------| | admin_168/applications/forums/modules_public/forums/topics.php | [public_forums_forums_topics].returnNewPost | 1151 | '----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------' | admin_168/applications/forums/modules_public/forums/topics.php | [public_forums_forums_topics]._doViewCheck | 189 | '----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------' | admin_168/sources/base/ipsController.php | [public_forums_forums_topics].doExecute | 306 | '----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'

[Bot]

Обратите внимание

"Board url", указанный вами в профиле, некорректен, либо недоступен на данный момент. Пожауйста, заполните его, потому что он скорее всего потребуется при диагностике вашей проблемы.

[siv1987]

Таблица постов битая.

Выполните запрос из админцентра -> прочее -> sql, или из phpmyadmin

 

REPAIR TABLE posts

 

Если таблица бьется часто, значит либо проблемы с диском, либо недостаточно свободного место, либо слишком большая нагрузка с которой mysql не справляется.