Page 1 of 1

No Recordings Under User Stats

PostPosted: Mon May 13, 2024 6:15 am
by Ikram_Ali
Hi All,

I facing a weird issue where no recordings URL showing under the location option.

For an example-
User Stats>>>RECORDINGS FOR THIS TIME PERIOD: Under Location, no recordings links appearing, it's just has nothing.

Earlier, 2 weeks before, all calls recordings showing here but suddenly it has nothing.

When i check in asterisk CLI, it clearly shows the recordings are being made as it shows the recordings name.

Can somebody, please guide me to fixation.

VERSION: 2.14-763a
BUILD: 200719-1645
© 2020 ViciDial Group

Asterisk Version: 13.21.0

Version: 2.14b0.5
SVN Version: 0
DB Schema Version: 1582

Re: No Recordings Under User Stats

PostPosted: Tue May 14, 2024 1:59 am
by Ikram_Ali
@ALL,

That has been resolved now. Issue was call recording log table was corrupted.
Ikram_Ali wrote:Hi All,

I facing a weird issue where no recordings URL showing under the location option.

For an example-
User Stats>>>RECORDINGS FOR THIS TIME PERIOD: Under Location, no recordings links appearing, it's just has nothing.

Earlier, 2 weeks before, all calls recordings showing here but suddenly it has nothing.

When i check in asterisk CLI, it clearly shows the recordings are being made as it shows the recordings name.

Can somebody, please guide me to fixation.

VERSION: 2.14-763a
BUILD: 200719-1645
© 2020 ViciDial Group

Asterisk Version: 13.21.0

Version: 2.14b0.5
SVN Version: 0
DB Schema Version: 1582

Re: No Recordings Under User Stats

PostPosted: Tue Jun 25, 2024 10:27 am
by williamconley
Ikram_Ali wrote:@ALL,

That has been resolved now. Issue was call recording log table was corrupted.


Excellent postback! 8-)

Re: No Recordings Under User Stats

PostPosted: Thu Aug 01, 2024 8:13 am
by d001
Ikram_Ali wrote:@ALL,

That has been resolved now. Issue was call recording log table was corrupted.
Ikram_Ali wrote:Hi All,

I facing a weird issue where no recordings URL showing under the location option.

For an example-
User Stats>>>RECORDINGS FOR THIS TIME PERIOD: Under Location, no recordings links appearing, it's just has nothing.

Earlier, 2 weeks before, all calls recordings showing here but suddenly it has nothing.

When i check in asterisk CLI, it clearly shows the recordings are being made as it shows the recordings name.

Can somebody, please guide me to fixation.
...


Hello Ikram_Ali and everyone,

I hope this message finds you well! I am experiencing the same issue. How did you resolve it, if I may ask?

Does anyone else have any ideas?

Regards!

ViciBox v.11.0.1 | VERSION: 2.14-918a | BUILD: 240528-1722 | Asterisk 16.30.0-vici | OpenSUSE Leap: 15.5

Re: No Recordings Under User Stats

PostPosted: Sat Aug 03, 2024 8:49 pm
by williamconley
d001 wrote:
Ikram_Ali wrote:That has been resolved now. Issue was call recording log table was corrupted.

I hope this message finds you well! I am experiencing the same issue. How did you resolve it, if I may ask?


Recording log table was corrupted. In case you missed that. To check:

This command may be discruptive if you have large tables (ie: don't run it while dialing unless you know what you're doing)
Code: Select all
mysqlcheck --all-databases --auto-repair


if you get permission denied, add "-p" to the end and provide your root mysql password. Or add "-u cron -p1234" if your cron user has proper permissions to repair.

Re: No Recordings Under User Stats

PostPosted: Mon Aug 05, 2024 6:32 am
by d001
williamconley wrote:This command may be discruptive if you have large tables (ie: don't run it while dialing unless you know what you're doing)

mysqlcheck --all-databases --auto-repair


Actually, I wasn't sure what I was doing, so I didn't use this because I didn't want to destroy anything on my server. However, I found the solution with your help.

Look at the link below:
http://www.vicidial.org/VICIDIALforum/viewtopic.php?f=4&t=42077#p153026

Regards!