Documents V4.5.1i

[Dycobee]

Hello,

I have over fourty items in the modules documents.
I have one user accounts with administrator privilege and the admin account.
When I list the documents with the admin I find all documents.
However when I want to list with the other accounts (even the other admin account) I do not see anything.
Of course I clicked on empty research and also db repair and the relationship.

With the user account I can access the list of document with the popup window for attachment on the e-mail module.

What can be the cause of such behaviour?

Help me please

[Dycobee]

No idea for my problem ?

[clint]

Are you using the Professional edition? It sounds like your other users don't have persmission to see the team that the Documents are assigned to.

[Dycobee]

I'am the open source edition.
I'have all permission , it is a admin user.

[Dycobee]

There is my logs error

 Wed Apr  2 15:31:53 2008,182 [24411] INFO SugarCRM - Query: SELECT  documents.id , documents.document_name , documents.category_id  , jt0.user_name created_by
_name , jt0.created_by created_by_name_owner  , 'Users' created_by_name_mod, documents.active_date , documents.exp_date , documents.created_by  FROM documents
   LEFT JOIN  users jt0 ON
jt0.id= documents.created_by AND jt0.deleted=0
 AND jt0.deleted=0 where documents.deleted=0 AND document_revisions.id = documents.document_revision_id LIMIT 0,21
Wed Apr  2 15:31:53 2008,183 [24411] INFO SugarCRM - Query Execution Time:0.000306
Wed Apr  2 15:31:53 2008,183 [24411] ERROR SugarCRM - MySQL error 1054: Unknown column 'document_revisions.id' in 'where clause' 
  

The same problem appears now also with the admin user.
This problem started after selecting the documents list link when before we used the document tab to display the list.

[Dycobee]

Well...

I have found a workaround.
I have comment this line in file modules/Documents/Listview.php

 // to ensure that only the latest revision is being returned for the document list.
//$params['custom_where'] = ' AND document_revisions.id = documents.document_revision_id'; 
  

I suppose that it is not the solution as we removed all revisions test.