hi,
i have no trouble using the module but when I try to use the views components or blocks i get the following error:
user warning: 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 'DISTINCT(node.nid), node.title AS node_title, node_kaltura.kaltura_thumbna' at line 1 query: SELECT COUNT(*) FROM (SELECT DISTINCT(node.nid) AS DISTINCT(node.nid), node.title AS node_title, node_kaltura.kaltura_thumbnail_url AS node_kaltura_kaltura_thumbnail_url, node_kaltura.kaltura_entryId AS node_kaltura_kaltura_entryId FROM node node INNER JOIN users users ON node.uid = users.uid LEFT JOIN node_kaltura node_kaltura ON node.nid = node_kaltura.nid WHERE (users.uid = 1) AND (node_kaltura.kaltura_media_type in ('1')) AND (node_kaltura.kaltura_video_comment in ('0')) ) count_alias in /home/******/public_html/******/sites/all/modules/views/includes/view.inc on line 697.
user warning: 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 'DISTINCT(node.nid), node.title AS node_title, node_kaltura.kaltura_thumbna' at line 1 query: SELECT DISTINCT(node.nid) AS DISTINCT(node.nid), node.title AS node_title, node_kaltura.kaltura_thumbnail_url AS node_kaltura_kaltura_thumbnail_url, node_kaltura.kaltura_entryId AS node_kaltura_kaltura_entryId FROM node node INNER JOIN users users ON node.uid = users.uid LEFT JOIN node_kaltura node_kaltura ON node.nid = node_kaltura.nid WHERE (users.uid = 1) AND (node_kaltura.kaltura_media_type in ('1')) AND (node_kaltura.kaltura_video_comment in ('0')) LIMIT 0, 10 in /home/******/public_html/*********/sites/all/modules/views/includes/view.inc on line 723.
thanks in advance
Comments
Comment #1
marcingy commentedSee http://drupal.org/node/284392 it is a problem with core rather than this module and specifically affect views that use the distinct clause.
Comment #2
Zohar.Babin commentedAs marcingy said, it seems to be a problem in the core.
I can just say that I'm using the module with Drupal 6.6 and I did not see any DISTINCT errors in the queries built by the Kaltura module.
Comment #3
quioxte commentedthe views work fine if you set the Distinct variable to "off" on the views page. Might be a problem only if you upload the same image or video multiple times. I can live with this.
The patches worked but then affected other modules
Comment #4
xurizaemon