Forum Replies Created
Viewing 4 replies - 1 through 4 (of 4 total)
-
-
I found the issue in your plugin php, the line:
error varchar(1024)
is missing a “,” at th end of the line
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: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_playerUnfortunately deleting a re-installing the plugin from a new zip didn’t make a difference.
Viewing 4 replies - 1 through 4 (of 4 total)
