KACE Support Center not working - All other functions OK
When trying to open the Support Center I receive the following error.
PHP Error: Uncaught Unhandled Exception in /kbox/kboxwww/include/KTicket.class.php on line 2177: mysqli error: [1033: Incorrect information in file: './ORG1/HD_TICKET.frm'] in EXECUTE("
select OWNER_ID, count(*)
from HD_TICKET, HD_STATUS
where HD_TICKET.HD_STATUS_ID = HD_STATUS.ID
select OWNER_ID, count(*)
from HD_TICKET, HD_STATUS
where HD_TICKET.HD_STATUS_ID = HD_STATUS.ID
and STATE != 'closed'
group by OWNER_ID")I thought it might have something to do with a report. I found one report that would not run and deleted it but I am still having the problem.
An ideas?
Just tried to look at the detail of an item in inventory and received this message:
PHP Error: Uncaught Unhandled Exception in /kbox/kboxwww/include/KTicket.class.php on line 5979: mysqli error: [1033: Incorrect information in file: './ORG1/HD_TICKET.frm'] in EXECUTE("
select HD_TICKET.ID, CONCAT('TICK:',
case
when LENGTH(HD_TICKET.ID) < 4 then LPAD(HD_TICKET.ID, 4, '0')
else HD_TICKET.ID end) as TICKET_NUMBER,
case NAME
when 'Opened' then 'Opened'
when 'Closed' then 'Closed'
when 'Need More Info' then 'Need More Info'
when 'New' then 'New'
else NAME
end as STATUS,
TITLE
from HD_TICKET, HD_STATUS
where HD_TICKET.MACHINE_ID = 2323 and HD_STATUS_ID = HD_STATUS.ID
order by ID DESC limit 10")
select HD_TICKET.ID, CONCAT('TICK:',
case
when LENGTH(HD_TICKET.ID) < 4 then LPAD(HD_TICKET.ID, 4, '0')
else HD_TICKET.ID end) as TICKET_NUMBER,
case NAME
when 'Opened' then 'Opened'
when 'Closed' then 'Closed'
when 'Need More Info' then 'Need More Info'
when 'New' then 'New'
else NAME
end as STATUS,
TITLE
from HD_TICKET, HD_STATUS
where HD_TICKET.MACHINE_ID = 2323 and HD_STATUS_ID = HD_STATUS.ID
order by ID DESC limit 10")
1 Comment
[ + ] Show comment
Answers (0)
Please log in to answer
Be the first to answer this question
HD_TICKET.OWNER_ID, count(*)
from HD_TICKET, HD_STATUS
where HD_TICKET.HD_STATUS_ID = HD_STATUS.ID
and HD_STATUS.STATE != 'closed'
group by HD_TICKET.OWNER_ID
in order to run... maybe log it with Quest? - Myth0S 7 years ago