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:wamp64wwwprojeqtormodelpersistenceSqlElement.php:1193]
2018-10-31 15:06:00.384 ** ERROR ** [V7.2.5] #1 SqlElement->insertSqlElement called at [C:wamp64wwwprojeqtormodelpersistenceSqlElement.php:992]
2018-10-31 15:06:00.387 ** ERROR ** [V7.2.5] #2 SqlElement->saveSqlElement called at [C:wamp64wwwprojeqtormodelpersistenceSqlElement.php:655]
2018-10-31 15:06:00.391 ** ERROR ** [V7.2.5] #3 SqlElement->save called at [C:wamp64wwwprojeqtormodelAttachment.php:114]
2018-10-31 15:06:00.394 ** ERROR ** [V7.2.5] #4 Attachment->save called at [C:wamp64wwwprojeqtortoolsaveAttachment.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:wamp64wwwprojeqtormodelpersistenceSqlElement.php:1193]
2018-10-31 15:14:40.811 ** ERROR ** [V7.2.5] #1 SqlElement->insertSqlElement called at [C:wamp64wwwprojeqtormodelpersistenceSqlElement.php:992]
2018-10-31 15:14:40.814 ** ERROR ** [V7.2.5] #2 SqlElement->saveSqlElement called at [C:wamp64wwwprojeqtormodelpersistenceSqlElement.php:655]
2018-10-31 15:14:40.818 ** ERROR ** [V7.2.5] #3 SqlElement->save called at [C:wamp64wwwprojeqtormodelDocumentVersionMain.php:162]
2018-10-31 15:14:40.821 ** ERROR ** [V7.2.5] #4 DocumentVersionMain->save called at [C:wamp64wwwprojeqtortoolsaveDocumentVersion.php:222]
I wanted to know the maximum size of document upload and file attached to projeqtor.
Thank you for your help.
Check format system of the disks of the server : FAT32 won't accept files over 4Gb.
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.
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)
I use MYSQL 5.7.21
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;