Hello -
EDocMan has been running just fine until this evening. Now when I click on "Document" I receive the following 500 Error:
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'LILE '%national%' OR a.description LIKE '%national%') ORDER BY a.id asc' at line 7 SQL=SELECT a.*, ag.title AS access_level, uc.name AS editor, cat.title AS category_title FROM `lvbwg_edocman_documents` AS a LEFT JOIN lvbwg_users AS uc ON uc.id=a.checked_out LEFT JOIN lvbwg_viewlevels AS ag ON ag.id = a.access LEFT JOIN lvbwg_edocman_document_category AS dc ON a.id = dc.document_id LEFT JOIN lvbwg_edocman_categories AS cat ON dc.category_id = cat.id WHERE (a.title LILE '%national%' OR a.description LIKE '%national%') ORDER BY a.id asc You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'LILE '%national%' OR a.description LIKE '%national%') ORDER BY a.id asc' at line 7 SQL=SELECT a.*, ag.title AS access_level, uc.name AS editor, cat.title AS category_title FROM `lvbwg_edocman_documents` AS a LEFT JOIN lvbwg_users AS uc ON uc.id=a.checked_out LEFT JOIN lvbwg_viewlevels AS ag ON ag.id = a.access LEFT JOIN lvbwg_edocman_document_category AS dc ON a.id = dc.document_id LEFT JOIN lvbwg_edocman_categories AS cat ON dc.category_id = cat.id WHERE (a.title LILE '%national%' OR a.description LIKE '%national%') ORDER BY a.id asc You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'LILE '%national%' OR a.description LIKE '%national%') ORDER BY a.id asc' at line 7 SQL=SELECT a.*, ag.title AS access_level, uc.name AS editor, cat.title AS category_title FROM `lvbwg_edocman_documents` AS a LEFT JOIN lvbwg_users AS uc ON uc.id=a.checked_out LEFT JOIN lvbwg_viewlevels AS ag ON ag.id = a.access LEFT JOIN lvbwg_edocman_document_category AS dc ON a.id = dc.document_id LEFT JOIN lvbwg_edocman_categories AS cat ON dc.category_id = cat.id WHERE (a.title LILE '%national%' OR a.description LIKE '%national%') ORDER BY a.id asc You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'LILE '%national%' OR a.description LIKE '%national%') ORDER BY a.id asc' at line 7 SQL=SELECT a.*, ag.title AS access_level, uc.name AS editor, cat.title AS category_title FROM `lvbwg_edocman_documents` AS a LEFT JOIN lvbwg_users AS uc ON uc.id=a.checked_out LEFT JOIN lvbwg_viewlevels AS ag ON ag.id = a.access LEFT JOIN lvbwg_edocman_document_category AS dc ON a.id = dc.document_id LEFT JOIN lvbwg_edocman_categories AS cat ON dc.category_id = cat.id WHERE (a.title LILE '%national%' OR a.description LIKE '%national%') ORDER BY a.id asc
I did not make any changes to the component. Would like any assistance possible please.
Thanks!
JM
