File Field MySQL Error

Hi, eoghanobrian.

We don’t provide direct support for third party addons. Moving to the Extensions forum, where the author or others can help out.

I can’t offer any direct support, but do you have php5, and the latest versions of EE, FieldFrame, and nGen file?

I can’t offer any direct support, but do you have php5, and the latest versions of EE, FieldFrame, and nGen file?

Hi Joobs, I have EE 1.6.7 latest build and nGen File Field v0.9.10, I wasn’t using the latest version of FieldFrame (v.1.2.0) up to about 5 minutes ago, when i installed v1.2.0 EE completely died on me, display_errors is on, error_reporting is set to E_ALL but I still just get a blank screen.

Things have actually got worse! :(

What about the amount of memory allocated to PHP?

What about the amount of memory allocated to PHP?

Maybe but EE has completely died after updating the FieldFrame extension so I cant really test the entry form, any ideas what would cause a blank screen after updating an extension (error_reporting set to E_ALL and display_errors set to On)

my site just died also. I also just updated Field Frame from version 1.1.2 to version 1.2.0 with nGen File Field v.0.9.8. I realized that this combination didn’t work so I downgraded Field Frame from 1.2.0 back to 1.1.2 and now all I get is this error message

MySQL ERROR: Error Number: 1054 Description: Unknown column ‘site_id’ in ‘where clause’ Query: SELECT * FROM xxx_ff_fieldtypes WHERE site_id = “1” AND enabled = “y”

(I know this forum is not supporting any 3rd parties but I thought it was funny - in a sad way - that I got the same issue)

EDIT: and this is on the latest build of EE 1.6.7 running PHP 5.2.8. now I just hope that I can salvage my database

ok. seems like I found a solution. first, I upgraded to nGen File Field v.0.9.10 once there, I still got an error… another MySQL error 1054 but this time with an “Unknown column “_upload_prefs” so on line 663 and 686 of the file ft.ngen_file_field.php (in system/extensions/fieldtypes/ngen_file_field) I took out the underscore before “_upload_prefs” (so now it reads “upload_prefs” because that underscore is automatically added as part of the db_prefix variable.

anyway. if anyone is in the same boat, they might understand the fix…

hth.

I have since installed FieldFrame v1.2.0 and nGen’s File Field successfully (as in it doesn’t crash EE anymore) however I’m still getting the MySQL error:

MySQL ERROR:

Error Number: 1054

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

Query: INSERT INTO `exp_weblog_data` (`entry_id`, `weblog_id`, `field_ft_26`, `field_id_26`, `field_id_27`, `field_ft_27`, `field_id_28`, `field_id_26_file_name`, `field_id_26_existing`, `field_ft_28`, `field_dt_28`, `site_id`) VALUES ('110', '6', 'none', 'Array', 'This is a test', 'br', '1246623323', '', 'Mario.jpg', 'none', '', '1')