Thanks for the new dev! Anything that brings me one step closer.

When i enable to module I get this error:

user warning: Key column 'raw_image_1_file_id' doesn't exist in table query: CREATE TABLE op_videos ( video_id INT(10) UNSIGNED NOT NULL auto_increment, duration INT(10) UNSIGNED NOT NULL DEFAULT '0', secret CHAR(32) NOT NULL, source_file_id INT(10) UNSIGNED NOT NULL, flv_file_id INT(10) UNSIGNED NULL DEFAULT NULL, start_image_file_id INT(10) UNSIGNED DEFAULT NULL, third_image_file_id INT(10) UNSIGNED DEFAULT NULL, custom_image_file_id INT(10) UNSIGNED DEFAULT NULL, preview_image enum('start','third','custom') NOT NULL DEFAULT 'third', current_params_id INT(10) UNSIGNED NOT NULL DEFAULT '0', dirty_params_id INT(10) UNSIGNED NOT NULL DEFAULT '0', status ENUM('dirty','uploaded','idle') NOT NULL DEFAULT 'dirty', error ENUM('none','file not found','connection error','invalid credentials','insufficient credit','transcoding failed') NOT NULL DEFAULT 'none', upload_failed INT(10) UNSIGNED NOT NULL DEFAULT '0', uploaded INT(10) UNSIGNED NOT NULL DEFAULT '0', transcoder_version TINYINT(3) UNSIGNED NOT NULL DEFAULT '0', views INT(10) UNSIGNED NOT NULL DEFAULT '0', views_completed INT(10) UNSIGNED NOT NULL DEFAULT '0', downloads INT(10) UNSIGNED NOT NULL DEFAULT '0', PRIMARY KEY (video_id), UNIQUE KEY flv_file_id (flv_file_id), UNIQUE KEY raw_image_1_file_id (raw_image_1_file_id), UNIQUE KEY raw_image_2_file_id (raw_image_2_file_id), UNIQUE KEY splash_file_id (splash_file_id), UNIQUE KEY thumb_file_id (thumb_file_id), KEY status (status), KEY transcoder_version (transcoder_version), KEY views (views), KEY downloads (downloads), KEY error (error), KEY secret (secret), KEY views_completed (views_completed), KEY duration (duration) ) in C:\webserver\htdocs\includes\database.mysql.inc on line 172.

Using Apache on windows,
I'm wondering if it's a similar fix to this issue:

http://drupal.org/node/143881

Thanks for any help!

Comments

jbrown’s picture

jbrown commented
Status: Active » Fixed

cheers!

Now fixed.

TK1’s picture

TK1 commented

Have you updated it?
Any chance you can paste the install code?

I know day after release must be a busy one!

jbrown’s picture

jbrown commented

the dev tar.gz gets rebuilt every 12 hours, so it will be there by now. You can use CVS if you need more up 2 date.

Its not a release as yet - please debug!

TK1’s picture

TK1 commented

Works really well! Thanks very much.

robloach’s picture

robloach
he/him
commented
Status: Fixed » Needs review 
			db_query("
					CREATE TABLE op_video_image_cache (
						video_id INT(10) UNSIGNED NOT NULL,
						image ENUM('start','third','custom') collate utf8_bin NOT NULL,
						width SMALLINT(5) UNSIGNED NOT NULL,
						height SMALLINT(5) UNSIGNED NOT NULL,
						file_id INT(10) UNSIGNED NOT NULL,
						PRIMARY KEY (video_id, image, width, height)
					)
			");

Doesn't use the table prefix, you need to use {}....

			db_query("
					CREATE TABLE {op_video_image_cache} (
						video_id INT(10) UNSIGNED NOT NULL,
						image ENUM('start','third','custom') collate utf8_bin NOT NULL,
						width SMALLINT(5) UNSIGNED NOT NULL,
						height SMALLINT(5) UNSIGNED NOT NULL,
						file_id INT(10) UNSIGNED NOT NULL,
						PRIMARY KEY (video_id, image, width, height)
					)
			");
jbrown’s picture

jbrown commented
Status: Needs review » Fixed
Anonymous’s picture

(not verified) commented
Status: Fixed » Closed (fixed)

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