No Recordings Under User Stats

All installation and configuration problems and questions

Moderators: gerski, enjay, williamconley, Op3r, Staydog, gardo, mflorell, MJCoate, mcargile, Kumba, Michael_N

No Recordings Under User Stats

Postby Ikram_Ali » Mon May 13, 2024 6:15 am

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
Ikram_Ali
 
Posts: 68
Joined: Fri Aug 23, 2019 1:21 pm

Re: No Recordings Under User Stats

Postby Ikram_Ali » Tue May 14, 2024 1:59 am

@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
Ikram_Ali
 
Posts: 68
Joined: Fri Aug 23, 2019 1:21 pm

Re: No Recordings Under User Stats

Postby williamconley » Tue Jun 25, 2024 10:27 am

Ikram_Ali wrote:@ALL,

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


Excellent postback! 8-)
Vicidial Installation and Repair, plus Hosting and Colocation
Newest Product: Vicidial Agent Only Beep - Beta
http://www.PoundTeam.com # 352-269-0000 # +44(203) 769-2294
williamconley
 
Posts: 20258
Joined: Wed Oct 31, 2007 4:17 pm
Location: Davenport, FL (By Disney!)

Re: No Recordings Under User Stats

Postby d001 » Thu Aug 01, 2024 8:13 am

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
ViciBox v.11.0.1 | VERSION: 2.14-918a | BUILD: 240528-1722 | Asterisk 16.30.0-vici | OpenSUSE Leap: 15.5
d001
 
Posts: 36
Joined: Wed Jul 10, 2024 9:56 am

Re: No Recordings Under User Stats

Postby williamconley » Sat Aug 03, 2024 8:49 pm

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.
Vicidial Installation and Repair, plus Hosting and Colocation
Newest Product: Vicidial Agent Only Beep - Beta
http://www.PoundTeam.com # 352-269-0000 # +44(203) 769-2294
williamconley
 
Posts: 20258
Joined: Wed Oct 31, 2007 4:17 pm
Location: Davenport, FL (By Disney!)

Re: No Recordings Under User Stats

Postby d001 » Mon Aug 05, 2024 6:32 am

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!
ViciBox v.11.0.1 | VERSION: 2.14-918a | BUILD: 240528-1722 | Asterisk 16.30.0-vici | OpenSUSE Leap: 15.5
d001
 
Posts: 36
Joined: Wed Jul 10, 2024 9:56 am


Return to Support

Who is online

Users browsing this forum: No registered users and 52 guests