I recently started to use xataface , in Mysql/PHP i'm under intermediate but not completely nooby. I have installed xataface and created (automaticly) database interface app for my db "pisma" . There's a table "pism" . It will simply store letters . Fields "ID" , "From" , "To" , "Date" , "Preview"(jpeg scan) and "Comments" .
1. So first i tried with blob . Gave attributes to "Preview" Type = LongBLOB , created "Preview_mimetype" and "Preview_filename" Type= varchar (as in the documentation) . Creating new records = ok ,but not seeing "Preview" field ,just "Preview_mimetype" and "Preview_filename" . Images got uploaded (i see them in phpmyadmin) but while trying to preview in xataface :"handleGetBlob() should not be called statically, assuming $this from incompatible context in ....." . No way i can translate this error to human language
2. Tried with second method. Everything went well ,files are uploaded , link in "Preview" field ok, but when i'm trying to open i get a blank page (i think URL is correct = ....../index.php?-table=pism&-action=browse&-cursor=0&-skip=0&-limit=30&-mode=list&-recordid=pism%3FID%3D1 ) . Very funny thing about it : When adding new record i get a blank page too (URL=...index.php?-action=edit&-table=pism&LP=%3D42&--msg=Record+successfully+saved.).
Problem is hard to diagnose because i don't get error messages (method 2).
Maybe i got it all wrong with types or other attributes (both methods) ... ID(Primary index;INT) , From(INT) , TO(INT) , Date (Date) Preview(LONGBLOB(1meth) , VARCHAR(2meth)) .
Please help.
Thanks in advance