Error in query while using with modr8 module

Project:Video & Media Module for Drupal
Component:Code
Category:bug report
Priority:critical
Assigned:Unassigned
Status:closed
Total votes:0
Description

In /var/www/modules/kaltura/kaltura.module on line 306 the is a bug in the query -
$get_all = 'SELECT node.nid,node.title,node.type,knode.kaltura_entryId,knode.kaltura_thumbnail_url FROM {node} node '.'LEFT JOIN {node_kaltura} knode on node.nid = knode.nid WHERE (type = \'kaltura_entry\' OR type = \'kaltura_mix\') '. $filter_media .' AND status > 0 ORDER BY nid DESC LIMIT '. $start .', 20';
should be
$get_all = 'SELECT node.nid,node.title,node.type,knode.kaltura_entryId,knode.kaltura_thumbnail_url FROM {node} node '.'LEFT JOIN {node_kaltura} knode on node.nid = knode.nid WHERE (node.type = \'kaltura_entry\' OR node.type = \'kaltura_mix\') '. $filter_media .' AND status > 0 ORDER BY nid DESC LIMIT '. $start .', 20';

Comments

#1

Status:patch (ready to be committed)» fixed

Fixed in Drupal contrib Kaltura module 6.x-1.5

--
www.giantrobot.co.nzhttp://twitter.com/grobot

#2

Status:fixed» closed

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