How to troubleshoot Opps Something went Wrong with the K1000.
When clicking on a device from the inventory to view it's information, we receive a error page saying oops something went wrong. The error is the following.
PHP Error: Uncaught ADODB_Exception in /kbox/kboxwww/include/KTicket.class.php on line 4686: 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,
when 'Opened' then 'Opened'
when 'Closed' then 'Closed'
when 'Need More Info' then 'Need More Info'
when 'New' then 'New'
end as STATUS,
from HD_TICKET, HD_STATUS
where MACHINE_ID = 586 and HD_STATUS_ID = HD_STATUS.ID
order by ID DESC limit 10")
everything else within the K1000 is working fine. Has anyone see this before?
K1000 Version: 6.4.120822
Agent Version: 6.4.522
There are no answers at this time