Update Blob field not working properly?

Archived from the Xataface Users forum.

jvinolas — Mon Mar 21, 2011 6:06 am

Hi Steve,

I have blob fields to store on mysql images that work as expected when creating a new table entry. The problem comes when I try to update a record that didn’t have the blob field already: the blob field seems to be updated, but not the _mimetype and _filename.

I don’t know if I’m doing something wrong or this is the default behaviour. Right now, I’m updating those fields myself with default data. How can I get mimetype and filename updated correctly (and if possible, automatically)?

Code: Select all

function beforeUpdate(&$record){    if($record->val('PDFOutline')){       $record->setValues(array('PDFOutline_mimetype' => 'image/jpeg','PDFOutline_filename' => 'user.jpg'));    } }

I also noticed that clicking on X to delete file, says that it went ok, but the blob is still there. Do I have to code the delete myself on beforeupdate() and beforeSave() events?

This is my blob definition in fields.ini:

Code: Select all

__sql__ = "select *, UserName as FOTO, CONTRACTE as CONTRACTECONF from users" [FOTO] widget:label="Fotografia" noLinkFromListView=1 [PDFOutline] widget:label = "Fotografia" widget:description = "Les imatges han de ser d'un màxim de 75x75 píxels." [PDFOutline_mimetype] visibility:find=hidden visibility:list=hidden visibility:browse=hidden visibility:update=hidden visibility:csv=hidden widget:type=hidden ignore=1 [PDFOutline_filename] visibility:find=hidden visibility:list=hidden visibility:browse=hidden visibility:update=hidden visibility:csv=hidden widget:type=hidden ignore=1

Thanks!

---

ADobkin — Wed Nov 02, 2011 1:14 am

jvinolas wrote:I also noticed that clicking on X to delete file, says that it went ok, but the blob is still there.

I had this same problem with deleting blob data. I submitted a report to the bug tracker about a month ago:

0000854: Deleting uploaded file (delete_file action) fails to null blob field