All questions about EDocman extension

ERROR 500 while organizing document

  • agussol
  • Topic Author
  • Offline
  • Senior Member
  • Senior Member
More
11 years 11 months ago #16035 by agussol
ERROR 500 while organizing document was created by agussol
Hello,

Go in backoffice, edocman > documents , try to oreder by state (published/unpublished)
Then :

Error 500 :
JDatabaseMySQLi::query: 1054 - Unknown column 'a.state' in 'order clause' SQL=SELECT a.*, ag.title AS access_level, uc.name AS editor, cat.title AS category_title FROM `extra_edocman_documents` AS a LEFT JOIN extra_users AS uc ON uc.id=a.checked_out LEFT JOIN extra_viewlevels AS ag ON ag.id = a.access LEFT JOIN extra_edocman_document_category AS dc ON a.id = dc.document_id LEFT JOIN extra_edocman_categories AS cat ON dc.category_id = cat.id ORDER BY a.state asc

You have to logout, then login to access Edocman again...

Thanks for responding Tuan, and please correct your component, and please integrate our upgrades...

Please Log in or Create an account to join the conversation.

More
11 years 10 months ago #16391 by Tuan Pham Ngoc
Replied by Tuan Pham Ngoc on topic Re: ERROR 500 while organizing document
Hi

Thanks for reporting. This issue is now fixed in version 1.1.0 .

Regards,

Tuan

Please Log in or Create an account to join the conversation.

Moderators: Mr. Dam