I have another one for you. Sometimes updating a record containing a longblob binary (jpeg ~ 1MB) yields the following error:
Fatal error: Allowed memory size of 8388608 bytes exhausted (tried to allocate 970418 bytes) in /usr/src/dataface/Dataface/QueryBuilder.php on line 263
The server has plenty of resources. Other times it just works. What have I done now??? Deleting the upload file yields a successful update, and the fields.ini file has not changes since my post last night.
Here is my table definition:
Social varchar(9) utf8_general_ci No
Last varchar(25) utf8_general_ci No
First varchar(20) utf8_general_ci No
Middle varchar(15) utf8_general_ci Yes NULL
Address1 varchar(25) utf8_general_ci No
Address2 varchar(25) utf8_general_ci Yes NULL
City varchar(15) utf8_general_ci No
State varchar(2) utf8_general_ci No
Zip int(10) No
Phone1 varchar(12) utf8_general_ci No
Phone2 varchar(12) utf8_general_ci Yes NULL
Phone3 varchar(12) utf8_general_ci Yes NULL
DriversLicense varchar(20) utf8_general_ci No
HireDate date No
ClassroomOne date No
ClassroomTwo date No
Weapons date No
PayRate float No
Land tinyint(1) Yes NULL
Maritime tinyint(1) Yes NULL
Armed tinyint(1) Yes NULL
NOC tinyint(1) Yes NULL
Comment text utf8_general_ci No
Photo longblob BINARY Yes NULL
Photo_mimetype varchar(64) utf8_general_ci Yes NULL
Photo_filename varchar(64) utf8_general_ci Yes NULL
