QueueMetrics professional call center suite for the Asterisk PBX
Welcome,
Guest
. Please
login
or
register
.
1 Hour
1 Day
1 Week
1 Month
Forever
Login with username, password and session length
News:
Welcome to the new forum!
Home
Help
Search
Login
Register
QueueMetrics forum
»
QueueMetrics
»
MySQL storage and Qloaderd/Uniloader
»
The file sql:P001|P02 does not exist
« previous
next »
Print
Pages: [
1
]
Author
Topic: The file sql:P001|P02 does not exist (Read 6143 times)
jacobusvn
Newbie
Posts: 5
Karma: 0
The file sql:P001|P02 does not exist
«
on:
May 22, 2009, 21:05:05 »
I have a QM server where QM stopped working today and I found the database to be corrupted and managed to repair it but now every time I what to view report in QM I get the following error:
Alert: The file sql:P001|P02 does not exist
I don't know where to even start looking for the problem.
Please help if you can.
Many Thanks
Logged
QueueMetrics
Loway
Hero Member
Posts: 2999
Karma: 39
Re: The file sql:P001|P02 does not exist
«
Reply #1 on:
May 23, 2009, 09:16:53 »
Most likely: Qm gets an error back from the database when trying to read the
queue_log
table.
Try connecting to the QM database from a MySQL interface and issue a
Code:
[Select]
select * from queue_log limit 0,100
and see if you get data out of it.
Logged
jacobusvn
Newbie
Posts: 5
Karma: 0
Re: The file sql:P001|P02 does not exist
«
Reply #2 on:
May 23, 2009, 10:37:57 »
queue_log table was corrupt.
A repair fixed my problem.
I didn’t look in the mysql log.
Thanks
Logged
QueueMetrics
Loway
Hero Member
Posts: 2999
Karma: 39
Re: The file sql:P001|P02 does not exist
«
Reply #3 on:
May 25, 2009, 10:02:53 »
That's okay.
Logged
Print
Pages: [
1
]
« previous
next »
QueueMetrics forum
»
QueueMetrics
»
MySQL storage and Qloaderd/Uniloader
»
The file sql:P001|P02 does not exist