Line 316 of includes/ooyala.import.inc for both -1.x and -2.x branches should read:

$sql = 'SELECT nid, '.$field_name.' FROM {'.$table.'} WHERE '.$field_name.' IN ('.$placeholders.')';

or similar. The curly braces were getting interpreted when formerly inside double quotes as an alternate specification of the variable. So as long as you had no database table prefix, passing the table name without curly braces to db_query() worked. But if you do have a database table prefix, the query fails because the table is not wrapped in curly braces and therefore does not get altered by db_prefix_tables().

CommentFileSizeAuthor
#1 ooyala_import_db_prefix-1744316.patch544 bytesquicksketch

Comments

quicksketch’s picture

Status: Active » Fixed
StatusFileSize
new544 bytes

Thanks good suggestion. Fixed with this patch. Committed to both Drupal 6 branches.

Status: Fixed » Closed (fixed)

Automatically closed -- issue fixed for 2 weeks with no activity.