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

marcingy’s picture

See http://drupal.org/node/284392 it is a problem with core rather than this module and specifically affect views that use the distinct clause.

Zohar.Babin’s picture

Status: Active » Closed (won't fix)

As 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.

quioxte’s picture

the 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

xurizaemon’s picture

Category: bug » support
Status: Closed (won't fix) » Fixed

Status: Fixed » Closed (fixed)

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