Hi Tuan,
I used to work with edocman 152
Just by chance (because edocman never appears amongst the extension having updates within the joomla backend interface), I discovered today that there was a new version 155.
I thought it would be a good idea to update... but it broke the whole system.
See the nice error message I get hereafter (and in attachment)
Why & what can be done to fix this ?
By the way, what are the improvements between 152 and 155 (I searched the site without success).
Txs in advance Tuan,
Marc
PS : by the way, I have just tried to install 152 on top of 155... and then edocman seems to work again.
1054
Unknown column 'a.ordering' in 'order clause' SQL=SELECT tbl.* FROM myprefix_edocman_documents AS tbl WHERE tbl.published=1 AND ((tbl.user_ids = '' AND tbl.access IN (1,1,2,6,7,15)) OR tbl.user_ids='666' OR tbl.user_ids LIKE '666,%' OR tbl.user_ids LIKE '%,666,%' OR tbl.user_ids LIKE '%,666' OR tbl.created_user_id=666) AND tbl.id IN (SELECT document_id FROM myprefix_edocman_document_category WHERE category_id = 37 ) AND tbl.language IN ('nl-NL','*', "") ORDER BY a.ordering DESC LIMIT 0, 50