Hi!

I'm pretty desperate as of now... I'm trying to implement a playlist with jplayer from view fields. But the first problem I encounter is that I actually can't modify any node that I created with the field type containing the emfield, although I'm able to create one without any apparent difficulty. But I just get an error message each time I try to modify the node. Thx in advance for your help!

Comments

plousia’s picture

plousia commented

Same here. I simply get an error message when I try to edit the node. Here's the error message in full:

PDOException: SQLSTATE[42000]: Syntax error or access violation: 1064 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 ' , , 'Array', )) LIMIT 1 OFFSET 0' at line 1: SELECT f.uri AS uri FROM {file_managed} f WHERE (f.fid IN (:db_condition_placeholder_0, :db_condition_placeholder_1, :db_condition_placeholder_2, :db_condition_placeholder_3, :db_condition_placeholder_4, :db_condition_placeholder_5, :db_condition_placeholder_6, :db_condition_placeholder_7, :db_condition_placeholder_8, :db_condition_placeholder_9, :db_condition_placeholder_10, , , , :db_condition_placeholder_14_und, )) LIMIT 1 OFFSET 0; Array ( [:db_condition_placeholder_0] => 128 [:db_condition_placeholder_1] => 1 [:db_condition_placeholder_2] => [:db_condition_placeholder_3] => 46 [:db_condition_placeholder_4] => I baked you a pie :) [:db_condition_placeholder_5] => youtube://v/98azxdfJ9Cw [:db_condition_placeholder_6] => video/youtube [:db_condition_placeholder_7] => 0 [:db_condition_placeholder_8] => 1 [:db_condition_placeholder_9] => 1333999090 [:db_condition_placeholder_10] => video [:db_condition_placeholder_14_und] => Array ( [0] => Array ( [value] => nothing ) ) ) in emfield_widget_value() (line 107 of /home/admin/domains/vimyfoundation.ca/public_html/sites/all/modules/emfield/emfield.module).

Adam S’s picture

Adam S commented

line 100 needs to be $fid = $element['#default_value']['fid']; . It's missing the ['fid'] on the end.

scalp’s picture

scalp commented

Adding that bit does allow the editing of the node, but now getting "Notice: Uninitialized string offset: 0 in emfield_widget_value() (line 100 of C:\xampp\xampp\htdocs\diversity\sites\all\modules\emfield\emfield.module)." for every emfield I have.

heretic381’s picture

heretic381 commented

Hello.

Same here:
PDOException: SQLSTATE[42000]: Syntax error or access violation: 1064 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 ')) LIMIT 1 OFFSET 0' at line 1: SELECT f.uri AS uri FROM {file_managed} f WHERE (f.fid IN (:db_condition_placeholder_0, :db_condition_placeholder_1, :db_condition_placeholder_2, :db_condition_placeholder_3, :db_condition_placeholder_4, :db_condition_placeholder_5, :db_condition_placeholder_6, :db_condition_placeholder_7, :db_condition_placeholder_8, :db_condition_placeholder_9, :db_condition_placeholder_10, )) LIMIT 1 OFFSET 0; Array ( [:db_condition_placeholder_0] => 117 [:db_condition_placeholder_1] => 1 [:db_condition_placeholder_2] => [:db_condition_placeholder_3] => 1 [:db_condition_placeholder_4] => ToJeStrah [:db_condition_placeholder_5] => youtube://v/yLcEQfxHlj8 [:db_condition_placeholder_6] => video/youtube [:db_condition_placeholder_7] => 0 [:db_condition_placeholder_8] => 1 [:db_condition_placeholder_9] => 1340220074 [:db_condition_placeholder_10] => video ) in emfield_widget_value() (line 107 of /Applications/MAMP/htdocs/tchitchak/sites/all/modules/emfield/emfield.module).

Any fix, patch???

It seems that embedded media field doesn't work well with translations???

benjaminbradley’s picture

benjaminbradley commented
Status: Active » Closed (duplicate)

There is a patch which fixes this issue over here: http://drupal.org/node/1399458
closing this bug as a duplicate