I have lost all my docman documents from my site map and rss feed since I updated my site to docman 2.12 (from docman 2.0). After some investigations, i have noticed that the auto-generated SQL below has the following line:

Code:

AND (`#__docman_documents`.`access` IN {aid} OR `#__docman_documents`.`access` = -1)

When i replace {aid} by '0' and run the query in phpadmin, i get a result. I tried without success to remove {aid} from the auto-generated SQL. What is the {aid} for? Can this be the problem or do you have some advice for me to get my document back? Auto-generated sql

Code:

SELECT `#__docman_documents`.`title`, CONCAT_WS('-',`#__docman_documents`.`docman_document_id`,`#__docman_documents`.`slug`) AS `alias`, `#__docman_categories`.`title` AS `cattitle`, `#__docman_categories`.`slug` AS `category_slug` FROM `#__docman_documents` JOIN `#__docman_categories` ON `#__docman_documents`.`docman_category_id` = `#__docman_categories`.`docman_category_id` JOIN `#__docman_category_relations` ON `#__docman_categories`.`docman_category_id` = `#__docman_category_relations`.`descendant_id` WHERE `#__docman_categories`.`enabled` = '1' AND `#__docman_category_relations`.`ancestor_id` = '1' AND (`#__docman_documents`.`access` IN {aid} OR `#__docman_documents`.`access` = -1) ORDER BY `#__docman_categories`.`created_on` ASC, `#__docman_documents`.`title` ASC

Thanks