vicidial.org

1) Version of VICIDIAL – 2.4-310a
2) loadavg – 0.37
3) Server Specs – 500G – HD, Quad core, 4G RAM
4) Codecs used – G729
5) VOIP or PSTN - VOIP
6) OS – Windows XP for work stations

i cant generate reports on my database is there any way to repair my database if yes how?
anyone can teach me how to repair my database?

Did you try running...

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

i did and i got this error

mysql: unknown option '--auto-repair'

try this one instead

Code: Select all

mysqlcheck --all-databases -o -r

i just forgot the "check" the 1st command works and im on processing it.. thanks anyway.. =)

Sounds great, now have fun

still i got this error when im using export call report any idea how to fix this =)

There are no outbound calls during this time period for these parameters

can u make a snapshot or anything that could help us identify the issue. give as much information as u can give so we could analyze it more

still i got this error

The earlier error of not recognizing --auto-repair had been resolved, so that isn't the error ... so to what error do you refer?

ok this is the problem..

i cant generate any outbound report and export report it always says "There are no outbound calls during this time period for these parameters " i already check all the parameters dates campaigns etc.. still same output.

Do you have archiving enabled? probably the reports you are looking for are in the _archive tables , if so you can do a REPLACE INTO _log SELECT * FROM _log_archive to put back the archived rows into the main log file

also for database repair you can try this: mysqlcheck -p --databases=asterisk -o -r