PGSQL Syntax Errors [#539994]

I'm running Drupal6 on apache and pgsql. Installed Kaltura module and uploaded a video. Kaltura's posts don't show up anywhere. When I navigate (or get redirected) to http://example.com/kaltura/entries, the following errors render the site useless:

    * warning: pg_query() [function.pg-query]: Query failed: ERROR: syntax error at or near "c" LINE 1: SELECT COUNT(node.nid) c FROM node node LEFT JOIN node_kaltu... ^ in /data/srv/http/example.com/includes/database.pgsql.inc on line 139.
    * user warning: query: SELECT COUNT(node.nid) c FROM node node LEFT JOIN node_kaltura knode on node.nid = knode.nid WHERE type like 'kaltura%' AND status > 0 in /data/srv/http/example.com/modules/kaltura/kaltura.module on line 306.
    * warning: pg_query() [function.pg-query]: Query failed: ERROR: LIMIT #,# syntax is not supported HINT: Use separate LIMIT and OFFSET clauses. in /data/srv/http/example.com/includes/database.pgsql.inc on line 139.
    * user warning: 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 WHERE (type = 'kaltura_entry' OR type = 'kaltura_mix') AND status > 0 ORDER BY nid DESC LIMIT 0, 20 in /data/srv/http/example.com/modules/kaltura/kaltura.module on line 317.

Comments

Comment #1

aadityabhatia commented 4 August 2009 at 18:55

Here are more errors that I got when I tried to upload a GIF image. Not sure if GIF is supported, but In any case the desirable behavior is to display a concise (success | error) message.

warning: pg_query() [function.pg-query]: Query failed: ERROR: syntax error at or near "c" LINE 1: SELECT COUNT(notification_id) c FROM kaltura_notifications W... ^ in /data/srv/http/example.com/includes/database.pgsql.inc on line 139.

user warning: query: SELECT COUNT(notification_id) c FROM kaltura_notifications WHERE notification_id = 1171531 in /data/srv/http/example.com/modules/kaltura/includes/kaltura.notification.inc on line 67.

warning: pg_query() [function.pg-query]: Query failed: ERROR: value too long for type character varying(16) in /data/srv/http/example.com/includes/database.pgsql.inc on line 139.

user warning: query: INSERT INTO watchdog (uid, type, message, variables, severity, link, location, referer, hostname, timestamp) VALUES (3, 'kaltura notification handler', 'Array ( [name] => pff_flower.gif [sig] => 9ad63e92ce5ce94263397ee2817a8d7b [puser_id] => 3 [width] => 500 [data_url] => http://cdn.kaltura.com/p/35025/sp/3502500/flvclipper/entry_id/s3fvmaxwew/version/100000 [length_in_msecs] => 0 [entry_id] => s3fvmaxwew [search_text] => pff flower gif pftf [download_size] => 31691 [download_url] => http://cdn.kaltura.com/p/35025/sp/3502500/raw/entry_id/s3fvmaxwew/version/100000 [media_type] => 2 [notification_type] => entry_add [permissions] => 1 [roughcut_id] => fo34vpqozs [thumbnail_url] => http://cdn.kaltura.com/p/35025/sp/3502500/thumbnail/entry_id/s3fvmaxwew/version/100000 [kshow_id] => 8s02c8qu88 [partner_data] => user_id@3 [media_date] => [tags] => #pftf [group_id] => [signed_fields] => notification_id,notification_type,puser_id,partner_id,entry_id,name,tags,search_text,media_type,length_in_msecs,permissions,thumbnail_url,kshow_id,roughcut_id,group_id,partner_data,status,width,height,data_url,download_url,download_size,media_date,signed_fields, [notification_id] => 1171531 [status] => 2 [height] => 500 ) ', 'a:0:{}', 5, '', 'http://example.com/?q=kaltura/notification_handler', 'http://www.kaltura.com/[[IMPORT]]/cdn.kaltura.com/p/0/sp/0/flash/kcw/v1.5.4/ContributionWizard.swf', '76.202.194.148', 1249396084) in /data/srv/http/example.com/modules/dblog/dblog.module on line 144.

warning: pg_query() [function.pg-query]: Query failed: ERROR: invalid input syntax for type timestamp: "" in /data/srv/http/example.com/includes/database.pgsql.inc on line 139.

user warning: query: INSERT INTO node_kaltura (vid, nid, kaltura_entryId, kaltura_tags, kaltura_admin_tags, kstatus, kaltura_media_type, kaltura_duration, kaltura_thumbnail_url, kaltura_partner_data, kaltura_source, kaltura_source_id, kaltura_source_link, kaltura_width, kaltura_height, kaltura_download_url, kaltura_media_date, kaltura_views, kaltura_plays, kaltura_votes, kaltura_rank, kaltura_total_rank, kaltura_entry_data, kaltura_video_comment) VALUES (7, 7, 's3fvmaxwew', '#pftf', '', 2, 2, 0, 'http://cdn.kaltura.com/p/35025/sp/3502500/thumbnail/entry_id/s3fvmaxwew/version/100000', 'user_id@3', 0, 0, '', 500, 500, 'http://cdn.kaltura.com/p/35025/sp/3502500/raw/entry_id/s3fvmaxwew/version/100000', '', 0, 0, 0, 0, 0, 'a:1:{i:0;a:24:{s:4:"name";s:14:"pff_flower.gif";s:3:"sig";s:32:"9ad63e92ce5ce94263397ee2817a8d7b";s:8:"puser_id";s:1:"3";s:5:"width";s:3:"500";s:8:"data_url";s:87:"http://cdn.kaltura.com/p/35025/sp/3502500/flvclipper/entry_id/s3fvmaxwew/version/100000";s:15:"length_in_msecs";s:1:"0";s:8:"entry_id";s:10:"s3fvmaxwew";s:11:"search_text";s:19:"pff flower gif pftf";s:13:"download_size";s:5:"31691";s:12:"download_url";s:80:"http://cdn.kaltura.com/p/35025/sp/3502500/raw/entry_id/s3fvmaxwew/version/100000";s:10:"media_type";s:1:"2";s:17:"notification_type";s:9:"entry_add";s:11:"permissions";s:1:"1";s:11:"roughcut_id";s:10:"fo34vpqozs";s:13:"thumbnail_url";s:86:"http://cdn.kaltura.com/p/35025/sp/3502500/thumbnail/entry_id/s3fvmaxwew/version/100000";s:8:"kshow_id";s:10:"8s02c8qu88";s:12:"partner_data";s:9:"user_id@3";s:10:"media_date";s:0:"";s:4:"tags";s:5:"#pftf";s:8:"group_id";s:0:"";s:13:"signed_fields";s:262:"notification_id,notification_type,puser_id,partner_id,entry_id,name,tags,search_text,media_type,length_in_msecs,permissions,thumbnail_url,kshow_id,roughcut_id,group_id,partner_data,status,width,height,data_url,download_url,download_size,media_date,signed_fields,";s:15:"notification_id";s:7:"1171531";s:6:"status";s:1:"2";s:6:"height";s:3:"500";}}', 0) in /data/srv/http/example.com/modules/kaltura/plugins/node_kaltura_entry/node_kaltura_entry.module on line 453.

warning: pg_query() [function.pg-query]: Query failed: ERROR: syntax error at or near "c" LINE 1: SELECT COUNT(node.nid) c FROM node node LEFT JOIN node_kaltu... ^ in /data/srv/http/example.com/includes/database.pgsql.inc on line 139.

user warning: ERROR: value too long for type character varying(128) query: SELECT COUNT(node.nid) c FROM node node LEFT JOIN node_kaltura knode on node.nid = knode.nid WHERE type like 'kaltura%' AND status > 0 in /data/srv/http/example.com/modules/kaltura/kaltura.module on line 306.

warning: pg_query() [function.pg-query]: Query failed: ERROR: LIMIT #,# syntax is not supported HINT: Use separate LIMIT and OFFSET clauses. in /data/srv/http/example.com/includes/database.pgsql.inc on line 139.

user warning: ERROR: value too long for type character varying(128) 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 WHERE (type = 'kaltura_entry' OR type = 'kaltura_mix') AND status > 0 ORDER BY nid DESC LIMIT 0, 20 in /data/srv/http/example.com/modules/kaltura/kaltura.module on line 317.