/build/static/layout/Breadcrumb_cap_w.png

KACE Product Support Question


KACE Support Center not working - All other functions OK

04/03/2017 834 views
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

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")
1 Comment   [ + ] Show comment

Comments

  • The first report should be select

    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?

Be the first to answer this question

Don't be a Stranger!

Sign up today to participate, stay informed, earn points and establish a reputation for yourself!

Sign up! or login

Share

 
This website uses cookies. By continuing to use this site and/or clicking the "Accept" button you are providing consent Quest Software and its affiliates do NOT sell the Personal Data you provide to us either when you register on our websites or when you do business with us. For more information about our Privacy Policy and our data protection efforts, please visit GDPR-HQ