File Upload without error but file doesnt saved.

Archived from the Xataface Users forum.

zopemgr — Wed Apr 19, 2006 9:40 pm

Dear all,

i got a problem with upload function in this great product (dataface) . i use both of method (save in database and also on directory). there is no error message appear but the file is not saved in both of method.

I running Windows XP Profesional dan PHP 4. i try using phpMyAdmin to check if theres error configuration, but it’s work properly. please help me.. almost entire site in my project using dataface..but i stuck for this problem.

TIA…

cheers,

panji.

---

zopemgr — Thu Apr 20, 2006 1:08 am

for more information, i try to examine code for record at IO.php.. and i trace it to file Querybuilder.php

and i found that blob field is never rendered as SQL statement.. for the example at my problem the SQL statement is like this one :

INSERT INTO uh ) VALUES )

FYI, i only define three field (pile, pile_filename,pile_mimetype)

please help me…

cheers,

panji

---

shannah — Thu Apr 20, 2006 8:23 am

Hi Panji,

It looks like you may not have a primary key defined for this table. Correct me if I’m wrong. If you can post the table definition and your fields.ini file I can take a look.

-Steve

---

zopemgr — Thu Apr 20, 2006 6:31 pm

Hello Mr. Steve,

Thanks for your respon, i already define primary key form my table, here my table definition:
table name : uh
Id int(11) NOT NULL auto\_increment, pile varchar(255) default NULL, tes tinyint(4) default NULL, PRIMARY KEY (Id`)

and this my field.ini definition :

[pile]
Type = container
widget:type = file

i already try change the structure as blob datatype and attach two more field named as pile_mimetype, and pile_filename. but still got the same problem. is it possible this problem arise because i use apache that running in windows envinronmet? Today..i setup new server running Linux..hopefully can solve this problem..

again.. nice product from you mr. steve

TIA,

cheers,

panji

---

shannah — Thu Apr 20, 2006 8:37 pm

Hi Panji,

Thanks for bringing this to light. I had to do some digging, but I have found the problem. I have filed a bug report and posted a fix at http://sourceforge.net/tracker/index.php?func=detail&aid=1473981&group_id=153729&atid=788932

Let me know how it goes.

-Steve

---

zopemgr — Thu Apr 20, 2006 11:56 pm

Hello Mr. Steve..

Thank’s for your help…and again it’s work for me.. thanks a lot for your help.. and now, i go straight implement my document system using dataface perfectly.

cheers,

panji