File

Strange things, if the UI behaved the same (adding multiple files etc.) for the Mac user as for you, the server side things should not behave differently.

I just hope EE 2.0 will have native support for something like “File”-functionality. The built-in mechanism is way too ancient nowadays.

Does anyone have any idea how to resolve this error?

I’m using 3.1.1 of the file extension.

I had the file extension running fine on my site for acouple months now, and I recently upgraded to 1.6.6 today and I added the Forum Module today as well, and now all of my SAEF pages with the file upload through Mark Huots extension are dead and are taking a dump when I try to upload images through them. This is the error I’m receiving when I click submit on my forms.

MySQL ERROR:

Error Number: 1054

Description: Unknown column 'field_id_31_img' in 'field list'

Query: INSERT INTO `cpexp_weblog_data` (`entry_id`, `weblog_id`, `field_id_24`, `field_id_31_img`, `field_ft_31`, `field_id_31_img_0`, `field_ft_24`, `site_id`) VALUES ('226', '2', '108', 'Array', 'file', 'Kalencia_portrait.jpg', 'none', '1')

This is the code for my SAEF which was working fine until today:

{exp:weblog:entries weblog="piece_info" orderby="date" limit="1" disable="trackbacks" author_id="CURRENT_USER"}
{exp:weblog:entry_form weblog="classroom" return="" use_live_url="no"}
<fieldset>
<legend>Add New Image to {title}</legend>
<ol>

<input type="hidden" class="hidden" name="title" id="title" value="{author}'s {title} Progress Image" />
<input type="hidden" class="hidden" name="allow_comments" id="allow_comments" value="y" />
<input type="hidden" class="hidden" name="field_id_24" value="{entry_id}" />

<li>
<label>File Upload:</label>
<input class="required file" id="file_content" title="Please upload a file. This field is required." name="field_id_31_img[]" type="file" />
<input type="hidden" class="hidden" name="field_id_31" value="" />
<input type="hidden" value="file" class="hidden" name="field_ft_31"/></li>
</ol>

<input type="submit" name="submit" value="Submit" />

</fieldset>

{/exp:weblog:entry_form}
{/exp:weblog:entries}

File uploads still work perfectly fine through the actual control panel itself, it’s just the SAEF forms that aren’t working now.

Another oddity of this is that when I submit the SAEF form, it populates the section and title information under “cpexp_weblog_titles” in my SQL database and adds the post under the edit tab in my control panel, but it doesn’t populate the datafields in the “cpexp_weblog_data” table and I can’t access the post through edit, it just tells me that section doesn’t exist.

Any help would be appreciated. I’m probably missing something really obvious, but it’s driving me up the wall now and I’m at a loss.

!!!UPDATE!!! Resolved. Apparently when I updated to 1.6.6, the encryption type file extension I was using had to be modified, I changed line 96 of Jermaine’s extension to this…

if (isset($options['hidden_fields']['weblog_id']) && $options['hidden_fields']['weblog_id']=='2')
   $options['enctype']='multi';

Per a suggestion in another thread and it fixed it, so the SAEF docytype got reset.

If anyone has problems with Solspace Gallery Extended conflicting with Mark Huot’s File Extension there is a solution (module hack by me) in this thread

Hello, I’ve been using this extension for a while now and now it seems there’s something wrong with MySQL. I carefully read the post above this one and I’m getting quite a similar error but with the following information:

MySQL ERROR:

Error Number: 1064

Description: You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'ON DUPLICATE KEY UPDATE id=values(id), `key`=values(`key`), val

Query: INSERT INTO exp_mh_file VALUES('', 1, 'allow_multiple', 'no') ON DUPLICATE KEY UPDATE id=values(id), `key`=values(`key`), value=values(value)

This happens when I try to create or edit a File Upload directory. Any ideas why this might happen?

I’ll appreciate all the help you can give. Thanks in advance!

This has been a common problem. Did you update to version 3.1.1, the latest on Mark’s site, yet?

This may have been answered before, but anyway… I CAN’T GENERATE THUMBNAILS WHEN UPLOADING IMAGES WITH ‘FILE’

I had File 3.1.1 installed on a development server running EE 1.6.3 core. Everything worked fine. Images uploaded and thumbnails were generated too, which appeared on my pages using the {file_thumb_url} tag.

Now I’ve migrated the same site to a production server, running File 3.1.1 and EE 1.6.6 (commercial). I can upload images to a designated file_upload directory fine, but the system is not generating thumbnails. I checked via FTP and the uploaded image file is in the correct place, but no generated thumbnail image

Is this a GD issue, or a File 3.1.1 issue? The new server has GD2 installed and running, and EE’s image resize setting all seem correct. Any ideas appreciated!!

Hi, I recently installed this extention, but im having problems with displaying multiple images, the field name is ‘photo’ and here is what i have

{exp:weblog:entries weblog="gallery" disable="categories|member_data|pagination|trackbacks" sort="asc" }  
{photo}
<a href="http://{photo}">"  title="{title}:"] {photo}</a>
 {/photo}
{/exp:weblog:entries}

It displays three images but they are all of the first of the three images I have uploaded

Stumpie–

Check the docs more carefully. When you are using the tags in a loop, you need to use parameters like {file_url} and {file_thumb_url} instead of just your custom field name again. More information at the bottom of this page:

http://docs.markhuot.com/ee/extensions/file

Hi guys,

I can’t get the {file_path} tag to work properly. According to the docs it is not avaible within {custom_field} - so how do I access it?

• bjorn

Use file_url.

file_url gives me the full url. I need /images/uploasd/MyImage.jpg to work with phpThumb (or Image Resize).

• bjorn

Can you hardcode the path in and use the {file_name} variable?

It’s not something I want to do, since it’s part of a generic template that should work on all EE installs.

• bjorn

How’s your php? What about modifying the extension to output it?