We have an error in scriptcase 8.1 in SC Ticket
We can connect or login to database but when select assign ticket there is an error message[ATTACH=CONFIG]n83585[/ATTACH]
[TABLE=“class: scErrorTable, align: center, cellpadding: 0, cellspacing: 0, width: 1”]
[TR]
[TD=“class: scErrorTitle, bgcolor: #D8A657, align: left”]Error[/TD]
[/TR]
[TR]
[TD=“class: scErrorMessage, bgcolor: #FFFFFF, align: center”]Error while accessing the database:
SelectLimit(SELECT ticket.tickettrack as ticket_tickettrack, ticket.ticketlastupdate as ticket_ticketlastupdate, customer.customername as customer_customername, customer.customeremail as customer_customeremail, ticket.categoryid as ticket_categoryid, ticket.subject as ticket_subject, ticketpriority.priorityname as ticketpriority_priorityname, ticketstatus.statusname as ticketstatus_statusname, ticket.ticketid as ticket_ticketid from ((((ticket left outer join customer on ticket.customerid = customer.customerid) left outer join staff on ticket.ownerid = staff.staffid) inner join ticketstatus on ticket.statusid = ticketstatus.statusid) inner join ticketpriority on ticket.ticketpriorityid = ticketpriority.ticketpriorityid) inner join categories on ticket.categoryid = categories.categoryid where ticket.ticketid = order by ticket.ticketlastupdate desc, 3, 0)[/TD]
[/TR]
[/TABLE]
