-
Hi,
Every time I try to setup a new coconut encode job I get a database error pop up and noting get added to the job list. I have successfully created by Digital Ocean and Coconut account and apis and completed the wizard setup successfully. I can see my video in the digial ocean space and select it to setup the new job. But every time i hit encode it fails with the database error message.
-
-
Hello Nathan,
please, try reinstalling FV Player Coconut from a fresh ZIP from https://foliovision.com/my-licenses
To do that you will have to first deactivate and delete the current FV Player Coconut 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.
Let us know, if it helped. I think there was a bug in the database table creation code.
Thanks,
Martin
Unfortunately deleting a re-installing the plugin from a new zip didn’t make a difference.
Hello Nathan,
something must be preventing the database table creation.
Please check your PHP error logs. If you are not sure about how to check the PHP error log, the server technical support should be able to give you a hand.
Or you can install this plugin which makes a list of these errors available in wp-admin: https://wordpress.org/plugins/error-log-monitor/
Then just go to wp-admin -> FV Player -> Coconut jobs again and another error should be recorded in the logs.
Thanks,
Martin
Looks like the jobs database table is missing and not getting created:
WordPress database error Table 'sls_wordpress.wp_fv_player_encoding_jobs' doesn't exist for query SELECT * FROM wp_fv_player_encoding_jobs WHERE ( status = 'completed' OR status = 'processing' OR ( status = 'error' AND date_created >= DATE_SUB( NOW(), INTERVAL 12 HOUR ) ) ) AND target NOT LIKE '%-auto-trailer' ORDER BY date_created DESC made by do_action('wp_ajax_load_coconut_jobs'), WP_Hook->do_action, WP_Hook->apply_filters, FV_Player_Coconut_Browser->load_assets, FV_Player_Coconut_Browser->get_formatted_assets_data, referer: ..../wp-admin/admin.php?page=fv_player
I also found this for the error in the table creation:
WordPress database error 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 'error varchar(1024),\n mime varchar(64),\n args TEXT,\n result TEXT,' at line 12 for query CREATE TABLE wp_fv_player_encoding_jobs (\n id bigint(20) unsigned NOT NULL AUTO_INCREMENT,\n id_video bigint(20) unsigned NOT NULL,\n job_id bigint(20) unsigned NOT NULL,\n date_created datetime NOT NULL,\n date_checked datetime NOT NULL,\n source varchar(1024) NOT NULL,\n target varchar(1024) NOT NULL,\n type varchar(64) NOT NULL,\n status varchar(64) NOT NULL,\n progress varchar(64)\n error varchar(1024),\n mime varchar(64),\n args TEXT,\n result TEXT,\n output TEXT,\n video_data TEXT,\n author bigint(20) unsigned NOT NULL default '0',\n PRIMARY KEY (id),\n KEY source (source(191)),\n KEY type (type),\n KEY status (status)\n )DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci made by do_action('fv-player_page_fv_player_coconut'), WP_Hook->do_action, WP_Hook->apply_filters, FV_Player_Coconut->tools_panel, FV_Player_Coconut->tools_panel_jobs, FV_Player_Coconut->plugin_update_database, dbDelta, referer:
I found the issue in your plugin php, the line:
error varchar(1024)
is missing a “,” at th end of the line
Hello Nathan,
thank you for sending over the fix!
I guess most MySQL servers do not mind this mistake, but in your case it did cause the issue.
Please reinstall FV Player Coconut from a fresh ZIP from https://foliovision.com/my-licenses again. Then it will work.
Thanks,
Martin
