Thanks brother alotttttttt, i put this command and everythings seems fine now, thanks alot ur great!
[edited to draw this solution out]
- Code: Select all
mysqlcheck -u cron -p -A --auto-repair
Enter password:
asterisk.call_log OK
asterisk.conferences OK
asterisk.groups_alias OK
asterisk.inbound_numbers OK
asterisk.live_channels
note : The storage engine for the table doesn't support check
asterisk.live_inbound OK
asterisk.live_inbound_log OK
asterisk.live_sip_channels
note : The storage engine for the table doesn't support check
asterisk.park_log OK
asterisk.parked_channels
note : The storage engine for the table doesn't support check
asterisk.phone_favorites OK
asterisk.phones
warning : 3 clients are using or haven't closed the table properly
status : OK
asterisk.phones_alias OK
asterisk.recording_log
warning : 9 clients are using or haven't closed the table properly
status : OK
asterisk.server_performance
warning : 24 clients are using or haven't closed the table properly
status : OK
asterisk.server_updater
note : The storage engine for the table doesn't support check
asterisk.servers OK
asterisk.system_settings
warning : 16 clients are using or haven't closed the table properly
status : OK
asterisk.user_call_log
warning : 6 clients are using or haven't closed the table properly
status : OK
asterisk.vicidial_admin_log
warning : 6 clients are using or haven't closed the table properly
status : OK
asterisk.vicidial_agent_log OK
asterisk.vicidial_agent_sph OK
asterisk.vicidial_api_log OK
asterisk.vicidial_auto_calls OK
asterisk.vicidial_call_times OK
asterisk.vicidial_callbacks OK
asterisk.vicidial_campaign_agents OK
asterisk.vicidial_campaign_dnc OK
asterisk.vicidial_campaign_hotkeys OK
asterisk.vicidial_campaign_server_stats
note : The storage engine for the table doesn't support check
asterisk.vicidial_campaign_stats OK
asterisk.vicidial_campaign_statuses OK
asterisk.vicidial_campaigns
warning : 22 clients are using or haven't closed the table properly
status : OK
asterisk.vicidial_campaigns_list_mix OK
asterisk.vicidial_closer_log OK
asterisk.vicidial_conf_templates OK
asterisk.vicidial_conferences OK
asterisk.vicidial_cpd_log OK
asterisk.vicidial_did_log
warning : 5 clients are using or haven't closed the table properly
status : OK
asterisk.vicidial_dnc OK
asterisk.vicidial_hopper OK
asterisk.vicidial_inbound_dids
warning : 1 client is using or hasn't closed the table properly
status : OK
asterisk.vicidial_inbound_group_agents OK
asterisk.vicidial_inbound_groups
warning : 1 client is using or hasn't closed the table properly
status : OK
asterisk.vicidial_ivr OK
asterisk.vicidial_lead_filters OK
asterisk.vicidial_lead_recycle OK
asterisk.vicidial_list OK
asterisk.vicidial_list_alt_phones OK
asterisk.vicidial_list_pins OK
asterisk.vicidial_lists
warning : 8 clients are using or haven't closed the table properly
status : OK
asterisk.vicidial_live_agents
warning : Table is marked as crashed and last repair failed
warning : 1 client is using or hasn't closed the table properly
error : Found 3 keys of 4
error : Corrupt
asterisk.vicidial_live_inbound_agents OK
asterisk.vicidial_log OK
asterisk.vicidial_manager OK
asterisk.vicidial_nanpa_prefix_codes OK
asterisk.vicidial_pause_codes OK
asterisk.vicidial_phone_codes OK
asterisk.vicidial_postal_codes OK
asterisk.vicidial_qc_codes OK
asterisk.vicidial_remote_agents OK
asterisk.vicidial_scripts OK
asterisk.vicidial_server_carriers
warning : 1 client is using or hasn't closed the table properly
status : OK
asterisk.vicidial_server_trunks OK
asterisk.vicidial_shifts OK
asterisk.vicidial_state_call_times OK
asterisk.vicidial_stations OK
asterisk.vicidial_status_categories OK
asterisk.vicidial_statuses OK
asterisk.vicidial_timeclock_audit_log
warning : 1 client is using or hasn't closed the table properly
status : OK
asterisk.vicidial_timeclock_log OK
asterisk.vicidial_timeclock_status OK
asterisk.vicidial_user_closer_log
warning : 12 clients are using or haven't closed the table properly
status : OK
asterisk.vicidial_user_groups OK
asterisk.vicidial_user_log
warning : 14 clients are using or haven't closed the table properly
status : OK
asterisk.vicidial_users
warning : 13 clients are using or haven't closed the table properly
status : OK
asterisk.vicidial_xfer_log OK
asterisk.web_client_sessions
note : The storage engine for the table doesn't support check
Repairing tables
asterisk.vicidial_live_agents OK