Results 1 to 2 of 2

Thread: Document Error Help

  1. #1
    Uzaree is offline Sugar Community Member
    Join Date
    Jun 2006
    Posts
    10

    Default Document Error Help

    After I loaded a document I get the following error while trying to open the document.

    Sugar 4.2

    Error retrieving Document list: Query Failed: SELECT document_revisions.id , document_revisions.filename , document_revisions.revision , document_revisions.date_entered , CONCAT(IFNULL(jt0.first_name,''),' ',IFNULL(jt0.last_name,'')) created_by_name , jt0.created_by created_by_name_owner , 'Users' created_by_name_mod, document_revisions.change_log , document_revisions.document_id , document_revisions.created_by , 'therevisions' panel_name FROM document_revisions LEFT JOIN users jt0 ON jt0.id= revisions.created_by AND jt0.deleted=0 AND jt0.deleted=0 where ( document_revisions.document_id= '54472e62-4bb5-11f9-20ec-44a1434af610' AND document_revisions.deleted=0) AND document_revisions.deleted=0 LIMIT 0,10::MySQL error 1109: Unknown table 'revisions' in on clause

  2. #2
    Uzaree is offline Sugar Community Member
    Join Date
    Jun 2006
    Posts
    10

    Default Re: Document Error Help

    Also each time I upload a document it puts it as 600, how to I make it automaticly set it as 0755?

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •