Tras usar el buscador y no hallar solucion a mi problema, ruego vuestra ayuda:
Mi foro, www.ajayu.org con SMF 2.0.2 se "cuelga" muchas veces lanzandome varios errores, pero en general aparece un "error en la Base de Datos", lo que deja inaccesible el sitio hasta que entre al cPanel, revise la BD, le haga un check y le de un repair.
Luego de eso, todo bien... hasta que vuelve a pasar.
Lo último que pasó, me arrojó estos errores, ¿alguna idea de como corregirlos?
P.D.: Ya realicé las rutinas de mantenimiento desde SMF ._.
Se los agradezco MUCHO! :D
Verificando Base de Datos
ajayuor_ajayu esta siendo ahora verificada.
ajayuor_ajayu.smf_2sichat OK
ajayuor_ajayu.smf_2sichat_gadgets OK
ajayuor_ajayu.smf_admin_info_files OK
ajayuor_ajayu.smf_aeva_albums OK
ajayuor_ajayu.smf_aeva_comments OK
ajayuor_ajayu.smf_aeva_field_data OK
ajayuor_ajayu.smf_aeva_fields OK
ajayuor_ajayu.smf_aeva_files OK
ajayuor_ajayu.smf_aeva_log_media OK
ajayuor_ajayu.smf_aeva_log_ratings OK
ajayuor_ajayu.smf_aeva_media OK
ajayuor_ajayu.smf_aeva_perms OK
ajayuor_ajayu.smf_aeva_quotas OK
ajayuor_ajayu.smf_aeva_settings OK
ajayuor_ajayu.smf_aeva_variables OK
ajayuor_ajayu.smf_approval_queue
warning : 1 client is using or hasn't closed the table properly
status : OK
ajayuor_ajayu.smf_attachments
warning : 2 clients are using or haven't closed the table properly
status : OK
ajayuor_ajayu.smf_ban_groups OK
ajayuor_ajayu.smf_ban_items OK
ajayuor_ajayu.smf_board_permissions OK
ajayuor_ajayu.smf_boards OK
ajayuor_ajayu.smf_calendar OK
ajayuor_ajayu.smf_calendar_holidays OK
ajayuor_ajayu.smf_categories OK
ajayuor_ajayu.smf_collapsed_categories OK
ajayuor_ajayu.smf_custom_fields OK
ajayuor_ajayu.smf_group_moderators OK
ajayuor_ajayu.smf_likes OK
ajayuor_ajayu.smf_log_actions OK
ajayuor_ajayu.smf_log_activity
warning : 1 client is using or hasn't closed the table properly
status : OK
ajayuor_ajayu.smf_log_banned OK
ajayuor_ajayu.smf_log_boards
warning : 1 client is using or hasn't closed the table properly
status : OK
ajayuor_ajayu.smf_log_comments OK
ajayuor_ajayu.smf_log_digest OK
ajayuor_ajayu.smf_log_errors OK
ajayuor_ajayu.smf_log_floodcontrol
warning : 1 client is using or hasn't closed the table properly
error : Checksum for key: 1 doesn't match checksum for records
error : Corrupt
ajayuor_ajayu.smf_log_group_requests OK
ajayuor_ajayu.smf_log_karma OK
ajayuor_ajayu.smf_log_mark_read OK
ajayuor_ajayu.smf_log_member_notices OK
ajayuor_ajayu.smf_log_notify OK
ajayuor_ajayu.smf_log_online
warning : Table is marked as crashed
warning : 2 clients are using or haven't closed the table properly
error : Found 23 keys of 20
error : Corrupt
ajayuor_ajayu.smf_log_packages OK
ajayuor_ajayu.smf_log_polls OK
ajayuor_ajayu.smf_log_reported OK
ajayuor_ajayu.smf_log_reported_comments OK
ajayuor_ajayu.smf_log_scheduled_tasks
warning : 1 client is using or hasn't closed the table properly
error : Found 868 keys of 869
error : Corrupt
ajayuor_ajayu.smf_log_search_messages OK
ajayuor_ajayu.smf_log_search_results OK
ajayuor_ajayu.smf_log_search_subjects OK
ajayuor_ajayu.smf_log_search_topics OK
ajayuor_ajayu.smf_log_spider_hits OK
ajayuor_ajayu.smf_log_spider_stats
warning : 2 clients are using or haven't closed the table properly
status : OK
ajayuor_ajayu.smf_log_status_replies OK
ajayuor_ajayu.smf_log_statuses OK
ajayuor_ajayu.smf_log_subscribed OK
ajayuor_ajayu.smf_log_topics
warning : 1 client is using or hasn't closed the table properly
error : Found 20479 keys of 20480
error : Corrupt
ajayuor_ajayu.smf_mail_queue OK
ajayuor_ajayu.smf_member_notes OK
ajayuor_ajayu.smf_membergroups OK
ajayuor_ajayu.smf_members
warning : 1 client is using or hasn't closed the table properly
error : Size of indexfile is: 373760 Should be: 375808
error : Corrupt
ajayuor_ajayu.smf_message_icons OK
ajayuor_ajayu.smf_messages OK
ajayuor_ajayu.smf_moderators OK
ajayuor_ajayu.smf_openid_assoc OK
ajayuor_ajayu.smf_package_servers OK
ajayuor_ajayu.smf_permission_profiles OK
ajayuor_ajayu.smf_permissions OK
ajayuor_ajayu.smf_personal_messages OK
ajayuor_ajayu.smf_pm_recipients OK
ajayuor_ajayu.smf_pm_rules OK
ajayuor_ajayu.smf_pokes OK
ajayuor_ajayu.smf_poll_choices OK
ajayuor_ajayu.smf_polls OK
ajayuor_ajayu.smf_portamx_blocks OK
ajayuor_ajayu.smf_portamx_settings OK
ajayuor_ajayu.smf_profile_comments OK
ajayuor_ajayu.smf_related_subjects OK
ajayuor_ajayu.smf_related_topics OK
ajayuor_ajayu.smf_scheduled_tasks
warning : 1 client is using or hasn't closed the table properly
error : Checksum for key: 3 doesn't match checksum for records
error : Corrupt
ajayuor_ajayu.smf_sessions
warning : Table is marked as crashed
warning : 2 clients are using or haven't closed the table properly
error : Size of indexfile is: 39936 Should be: 99328
error : Corrupt
ajayuor_ajayu.smf_settings
warning : 2 clients are using or haven't closed the table properly
status : OK
ajayuor_ajayu.smf_shop_categories OK
ajayuor_ajayu.smf_shop_inventory OK
ajayuor_ajayu.smf_shop_items OK
ajayuor_ajayu.smf_shoutbox OK
ajayuor_ajayu.smf_shoutbox_ban OK
ajayuor_ajayu.smf_shoutbox_settings OK
ajayuor_ajayu.smf_smileys OK
ajayuor_ajayu.smf_social_approval OK
ajayuor_ajayu.smf_social_attachments OK
ajayuor_ajayu.smf_social_categories OK
ajayuor_ajayu.smf_social_comments OK
ajayuor_ajayu.smf_social_events OK
ajayuor_ajayu.smf_social_groups OK
ajayuor_ajayu.smf_social_log OK
ajayuor_ajayu.smf_social_members OK
ajayuor_ajayu.smf_social_posts OK
ajayuor_ajayu.smf_social_threads OK
ajayuor_ajayu.smf_sp_articles OK
ajayuor_ajayu.smf_sp_blocks OK
ajayuor_ajayu.smf_sp_categories OK
ajayuor_ajayu.smf_sp_functions OK
ajayuor_ajayu.smf_sp_pages OK
ajayuor_ajayu.smf_sp_parameters OK
ajayuor_ajayu.smf_sp_shoutboxes OK
ajayuor_ajayu.smf_sp_shouts OK
ajayuor_ajayu.smf_spiders OK
ajayuor_ajayu.smf_subscriptions OK
ajayuor_ajayu.smf_themes
warning : 1 client is using or hasn't closed the table properly
error : Size of indexfile is: 1197056 Should be: 1198080
error : Corrupt
ajayuor_ajayu.smf_topics
warning : 1 client is using or hasn't closed the table properly
status : OK
También tengo problemas con la tabla smf_scheduled_tasks
Me da este error:
Can't find file: 'smf_scheduled_tasks' (errno: 2)
File: C:\xampp\htdocs\foro\Sources\ManageSettings.php
Line: 401
¿Alguna forma en que pueda reconstruir/restaurar esa tabla para solucionar el problema?
//El error sale al instalar algún "Core Feature"
Probaste Administrar > Mantenimiento > Mantenimineto del foro > Base de Datos > optimizar todas las tablas ?