Documents error in 4.5

**HenrikE** · 2006-09-11, 07:55 PM

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?

**andydreisch** · 2006-09-11, 09:34 PM

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

**HenrikE** · 2006-09-12, 08:29 AM

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

**HenrikE** · 2006-09-13, 07:59 AM

*bumpelidump*

**cywolf** · 2006-09-13, 04:49 PM

You would likely need a 4.1.x+ version of the client libraries as well, to properly support Unicode characters.

**HenrikE** · 2006-09-13, 08:10 PM

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?

**HenrikE** · 2006-09-14, 08:23 AM

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

**kirkland** · 2006-10-16, 05:28 PM

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?