Project

General

Profile

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: 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

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.

vici.jpg (31.2 KB) vici.jpg Please help me in resolving this issue

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

    (1-3/3)
    Go to top