Project

General

Profile

Forums » Open discussion »

need hepl

Added by more be over 9 years ago

dear members
im probationner on a call center we use goautodial,but today i have seen this :

Error Number: 145
Table './asterisk/vicidial_log' is marked as crashed and should be repaired

select count(*) as qresult from vicidial_log vl,vicidial_agent_log val where vl.uniqueid=val.uniqueid and val.status IN ('SALE','RDV','VEN') and call_date BETWEEN '2015-03-23 00:00:00' AND '2015-03-23 23:59:59'"
i need help thanks


Replies (4)

RE: need hepl - Added by striker 247 over 9 years ago

repair the mysql below is the command

mysqlcheck -u root -p --auto-repair --check --optimize --all-databases

password: vicidialnow

regard
striker
www.striker24x7.blogspot.com

RE: need hepl - Added by more be over 9 years ago

hi thanks for answer
but it show me the same problem

Download all files
11.jpg (20.2 KB) 11.jpg
12.jpg (167 KB) 12.jpg

RE: need hepl - Added by striker 247 over 9 years ago

login to mysql with below commands and repair the table...

mysql -p
password: vicidialnow
>use asterisk
>repair table vicidial_log
>quit
reboot

regards
striker
www.striker24x7.blogspot.com

RE: need hepl - Added by more be over 9 years ago

hi thanks it walk
but to day in the morning the server show me the information below (picture) we use two compaign the firs is good and running use the 192.168.1.4 and the second 192.168.1.3
are some idea to resolve about this
regards

urg.jpg (200 KB) urg.jpg
    (1-4/4)     Go to top