-
When I try to set up a new coconut encode job I get a DATABASE ERROR message. I have set up Digital Ocean and Coconut and read through previous thread on this topic.
I have tried to uninstalled/delete and then reinstall a fresh zip file of coconut however this did not help.Below are the error log files generated
-
-
Dec 08, 00:56:12
WordPress database error Table 'wp721520472db_27264.wp_fv_player_encoding_jobs' doesn't exist for query SELECT * FROM wp_fv_player_encoding_jobs WHERE type = 'coconut' AND status = 'processing' made by require_once('wp-admin/admin-header.php'), do_action('admin_enqueue_scripts'), WP_Hook->do_action, WP_Hook->apply_filters, FV_Player_Video_Encoder->admin_enqueue_scripts, FV_Player_Video_Encoder->jobs_checkDec 08, 00:56:12
WordPress database error You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ')DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci' at line 24 for query CREATE TABLE wp_fv_player_encoding_jobs ( id bigint(20) unsigned NOT NULL AUTO_INCREMENT, id_video bigint(20) unsigned NOT NULL, job_id varchar(45) NOT NULL, date_created datetime NOT NULL, date_checked datetime NOT NULL, source varchar(1024) NOT NULL, target varchar(1024) NOT NULL, type varchar(64) NOT NULL, status varchar(64) NOT NULL, progress varchar(64), error varchar(1024), mime varchar(64), args TEXT, result TEXT, output TEXT, video_data TEXT, author bigint(20) unsigned NOT NULL default '0', PRIMARY KEY (id), KEY source (source(191)), KEY type (type), KEY status (status), KEY job_id (job_id(15)), )DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci made by do_action('fv-player_page_fv_player_coconut'), WP_Hook->do_action, WP_Hook->apply_filters, FV_Player_Video_Encoder->tools_panel, FV_Player_Coconut->tools_panel_jobs, FV_Player_Video_Encoder->plugin_update_database, dbDeltaHello Ryan,
thank you for posting all these details.
I prepared a fix for this for the next FV Player version. To get it right now you can reinstall FV Player from this link: https://github.com/foliovision/fv-wordpress-flowplayer/archive/master.zip
To do that you will have to first deactivate and delete the current FV Player plugin you are using. WordPress will warn you that you might loose settings and data, but it’s not the case with our plugin, no settings now videos will be lost. Or you can just replace the plugin files via FTP.
Then once you visit wp-admin -> FV Player -> Coconut Jobs the table should be properly created and you will be able to submit encoding jobs (or use drag&drop upload).
Thanks,
MartinI can confirm the fix worked. Thank you so much!
Very happy customer
