Results 1 to 8 of 8

Thread: Documents error in 4.5

  1. #1
    HenrikE is offline Sugar Community Member
    Join Date
    Sep 2006
    Posts
    94

    Question Documents error in 4.5

    When I try to view a document that I've uploaded I get the following error:

    Error retrieving Document list: Query Failed:SELECT documents.* ,document_revisions.revision as latest_revision ,document_revisions.date_entered as last_rev_create_date ,document_revisions.created_by as last_rev_created_by FROM document_revisions,documents where documents.deleted=0 AND document_revisions.deleted=0 AND documents.document_revision_id = document_revisions.id ORDER BY name asc LIMIT 0,1::MySQL error 1054: Unknown column 'name' in 'order clause'

    Any Ideas?
    Attached Files Attached Files

  2. #2
    andydreisch's Avatar
    andydreisch is offline Sugar Team Member
    Join Date
    Apr 2005
    Location
    San Jose
    Posts
    2,080

    Default Re: Documents error in 4.5

    Hi HenrikE, I see from your diag info (thanks for sending!) that your MySQL version is 3.x.

    Release 4.5 requires MySQL 4.1.2 or higher (for internalization purposes) as stated in the release notes (PDF).

    Hope this helps,

    Andy
    Andy Dreisch
    Vice President, Online Team


    Check out our Podcasts!
    Sugar University for training
    Sugar Wiki for developer and user help
    SugarForge for modules, themes, lang packs
    SugarExchange for production-ready extensions
    Enter/view bugs via the Sugar bug tracker

  3. #3
    HenrikE is offline Sugar Community Member
    Join Date
    Sep 2006
    Posts
    94

    Default Re: Documents error in 4.5

    Quote Originally Posted by andydreisch
    Hi HenrikE, I see from your diag info (thanks for sending!) that your MySQL version is 3.x.

    Release 4.5 requires MySQL 4.1.2 or higher (for internalization purposes) as stated in the release notes (PDF).

    Hope this helps,

    Andy
    Hi Andy!
    Thanks for looking into this. We use mysql-server 5.0.24a-community-nt. The 3.X is the mysql-client.
    Some more errors in documents:
    If I try edit a document and then click on "download" it I get:
    Fatal error: Call to a member function on a non-object in D:\web\mysite\www-root\sugarsuite\modules\Users\User.php on line 646
    I'll PM you some additional information.

    //Henrik

  4. #4
    HenrikE is offline Sugar Community Member
    Join Date
    Sep 2006
    Posts
    94

    Default Re: Documents error in 4.5

    *bumpelidump*

  5. #5
    cywolf's Avatar
    cywolf is offline Sugar Community Member
    Join Date
    Oct 2005
    Location
    Toronto, Canada
    Posts
    223

    Default Re: Documents error in 4.5

    You would likely need a 4.1.x+ version of the client libraries as well, to properly support Unicode characters.
    Andrew Whitehead
    The Long Reach Corporation
    http://infoathand.com

  6. #6
    HenrikE is offline Sugar Community Member
    Join Date
    Sep 2006
    Posts
    94

    Default Re: Documents error in 4.5

    The "Query Failed:" - Error is gone now. but I still got the error "D:\web\mysite\www-root\sugarsuite\modules\Users\User.php on line 646" when I try to download the file. I've got the same error when trying to download an email-attachment. The files do exist on the server, I've checked that. Any Ideas?

  7. #7
    HenrikE is offline Sugar Community Member
    Join Date
    Sep 2006
    Posts
    94

    Default Re: Documents error in 4.5

    I know I'm taliking to myself but I solved the problem by removing zuckerdocs. It doesn't work with 4.5.

  8. #8
    kirkland is offline Sugar Community Member
    Join Date
    Mar 2005
    Posts
    75

    Default Re: Documents error in 4.5

    I'm getting this problem, too, using IE6 on 4.5.0d of SugarCRM. It downloads fine with MySQL.

    I'm running 5.0.26 of MySQL, but I don't know about "client libraries" since I didn't think I installed anything special there unless it comes bundled with SugarCRM.

    Any ideas on how to fix this?

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
  •