Seems to me like, after reading many articles and manuals, then modifying the max_allowed_packet settings in my.ini(yes, the one it uses), my database still won't accept binaries larger than 16MB.
I know it's a setting concerning MySQL since it's at that level that it gets stopped. I tried to modify a file and changed it successfully to a higher, but less than 16MB filesize, but when I tried changing it to a file that had a larger than 16MB filesize, it would'nt work.
I changed the max_allowed_packet to 32M for both mysql and mysqld in my.ini (I made a mysql show variables at the command line to verify the changes and they we're perfect). What am I doing wrong? It's not the version since I use 4.1.9 and since 4.0, the limit is 1GB per data field. I'm also using the right field type, which is longblob.
If anyone can give me a hand on this one, especially if you've encountered and solved this problem before, I'd really appreciate the help! 🙂
-Sneef