Error Number: 145 Table './asterisk/vicidial_list' is marked as crashed and should be repaired
Added by brajkishor rajput almost 9 years ago
Hi,
i am facing this error on the Dashboard of Goautodial due to this whole calling if off the message comes on the dashboard is """"""Error Number: 145
Table './asterisk/vicidial_list' is marked as crashed and should be repaired
select count(*) qresult from vicidial_lists as vls,vicidial_list as vl where vl.list_id=vls.list_id and active='Y'
""""""""
please tell me how to resolve this
Replies (3)
RE: Error Number: 145 Table './asterisk/vicidial_list' is marked as crashed and should be repaired - Added by striker 247 almost 9 years ago
run the mysql repair command
mysqlcheck -u root -p --auto-repair --check --optimize --all-databases
it will prompt for password enter vicdialnow
br
striker
www.striker24x7.blogspot.com
RE: Error Number: 145 Table './asterisk/vicidial_list' is marked as crashed and should be repaired - Added by brajkishor rajput over 6 years ago
brajkishor rajput wrote:
Hi,
i am facing this error on the Dashboard of Goautodial due to this whole calling if off the message comes on the dashboard is """"""Error Number: 145Table './asterisk/vicidial_list' is marked as crashed and should be repaired
select count(*) qresult from vicidial_lists as vls,vicidial_list as vl where vl.list_id=vls.list_id and active='Y'
""""""""please tell me how to resolve this
I am facing this problem again
now when i enter the command i did not get any option it just says access denied..
Please let me know where i am doing wrong.... and how can i resolve it.
RE: Error Number: 145 Table './asterisk/vicidial_list' is marked as crashed and should be repaired - Added by striker 247 over 6 years ago
once you type that command whether it asked for password enter vicidialnow or goautodial
or type the below command and then enter password 1234
mysqlcheck -u cron -p --auto-repair --check --optimize --all-databases
br
striker
www.striker24x7.blogspot.com