Version 5.2a document upload problem

[haffu]

Hi,

We installed sugarCRM community Version 5.2a and the installation went without problems. However when I started to check is everything working right I runned to this problem.

When I try to upload new document I get this error

"Query Failed:INSERT into document_revisions set id='ec212c3c-1a0d-b63e-9ba7-49ae6955ca56', change_log='Document Created', document_id='e736d94f-9014-b800-460e-49ae69d1e835', date_entered='2009-03-04 11:42:41', created_by='1', revision='2', deleted='0', date_modified='2009-03-04 11:42:41'::MySQL error 1364: Field 'filename' doesn't have a default value"

Seems like there is a bug somewhere in the software.

Have somebody having this problem also? Any ideas how to fix it?

-H

PHP built On: Windows NT CT2291 5.2 build 3790
Database Version: 5.1.30-community (MySQL)
PHP Version: 5.1.6
Web Server: Microsoft-IIS/6.0

[crmsiva]

Hi

Check this

http://bugs.mysql.com/bug.php?id=14306

[haffu]

Thanks for your idea but I don't think this is MySQL-error.

Database table document_revisions have the field "filename" and it's marked as "not null".

Now if we check the insert sentence we can see that there is set
id, change_log, document_id, date_entered. create_by. revision, deleted, date_modified but not input for filename.

INSERT into document_revisions set id='ec212c3c-1a0d-b63e-9ba7-49ae6955ca56', change_log='Document Created', document_id='e736d94f-9014-b800-460e-49ae69d1e835', date_entered='2009-03-04 11:42:41', created_by='1', revision='2', deleted='0', date_modified='2009-03-04 11:42:41

[sanjaykatiyar1]

I have same version of sugar52a and there is no issues for creating Documents Revisions on a Documents.

Can you check your sugarcrm.log file for further clue.

[haffu]

I found the solution to this problem.

It weren't a bug in the code. User permissions were missing from windows/temp folder that php uses during the upload.

So we added write permissions to the user to temp-folder and now the document upload works fine.

-H

ps. thanks for replies and ideas.