File Upload Problem

so

someguy2k 17 Feb, 2011

I'm having a difficult time resolving a file-upload problem. I have a dynamic form working perfectly with the exception of my Fileupload field. When "enabled uploads" is set to No, I am able to save the filename to the database.

When I have "enabled uploads" set to Yes, files are renamed emailed and uploaded BUT the filename is not saved to the database.

This is what I'm using to dynamically load form fields...

<?php
...
//file upload section
echo "<div class='form_item'>
<div class='form_element cf_fileupload'>
<input class='cf_fileinput cf_inputbox' title='' size='10' id='$file' name='$file' type='file' />";

?>

Any suggestions?

so

someguy2k 17 Feb, 2011

Forgot to include my field name/allowed extension...

fileupload_1:jpg|png|pdf|xls{9999-1},
fileupload_2:jpg|png|pdf|xls{9999-1},fileupload_3:jpg|png|pdf|xls{9999-1},
fileupload_4:jpg|png|pdf|xls{9999-1},fileupload_5:jpg|png|pdf|xls{9999-1},
fileupload_6:jpg|png|pdf|xls{9999-1}

Gr

GreyHead 17 Feb, 2011

Hi someguy2k,

ChronoForms uses a stored table definition to write records to the database, Almost certainly this doesn't include fileupload_1, fileupload_2, etc.

What columns do you actually have in the database record to store all the filenames?

Bob

so

someguy2k 17 Feb, 2011

The columns names are fileupload_1, fileupload_2, fileupload_3 etc...

if I change the form field to a text box or set enable uploads to No it works. Meaning it saves to the DB (fileupload_1, etc..)

<input class='cf_textbox' title='' size='10' id='$file' name='$file' type='text' />

Gr

GreyHead 17 Feb, 2011

Hi someguy2k,

Please turn debug on in the form General Tab, then submit the form and post the debug results here.

Bob

so

someguy2k 18 Feb, 2011

Gr

GreyHead 18 Feb, 2011

Hi someguy2k,

Thanks for the admin login. You didn't mention that you weren't using ChronoForms to handle the file uploads :-(

Not problem but it just means that you need to add the PHP to add the file names into the $_POST array before the DB Connection runs.

Bob

re

redrings 25 Feb, 2011

I hope I'm not hijacking this post, but I'm having a very similar problem; however, I AM using chronoforms to handle the file uploads.

Also, it seems that sometimes it is storing the image file locations in the database, and sometimes it is not (well, make that most of the time it is not). I've tested the form many times from my machine and it works for me every time, but since we've made the form active and started accepting registrations the problem has shown up. The files upload successfully regardless of whether or not the filename gets store in the database, so that is good, but I am having to go into the database and add the missing filenames (by attempting to match the timestamp to the entry) so that the chronoconnectivity page works right.

Here is a link to the form: http://entrepreneurship.okstate.edu/creativity/contests/current/enter
and the connectivity page: http://entrepreneurship.okstate.edu/creativity/contests/current/entries

Any ideas on how I can make sure the filenames are getting stored in the db?

Thanks!

Gr

GreyHead 25 Feb, 2011

Hi redrings,

Nothing very useful to suggest here. ChronoForms is pretty reliable in saving stuff. I can only guess that with 10 uploads on the same page somethign is timing out before the uploads are all complete.

Bob