I installed the Kaltura module and setup an account. I tried creating a new video node and the upload process went fine. However once the upload is finished I'm redirected to the Kaltura Content page and I receive two errors and no video shows up.

user warning: Table 'drupal.node_kaltura' doesn't exist 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 C:\projects\siteproject\www\httpd\html\sitename\info\sites\sitename.com\modules\kaltura\kaltura.module on line 306.

user warning: Table 'drupal.node_kaltura' doesn't exist 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 C:\siteproject\www\httpd\html\sitename\info\sites\sitename.com\modules\kaltura\kaltura.module on line 317.

Comments

Zohar.Babin’s picture

Zohar.Babin commented

the module's tables were not created during the installation process.
what drupal core version are you using ?

For now I'd suggest you try removing the module and re-install it.
If you can reproduce this issue without any complications it might have something to do with the drupal core.

logicalpat’s picture

logicalpat commented

Thank you for the response. I tried removing the module and re-installing it however upon trying to re-enable the main "Kaltura" module I received these two errors from Drupal:

user warning: BLOB/TEXT column 'kaltura_tags' can't have a default value query: CREATE TABLE node_kaltura ( `vid` SMALLINT unsigned NOT NULL DEFAULT 0, `nid` SMALLINT unsigned NOT NULL, `kaltura_entryId` VARCHAR(10) NOT NULL DEFAULT '', `kaltura_tags` TEXT DEFAULT '', `kaltura_admin_tags` TEXT DEFAULT '', `kstatus` SMALLINT NOT NULL DEFAULT 0, `kaltura_media_type` SMALLINT DEFAULT NULL, `kaltura_duration` INT DEFAULT NULL, `kaltura_thumbnail_url` VARCHAR(255) DEFAULT NULL, `kaltura_partner_data` VARCHAR(4096) DEFAULT NULL, `kaltura_source` SMALLINT DEFAULT NULL, `kaltura_source_id` INT DEFAULT 0, `kaltura_source_link` VARCHAR(1024) DEFAULT NULL, `kaltura_width` INT DEFAULT 0, `kaltura_height` INT DEFAULT 0, `kaltura_download_url` VARCHAR(1024) DEFAULT NULL, `kaltura_media_date` DATETIME DEFAULT NULL, `kaltura_views` INT DEFAULT 0, `kaltura_plays` INT DEFAULT 0, `kaltura_votes` INT DEFAULT 0, `kaltura_rank` INT DEFAULT 0, `kaltura_total_rank` INT DEFAULT 0, `kaltura_entry_data` TEXT DEFAULT NULL, `kaltura_video_comment` INT DEFAULT 0, PRIMARY KEY (vid) ) /*!40100 DEFAULT CHARACTER SET UTF8 */ in C:\projects\siteproject\www\httpd\html\sitename\info\includes\database.inc on line 515.

user warning: BLOB/TEXT column 'data' can't have a default value query: CREATE TABLE kaltura_notifications ( `notification_id` INT unsigned NOT NULL, `data` TEXT DEFAULT '', `received_at` DATETIME DEFAULT NULL, PRIMARY KEY (notification_id) ) /*!40100 DEFAULT CHARACTER SET UTF8 */ in C:\projects\siteproject\www\httpd\html\sitename\info\includes\database.inc on line 515.

I'm using the latest version of the Kaltura module and Drupal 6.11.

Zohar.Babin’s picture

Zohar.Babin commented

is your mysql configured to strict mode by a chance ?

logicalpat’s picture

logicalpat commented

Yes, it is configured to use strict mode. Is the Kaltura module not compatible with strict mode?

logicalpat’s picture

logicalpat commented

I changed my MySQL database to not use strict mode and now content will show up when I upload it. Why doesn't the Kaltura module work with MySQL strict mode? Every other Drupal module I have used has had no problem with it.

Zohar.Babin’s picture

Zohar.Babin commented

Hi logicalpat,
we can call it a bug.

It will be fixed in the next release which is due to end of june.

Sorry for the inconvenience.

Gonen

oferc’s picture

oferc commented
Status: Active » Fixed

We have released a new version of the Drupal module that works with Kaltura’s new platform version - Andromeda.

The new module should solve the issue discussed here, and it also includes great new and exciting features at
http://www.kaltura.org/features-coming-next-version

The new version is now available for download at http://drupal.org/project/kaltura#downloads.

If you wish to upgrade an existing account and migrate your content, you can learn more in our forums , or contact us for assistance at http://corp.kaltura.com/about/contact

Status: Fixed » Closed (fixed)

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