Issue with binary files
Archived from the Xataface Users forum.
wisni1rr — Tue Mar 06, 2012 12:15 pm
I have noticed this issue on binary files stored within and outside of the database. I have not problem uploading files. I am storing a picture file in the database per records and also storing a .pdf outside of the database. The problem is happening in both instances.
The problem I am having is: I decide to change the photo or pdf when one has already been placed in its spot. It confirms the new upload is fine. However it still displays the ‘old’ picture or pdf. I have tried changing the file name. Changing the file name seems to work for the .pdf file but does not change the internally stored pics. I tried deleting the upload using xataface framework and the file is said to delete successfully. The file contains ‘NO’ picture related info. I use the edit tab to a a picture and it ends up displaying the old picture but retains the new pictures name…
I have also deleted the picture entry in the database using myphpadmin. After I upload a new picture, it still displays the ‘old’ picture….
Any Ideas?
shannah — Tue Mar 06, 2012 12:48 pm
I think this is probably a bug with Xataface’s caching of blob fields. I have added it to the issue tracker.
http://bugs.weblite.ca/view.php?id=935
wisni1rr — Wed Mar 07, 2012 10:06 am
Thanks Steve,
Do you know how I can work around this issue?
shannah — Wed Mar 07, 2012 10:50 am
Are you on Windows or Linux?
shannah — Wed Mar 07, 2012 11:19 am
I have fixed it in SVN. Check the issue in issue tracker for details on getting the update.
wisni1rr — Tue Mar 13, 2012 9:51 am
I am using a linux webhost. The SVN update nearly fixes the problem. I can now upload different pictures in the same record and it updates correctly. However, if I delete a file using the red ‘X’ above the file picker and hit save, the ‘View Field Content New Window’ link reappears to the supposedly delete picture allowing a download of the previously deleted file.
Hope that helps. Thanks for fixing the main issue!
ADobkin — Tue Mar 13, 2012 11:13 am
I submitted a bug report about the latter issue a few months ago:
0000854: Deleting uploaded file (delete_file action) fails to null blob field
http://bugs.weblite.ca/view.php?id=854
wisni1rr — Tue Mar 13, 2012 11:26 am
Thanks for the scoop, ADobkin!
tanrosely — Tue Mar 20, 2012 7:31 pm
The problem I am having is: I decide to change the photo or pdf when one has already been placed in its spot. It confirms the new upload is fine. However it still displays the ‘old’ picture or pdf. I have tried changing the file name. Changing the file name seems to work for the .pdf file but does not change the internally stored pics. I tried deleting the upload using xataface framework and the file is said to delete successfully. The file contains ‘NO’ picture related info. I use the edit tab to a a picture and it ends up displaying the old picture but retains the new pictures name…!
shannah — Wed Mar 21, 2012 9:37 pm
What version of xataface?
Are you using a blob field or a container?