View ProjeQtOr On SourceForge.net
ProjeQtOr - Project Management Tool
Support us on Capterra
OIN - Open Invention Network
ProjeQtOr free project management software - Document upload and attach File errors - ProjeQtOr
 

Document upload and attach File errors

More
31 Oct 2018 16:28 #1 by bassem
Hello,
I have change the maximum size of the attached files in the parameter to :52428800
then in php.in file, i have increase upload_max_filesize and post_max_size to 51200 M

but wen i want to upload a document or attach a file with 5 Gb of size i have these error messages ( see attached part )

"SQLSTATE[22003]: Numeric value out of range: 1264 Out of range value for column 'fileSize' at row 1"

"Le chargement de fichier a échoué. Veuillez réessayer.
Si le problème persiste, peut-être que la taille de votre fichier est-elle trop importante."

and here are the logs:

2018-10-31 15:06:00.372 ***** ERROR ***** [V7.2.5] For query : insert into attachment ( refType , refId , idUser , creationDate , fileName , mimeType , fileSize , type , idPrivacy ) values ('Ticket', '002976', '184', '2018-10-31 15:06:00', '5go.rar', 'application/octet-stream', '6460664301', 'file', '1')
2018-10-31 15:06:00.376 ***** ERROR ***** [V7.2.5] Strack trace :
2018-10-31 15:06:00.380 ***** ERROR ***** [V7.2.5] #0 Sql->query called at [C:\wamp64\www\projeqtor\model\persistence\SqlElement.php:1193]
2018-10-31 15:06:00.384 ***** ERROR ***** [V7.2.5] #1 SqlElement->insertSqlElement called at [C:\wamp64\www\projeqtor\model\persistence\SqlElement.php:992]
2018-10-31 15:06:00.387 ***** ERROR ***** [V7.2.5] #2 SqlElement->saveSqlElement called at [C:\wamp64\www\projeqtor\model\persistence\SqlElement.php:655]
2018-10-31 15:06:00.391 ***** ERROR ***** [V7.2.5] #3 SqlElement->save called at [C:\wamp64\www\projeqtor\model\Attachment.php:114]
2018-10-31 15:06:00.394 ***** ERROR ***** [V7.2.5] #4 Attachment->save called at [C:\wamp64\www\projeqtor\tool\saveAttachment.php:231]

2018-10-31 15:14:40.795 ***** ERROR ***** [V7.2.5] Exception-[22003] SQLSTATE[22003]: Numeric value out of range: 1264 Out of range value for column 'fileSize' at row 1
2018-10-31 15:14:40.799 ***** ERROR ***** [V7.2.5] For query : insert into documentversion ( name , fullName , version , revision , fileName , fileSize , mimeType , versionDate , createDateTime , idDocument , idAuthor , idStatus , isRef , approved , idle ) values ('V1.0', '-CTRCT-6-5go-V1.0.rar', '1', '0', '5go.rar', '6460664301', 'application/octet-stream', '2018-10-31', '2018-10-31 15:14:40', '000009', '184', '1', '0', '0', '0')
2018-10-31 15:14:40.803 ***** ERROR ***** [V7.2.5] Strack trace :
2018-10-31 15:14:40.807 ***** ERROR ***** [V7.2.5] #0 Sql->query called at [C:\wamp64\www\projeqtor\model\persistence\SqlElement.php:1193]
2018-10-31 15:14:40.811 ***** ERROR ***** [V7.2.5] #1 SqlElement->insertSqlElement called at [C:\wamp64\www\projeqtor\model\persistence\SqlElement.php:992]
2018-10-31 15:14:40.814 ***** ERROR ***** [V7.2.5] #2 SqlElement->saveSqlElement called at [C:\wamp64\www\projeqtor\model\persistence\SqlElement.php:655]
2018-10-31 15:14:40.818 ***** ERROR ***** [V7.2.5] #3 SqlElement->save called at [C:\wamp64\www\projeqtor\model\DocumentVersionMain.php:162]
2018-10-31 15:14:40.821 ***** ERROR ***** [V7.2.5] #4 DocumentVersionMain->save called at [C:\wamp64\www\projeqtor\tool\saveDocumentVersion.php:222]


I wanted to know the maximum size of document upload and file attached to projeqtor.
Thank you for your help.
Attachments:

Please Log in or Create an account to join the conversation.

More
03 Nov 2018 16:09 #2 by babynus
Check format system of the disks of the server : FAT32 won't accept files over 4Gb.

Babynus
Administrator of ProjeQtOr web site

Please Log in or Create an account to join the conversation.

More
05 Nov 2018 10:18 #3 by bassem
sorry but I'm using the NTFS file system.
In fact, the attached file arrives correctly on the reception folder, but the modifications does not register correctly on ProjeQtOr database.
Attachments:

Please Log in or Create an account to join the conversation.

More
05 Nov 2018 10:39 #4 by babynus
It seems it is db insert that fails.
Cannot insert 1264 into column fileSize which is int(12)...
Which db are you using ? (mysql or postgres, and version)

Babynus
Administrator of ProjeQtOr web site

Please Log in or Create an account to join the conversation.

More
05 Nov 2018 11:00 #5 by bassem
I use MYSQL 5.7.21
Attachments:

Please Log in or Create an account to join the conversation.

More
05 Nov 2018 11:45 #6 by babynus
It is limitation of INT in MySQl (never faced it on my side ;) )

Try update db :
ALTER TABLE attachment` CHANGE `fileSize` `fileSize` BIGINT(12) UNSIGNED;
ALTER TABLE `documentversion` CHANGE `fileSize` `fileSize` BIGINT(12) UNSIGNED;

Babynus
Administrator of ProjeQtOr web site
The following user(s) said Thank You: bassem

Please Log in or Create an account to join the conversation.

Moderators: babynusprotion
Time to create page: 0.062 seconds

Cookies settings

×

Functional Cookies

Ce site utilise des cookies pour assurer son bon fonctionnement et ne peuvent pas être désactivés de nos systèmes. Nous ne les utilisons pas à des fins publicitaires. Si ces cookies sont bloqués, certaines parties du site ne pourront pas fonctionner.

Session

Please login to see yours activities!

Other cookies

Ce site web utilise un certain nombre de cookies pour gérer, par exemple, les sessions utilisateurs.