Hi,

when I attempt to upload a plain JPEG file via the File Manager, UBBT fails with this error message:

Script: D:\_web\ptforum7\scripts\filemanager.inc.php
Line#: 282
SQL Error: Incorrect integer value: '' for column 'FILE_SIZE' at row 1
SQL Error #: 1366
Query: UPDATE ubbt_FILES SET FILE_NAME = '1854.jpg', FILE_ORIGINAL_NAME = 'Image1.jpg' , FILE_WIDTH = 0 , FILE_HEIGHT = 0 , FILE_SIZE = '' WHERE FILE_ID = 1854


The script is attempting to assign an empty string (?) to FILE_SIZE?

I'm getting this same error.

Do I get bonus points for fixing this myself?


In the file /scripts/filemanager.inc.php, add this code after line 272:


It should be just before the line that reads:


Of course, be sure to make a copy of the original file in case you really break some thing. I believe this same script is used in image gallery as well. Hopefully this fix will be in 7.4.2.

Yes you do, thank you Brian

Thanks for the fix. Have this in for 7.4.2.