Invision Community 4: SEO, prepare for v5 and dormant account notifications By Matt Monday at 02:04 PM
H5K Posted February 27, 2023 Posted February 27, 2023 (edited) Hi, Our community allows users to upload very large videos to the gallery. We recently had to change the image_file_size column datatype in the gallery_images table from INT to BIGINT to support this. Reporting this because now we're getting a warning in the AdminCP because we changed the table. Tagging @Olivia Clark and @Andy Millne since you two seem to be very familiar with the recent gallery changes and probably can confirm if this is a bug or intended. Thanks Edited February 27, 2023 by H5K
Marc Posted February 27, 2023 Posted February 27, 2023 That would be intended. If you change a field type, the system will notice that field type as being outside what the default is, and try to correct it
H5K Posted February 28, 2023 Author Posted February 28, 2023 19 hours ago, Marc Stridgen said: That would be intended. If you change a field type, the system will notice that field type as being outside what the default is, and try to correct it Thank you for the response and apologies for the confusion. I was not questioning whether the table modification message was intended or not. I am questioning whether it is intended for gallery_images.image_file_size to be an int and not a bigint. The gallery has recently improved support for videos which can be considerably large. The reason we had to change the column datatype is because our users got an error when they tried to upload videos that were too large.
Marc Posted February 28, 2023 Posted February 28, 2023 Ive actually added this as a bug report so it can be looked into. If this is the case, its very likley it needs to be increased Martin A. 1
Solution Marc Posted September 6, 2023 Solution Posted September 6, 2023 This issue was resolved in the recently released 4.7.13 release. Please update in order to fix this issue, and if you see any problem after that point, please let us know. H5K 1
Recommended Posts