- Posts: 75
- Thank you received: 5
All questions about EDocman extension
ERROR 500 while organizing document
- agussol
- Topic Author
- Offline
- Senior Member
Less
More
12 years 6 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...
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.
- Tuan Pham Ngoc
- Offline
- Administrator
12 years 5 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
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
Support
Documentation
Information
Copyright © 2024 Joomla Extensions by Joomdonation. All Rights Reserved.
joomdonation.com is not affiliated with or endorsed by the Joomla! Project or Open Source Matters.
The Joomla! name and logo is used under a limited license granted by Open Source Matters the trademark holder in the United States and other countries.
The Joomla! name and logo is used under a limited license granted by Open Source Matters the trademark holder in the United States and other countries.