I'm testing embedded media field with vimeo videos, but while it links and plays fine, it throws this error when you try to re-edit the content:

PDOException: SQLSTATE[HY000]: General error: 1 near ")": syntax error: 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] => 6 [:db_condition_placeholder_1] => 1 [:db_condition_placeholder_2] => [:db_condition_placeholder_3] => 1 [:db_condition_placeholder_4] => Rock It For Me - Clip [:db_condition_placeholder_5] => vimeo://v/50917257 [:db_condition_placeholder_6] => video/vimeo [:db_condition_placeholder_7] => 0 [:db_condition_placeholder_8] => 1 [:db_condition_placeholder_9] => 1349776042 [:db_condition_placeholder_10] => video ) in emfield_widget_value() (line 107 of /Users/user1/Documents/WEBSITES/Localhost/grid_theme/sites/all/modules/emfield/emfield.module).

Notes:

Disabling the Embedded Media Field module makes the content editable again (A useful workaround).

My site is set up under a localhost, using a SQLite db. (Guessing this is probably the cause)

Comments

REo’s picture

REo CreditAttribution: REo commented

Same error here with a youtube video. I'm using Mysql as database.

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] => 1 [:db_condition_placeholder_1] => 1 [:db_condition_placeholder_2] => [:db_condition_placeholder_3] => 1 [:db_condition_placeholder_4] => Ballarò - MAURIZIO CROZZA del 09/10/12 Monti: "l'Italia sta dando il meglio di sé". In tasse! [:db_condition_placeholder_5] => youtube://v/UlmSVTIfiz4 [:db_condition_placeholder_6] => video/youtube [:db_condition_placeholder_7] => 0 [:db_condition_placeholder_8] => 1 [:db_condition_placeholder_9] => 1350292276 [:db_condition_placeholder_10] => video ) in emfield_widget_value() (line 107 of /home/myuser/Sites/og1/sites/all/modules/emfield/emfield.module).

martichka5’s picture

martichka5 CreditAttribution: martichka5 commented

I have exactly the same error using YouTube link. I use the dev version of the module.

martichka5’s picture

martichka5 CreditAttribution: martichka5 commented

I found solution for me. I changed line 101 in the emfield.module file
from $fid = $element['#default_value']; (old)
to $fid = $element['#default_value']['fid']. (new)

Before the change the value of the $fid variable was not the fid of the file but an array. So the query get array instead of fid value.
After the change i have no problem with viewing or editing the page.

REo’s picture

REo CreditAttribution: REo commented

#3 works for me. Using 7.x-1.0-alpha1.

jordan8037310’s picture

jordan8037310 CreditAttribution: jordan8037310 commented

#3 worked for me as well. Using 7.x-1.0-alpha1 as well.

Cheers