So found the nGen file field and love it but when I use FF matrix I run into problems. I can use the EE file upload fine. I can use nGen fine in its own field. When I use nGen file field with FF matrix I get this SQL error when I try to publish or edit an entry.
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 '' at line 1
Query: SELECT * FROM exp_upload_prefs WHERE id =
I notice I do not get an option to choose the “file upload location” when I use FF matrix. Thanks for any help Mike
update:
With a little MYSQL hacking from this article fixed my problem, just had to go back and re do the nGen fields.
http://ellislab.com/forums/viewthread/132347/
Thanks StudioKong
Has anyone been able to use nGen File Field with NSM Publish Plus? I have been using nGen to great effect for a few months now and it works great. I asked Leevi for help with this but he said “Third party plugins must support quicksave and preview functionality to be fully compatible with NSM Publish Plus.”
I’ll second this question. I’ve really been wanting to implement Publish Plus, but I need File Field to work as well.
It’s very simple if you’re using it with FF Matrix you just use it within the quotes of your ngen FF field and not the quotes of the FF Matrix fields pairs.Does anyone know how to use the show=”filename” parameter with File Field? I’m completely stumped. Thanks!Seconded.In the above code the matrix field is application_images and the ngen FF field is image. I hope this helped you{application_images} {image show="filename"} {/application_images}
Perfect! Thanks.
Feeling kinda dumb now.
Ran into a new bug that seems to have popped up after installing MSM and creating a new site:Notice: getimagesize() [function.getimagesize]: Read error! in /system/extensions/fieldtypes/ngen_file_field/ft.ngen_file_field.php on line 10
I’ve just experienced this on a site that was working previously.
Files are still uploading but the error is bugging me.
Did you get a fix?
I don’t use MSM but ran into this as well. Just posted a fix in this thread.
In our case it was due to file upload errors storing nothing in the field - even though the file gets uploaded. Field frame wouldn’t show the blank FF field and it doesn’t cause any display errors - easy to miss. The fix mentioned above will also prevent the error in case of super tiny files (blank.txt for instance).
Maybe a bug fix to be added to ngGen FF for FF? Not sure, it might hide other problems so maybe not (upload errors).
I don’t use MSM but ran into this as well. Just posted a fix in this thread. In our case it was due to file upload errors storing nothing in the field - even though the file gets uploaded. Field frame wouldn’t show the blank FF field and it doesn’t cause any display errors - easy to miss. The fix mentioned above will also prevent the error in case of super tiny files (blank.txt for instance). Maybe a bug fix to be added to ngGen FF for FF? Not sure, it might hide other problems so maybe not (upload errors).
was that in response to me?
I forgot to mention I don’t use MSM either.
Thanks for this awesome extension! However I ran into problems on a site that features several very large video files (up to 800 mb). When trying to add or edit an entry the page was loading forever. I figured it had something to do with the size of the files since the issue only came up in one weblog. The problem is the method which checks if a file is an image or not. To do so it runs exif_imagetype() on a file which doesn’t play nice with very large (video) files. The server was completely overstrained. I added a simple file extension check to ensure that exif_imagetype() will only be executed on files which seem to be image files which solved the issue.You may want to include this in the next version of the fieldtype. Keep up the great work! 😊// // Checks if a file is an image // function _is_image($file) { $is_image = false; $file = trim($file); // Check for extension first to avoid running exif_imagetype() // on (possibly large) non-image files. if(preg_match('/^.+\.(gif|jpg|jpeg|png|bmp)$/i', $file) === 1) { switch( exif_imagetype($file) ) { case IMAGETYPE_GIF: case IMAGETYPE_BMP: case IMAGETYPE_JPEG: case IMAGETYPE_PNG: $is_image = true; break; } } return $is_image; } //
I’m thinking that this may indeed be my issue now because this only happens in my audio weblog (it’s getting big with lots of files around 20Mb each).
In what file would I place this code and where within the file?
It’s a pain because it’s not something you can really test against without your site being in a live environment with all these files.
Thanks, Steven
OK - I found that the code I quoted above is actually already in place on ft.ngen_file_field.php on line 789.
So I’m still getting:
Notice: getimagesize() [function.getimagesize]: Read error! in /home/greenvie/public_html/system/extensions/fieldtypes/ngen_file_field/ft.ngen_file_field.php on line 10
Notice: getimagesize() [function.getimagesize]: Read error! in /home/greenvie/public_html/system/extensions/fieldtypes/ngen_file_field/ft.ngen_file_field.php on line 10
Notice: getimagesize() [function.getimagesize]: Read error! in /home/greenvie/public_html/system/extensions/fieldtypes/ngen_file_field/ft.ngen_file_field.php on line 10
Notice: getimagesize() [function.getimagesize]: Read error! in /home/greenvie/public_html/system/extensions/fieldtypes/ngen_file_field/ft.ngen_file_field.php on line 10
I should also point out that after checking with my host, I don’t have Exif bundled with this PHP installation and host is currently looking at it for next Apache upgrade (not imminent).
nGen File Field and FieldFrame MYSQL Error Number: 1064 IE problem?
Was about to post this, then I was unable to log in to my Control panel in IE for some reason, comes and goes. So I logged in using Firefox, I was able to add FF Matrix with nGen and pick the upload directory. Was able to publish and add rows. All Worked!
Went back into IE and could not pick download location again and unable to add rows in the edit/ publish pages.
So I will still list my errors and info in case it helps others.
So after I fixed my first install of nGen and FieldFrame with this article. I now have the same problem on my 2nd install but unable to fix this time.
http://ellislab.com/forums/viewthread/132347/
Ngen by its self works, and upload directory works.
FF Matrix will not give me an option on the publish page for additional rows.
FF Matrix will not allow me to re-arrange the fields while modifying field. I do not get the option to move columns around.
When I try to make a FF Matrix with an nGen field I do not get the option to choose download location, then when I go to edit or publish an entry I get.
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 '' at line 1
Query: SELECT * FROM exp_upload_prefs WHERE id =
Only when I have an nGen and FF Matrix together do I get these above errors.
Verified I have the latest and re-uploaded all ext. of nGen, jQuery, and FieldFrame, and EE.
Thanks
Mike
** Fixed if I use Firefox and not IE for control panel access. I have vista ultimate, IE 8.0.6001.18828, and now use Firefox 3.0.15
I’ve been working to get my first ngen SAEF working. So far things are going ok, but I noticed in the generated output code of the form that the style sheet and javascript code for ngen is embedded below the close of the form tag.
Having the css link code inside the body causes the page to not validate (not w3c compliant). I think the link for all stylesheet code should be in the header of the html page.
Has anyone else noticed this? I think the ngen script should put the script and style files in the header not in the body.
Maybe I don’t have something setup correctly. Can someone confirm if they are getting these files inside the body on their SAEFs that use ngen?
<link rel="stylesheet" type="text/css" href="http://mydomain.com/system/extensions/fieldtypes/ngen_file_field/styles/ngen_file_field.css" charset="utf-8" />
[script]FT_URL = "http://mydomain.com/system/extensions/fieldtypes/";[/script]
...
</form>
I’m having a problem with nGen File Field and FF Matrix running together. It’s giving me MySQL 2013 errors. Details can be found here: http://getsatisfaction.com/brandonkelly/topics/fieldframe_causing_mysql_2013_errors_site_severly_crippled
Any suggestions for what might be causing this? Is there possibly somekind conflict between the fieldtypes or some other reason why the problem only occurs when both are enabled?
*** edit *** I’ve branched my question off into it’s own thread: http://ellislab.com/forums/viewthread/137648/
Packet Tide owns and develops ExpressionEngine. © Packet Tide, All Rights Reserved.