Copyright © 2012 Kaltura Inc.
All Rights Reserved. Designated trademarks and brands are the property of their respective owners.
Use of this web site constitutes acceptance of the Terms of Use and Privacy Policy.
EduVideo.org
Kaltura Drupal Plugin Conflicting with Modr8 Drupal Module
Tue, 12/15/2009 - 19:01
When the Modr8 plugin is enabled and you you attempt to view all Kaltura content, I get the below error...
http:// 0 ) in /var/www/modules/kaltura/kaltura.module on line 306.
user warning: Column 'type' in where clause is ambiguous query: 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 LEFT JOIN node n ON node.nid = n.nid WHERE ((n.moderate != 1 OR n.uid = 6)) AND ( (type = 'kaltura_entry' OR type = 'kaltura_mix') AND status > 0 )ORDER BY nid DESC LIMIT 0, 20 in /var/www/modules/kaltura/kaltura.module on line 317.
===cut===
Has anyone else seen this?
If I disable Modr8, there is no issue.
John P.
Hi, thanks for reporting. I opened a bug report on this.
In /var/www/modules/kaltura/kaltura.module on line 306 there 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';