UE4 File upload doesnt upload or write to database

Hi Folks,

Can you help.
Im getting the following error when uploading an image from the update page.

session_start() [function.session-start]: Cannot send session cache limiter - headers already sent (output started at /home/bakerbed/public_html/development/admin/range_Update.php:1) in /home/bakerbed/public_html/development/webassist/file_manipulation/helperphp.php on line 70

The image doesnt get uploaded, nor does it write the image name to the database.
ive gone through and done the normal, making sure theres no gaps between opening and closing php's etc and still it doesnt write.

If i remove the file upload facility and return the hidden text box to normal and type anything into it, it writes this value to the database without problems.

Cheers

Paul

most likely the include file is being included using the virtual() function instead of the require_once() function.

The virtual() function has a bug where it will write a carat at the start of the file causing the headers already sent error.

In the Site Settings, on the local info tab, there is a setting for "Create Links Relative To". Choosing "Site" causes Dreamweaver to use the virtual function. Chose "Document" instead, and Dreamweaver will use the require once function and avoid the headers already sent.

another thing to check is that the forms encoding type gets set to multipart/form-data.

If you insert the file field by going to Insert -> Form -> File Field, Dreamweaver will do this for you automatically, if you are just changing the hidden fields type to file manually though, you will also need to manually change the encoding type. do this by electing the form tag, and then in the property inspector, change the enctype dropdown list.

For storing the uplaoded file name in the database, you will need to use the data assist insert record server behavior.

See the "How to apply Digital File Pro to DataAssist Insert and Update pages" tutorial on the DataAssist support page:
dataassist/

Hi Jason,
The include files are all require once.
Im also using a dataassist generated insert page so the forms enc type is correct as well.
I have used DFP loads of times in projects and now im getting this error in this particular project using UE4

Any further help will be greatly appreciated

the other cause of the error at line 1 is an issue if the Unicode BOM signature is included in the page.

Go to Modify -> Page Properties

Select the Title and Encoding section.

make sure the Include Unicode Signature (BOM) option is not checked.

You may also need to open the file in an external text editor and select Save As and change the encoding to Western ISO 1

Hi Jason,
Non of that worked.
The only code on the page is generated by both DataAssist and UE4's file manipulation and HTML Editor.
ive removed HTML editor, UE4 and taken it back to just dataassist and it then works fine and records whatever you put in the text field in the database.
The issue seems to be with UE4

Ive attached it to see if you can identify the issue.

Cheers

Paul

i think the issue may be caused by using the mysql reserved word "range" for your table name.


This is a newer reserved word in mysql 5.5.:
reserved-words.html


when i tried to recreate your page, i got an SQL error message about range being invalid syntax.

try changing line 45:

$query_WADArange = sprintf("SELECT RangeID, RangeName, RangeDescription, RangeSpec, RangeImageLarge, RangeImageThumb, RangeImage3, RangeImage4, RangeCategory FROM range WHERE RangeID = %s", GetSQLValueString($ParamRangeID_WADArange, "int"));

to:

$query_WADArange = sprintf("SELECT RangeID, RangeName, RangeDescription, RangeSpec, RangeImageLarge, RangeImageThumb, RangeImage3, RangeImage4, RangeCategory FROM `range` WHERE RangeID = %s", GetSQLValueString($ParamRangeID_WADArange, "int"));

basicly, where changing "FROM range" to "FROM `range`"

Hi Jason,

This doesnt work.

Would that reserved mysql word not prevent me from writing anything to the database?
If i take out UE4 file manipulation and return it to a text box and write anything in it, it happily writes to the database, something that isnt happening when i reapply the UE4 file manipulation.

I have used DFP on other projects without any issues whatsoever, however I just cannot seem to understand where the error is laying with UE4 file manipulation incorporation

Cheers

Paul

Hi Jason

Ive rebuilt the page and ran a new instance of DataAssist and and included UE4 and file manipulation is running fine now,

I appreciate all your help and time.

Cheers

OK, glad to hear it is working.