Hi all; just wondering if somebody knows a script or way to list the MySQL server settings (similar to info.php for php). Specifically, I'm wondering about file insert sizes. I understand that there is a setting that can limit the size of a file used in the LOAD_FILE() MySQL function.
For some reason, using the function returns NULL for the column value. The file is world readable and DOES exist (ie. can load it in a browser). The file in question is only 87KB
INSERT INTO portfolio (image, thumbnail, title, description, category, materials, completed, posted) VALUES (LOAD_FILE('/home/xxxxx/public_html/temp/orig.jpg'), LOAD_FILE('/home/xxxxx/public_html/temp/thumb.jpg'), '', '', 'WoodCarving', '', '', CURDATE())Column 'image' cannot be null
Any help appreciated...
- Jeff W
