Error: Failed to issue SQL query: query = SELECT DISTINCT `lnkTicketToDoc_lnktickettodoc`.`id` AS `lnkTicketToDocid`, `lnkTicketToDoc_lnktickettodoc`.`ticket_id` AS `lnkTicketToDocticket_id`, `Ticket_ticket`.`ref` AS `lnkTicketToDocticket_ref`, `lnkTicketToDoc_lnktickettodoc`.`document_id` AS `lnkTicketToDocdocument_id`, `Document_document_id_document`.`name` AS `lnkTicketToDocdocument_name`, CAST(CONCAT(COALESCE(`lnkTicketToDoc_lnktickettodoc`.`ticket_id`, '')) AS CHAR) AS `lnkTicketToDocfriendlyname`, CAST(CONCAT(COALESCE(`Ticket_ticket`.`ref`, '')) AS CHAR) AS `lnkTicketToDocticket_id_friendlyname`, `Ticket_ticket`.`finalclass` AS `lnkTicketToDocticket_id_finalclass_recall`, CAST(CONCAT(COALESCE(`Document_document_id_document`.`name`, '')) AS CHAR) AS `lnkTicketToDocdocument_id_friendlyname`, `Document_document_id_document`.`finalclass` AS `lnkTicketToDocdocument_id_finalclass_recall` FROM `lnktickettodoc` AS `lnkTicketToDoc_lnktickettodoc` INNER JOIN (`ticket` AS `Ticket_ticket` ) ON `lnkTicketToDoc_lnktickettodoc`.`ticket_id` = `Ticket_ticket`.`id` INNER JOIN (`document` AS `Document_document_id_document` ) ON `lnkTicketToDoc_lnktickettodoc`.`document_id` = `Document_document_id_document`.`id` WHERE ((`Ticket_ticket`.`id` = '5') AND (`lnkTicketToDoc`.`org_id` IN (1))) ORDER BY `lnkTicketToDocfriendlyname` ASC , mysql_error = Unknown column 'lnkTicketToDoc.org_id' in 'where clause', mysql_errno = 1054.
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
Fatal error, ASK cannot continue.
Error: Failed to issue SQL query: query = SELECT DISTINCT `lnkTicketToDoc_lnktickettodoc`.`id` AS `lnkTicketToDocid`, `lnkTicketToDoc_lnktickettodoc`.`ticket_id` AS `lnkTicketToDocticket_id`, `Ticket_ticket`.`ref` AS `lnkTicketToDocticket_ref`, `lnkTicketToDoc_lnktickettodoc`.`document_id` AS `lnkTicketToDocdocument_id`, `Document_document_id_document`.`name` AS `lnkTicketToDocdocument_name`, CAST(CONCAT(COALESCE(`lnkTicketToDoc_lnktickettodoc`.`ticket_id`, '')) AS CHAR) AS `lnkTicketToDocfriendlyname`, CAST(CONCAT(COALESCE(`Ticket_ticket`.`ref`, '')) AS CHAR) AS `lnkTicketToDocticket_id_friendlyname`, `Ticket_ticket`.`finalclass` AS `lnkTicketToDocticket_id_finalclass_recall`, CAST(CONCAT(COALESCE(`Document_document_id_document`.`name`, '')) AS CHAR) AS `lnkTicketToDocdocument_id_friendlyname`, `Document_document_id_document`.`finalclass` AS `lnkTicketToDocdocument_id_finalclass_recall` FROM `lnktickettodoc` AS `lnkTicketToDoc_lnktickettodoc` INNER JOIN (`ticket` AS `Ticket_ticket` ) ON `lnkTicketToDoc_lnktickettodoc`.`ticket_id` = `Ticket_ticket`.`id` INNER JOIN (`document` AS `Document_document_id_document` ) ON `lnkTicketToDoc_lnktickettodoc`.`document_id` = `Document_document_id_document`.`id` WHERE ((`Ticket_ticket`.`id` = '5') AND (`lnkTicketToDoc`.`org_id` IN (1))) ORDER BY `lnkTicketToDocfriendlyname` ASC , mysql_error = Unknown column 'lnkTicketToDoc.org_id' in 'where clause', mysql_errno = 1054.