nGen File Field for FieldFrame Error Number: 1064
Development and Programming
Just installed FieldFrame and have recieved the following error. I have read through the posts and am not sure what the actual fix for this err is. I am not a programmer and any assistance would be appreciated.
Thanks 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 just got the same error message. This happened after I updated the Field Instructions in a custom field that uses an FF Matrix field type. The Cell Type is a nGen file field. I did not change anything in the Matrix Configuration.
I was able to track down the problem by comparing the ff_settings value in the exp_weblog_fields table with the value it had on my test-server: the values did not match.
The wrong value on the live server: a🔢{s:8:"max_rows";s👎"";s:4:"cols";a💯{i:1;a:3:{s:4:"name";s:10:"case_image";s:5:"label";s:5:"Image";s:4:"type";s:15:"ngen_file_field";}}}
The correct value on the test-server: a🔢{s:8:"max_rows";s👎"";s:4:"cols";a💯{i:1;a:4:{s:4:"name";s:10:"case_image";s:5:"label";s:5:"Image";s:4:"type";s:15:"ngen_file_field";s:8:"settings";a💯{s:7:"options";s💯"2";}}}}
Replacing the value on the live server by the one of the test server resolved the problem. But of course, I would like to know what caused this. A bit scary that updating the Field Instructions can have this impact. Any idea what is going wrong?
this fixed my problem also,
thanks StudioKong