Hi there,
Our end user, no matter super user or admin if rights assigned, press on Edocman button to upload file, following error pop up.
500 SQL=SELECT a.*, ag.title AS access_level, uc.name AS editor, cat.title AS category_title FROM `OTDB1_edocman_documents` AS a LEFT JOIN OTDB1_users AS uc ON uc.id=a.checked_out LEFT JOIN OTDB1_viewlevels AS ag ON ag.id = a.access LEFT JOIN OTDB1_edocman_document_category AS dc ON a.id = dc.document_id LEFT JOIN OTDB1_edocman_categories AS cat ON dc.category_id = cat.id WHERE a.published=1 ORDER BY SQL=SELECT a.*, ag.title AS access_level, uc.name AS editor, cat.title AS category_title FROM `OTDB1_edocman_documents` AS a LEFT JOIN OTDB1_users AS uc ON uc.id=a.checked_out LEFT JOIN OTDB1_viewlevels AS ag ON ag.id = a.access LEFT JOIN OTDB1_edocman_document_category AS dc ON a.id = dc.document_id LEFT JOIN OTDB1_edocman_categories AS cat ON dc.category_id = cat.id WHERE a.published=1 ORDER BY LIMIT 0, 20 SQL=SELECT a.*, ag.title AS access_level, uc.name AS editor, cat.title AS category_title FROM `OTDB1_edocman_documents` AS a LEFT JOIN OTDB1_users AS uc ON uc.id=a.checked_out LEFT JOIN OTDB1_viewlevels AS ag ON ag.id = a.access LEFT JOIN OTDB1_edocman_document_category AS dc ON a.id = dc.document_id LEFT JOIN OTDB1_edocman_categories AS cat ON dc.category_id = cat.id WHERE a.published=1 ORDER BY
Is there any problem in setup or bugs? Anyway to solve it?
Thanks in advance
KT