-
Strangely enough this morning I updated the FV Player for a site we’re managing and their shortcode editor no longer works. Any insight into what might be going wrong.
The shortcode that gets dumped out is:
[fv_player id=”-1″]
No matter what link we put in from the S3 bucket.
Cheers
-
-
Hello Barney,
it’s the new database driven storage of FV Players: https://foliovision.com/2018/11/video-database
If you experience such error, please provide output of Settings -> FV Player -> Tools -> System Info and also the PHP error logs which appear when you hit the button to save the player instance in editor.
Thanks,
Martin
HI Martin,
Interestingly the PHP error is:
WordPress database error Row size too large. The maximum row size for the used table type, not counting BLOBs, is 65535. This includes storage overhead, check the manual. You have to change some columns to TEXT or BLOBs for query
CREATE TABLE wp_fv_player_players (
id bigint(20) unsigned NOT NULL auto_increment,
player_name varchar(255) NOT NULL,
player_slug varchar(255) NOT NULL,
videos varchar(65535) NOT NULL,
ab varchar(3) NOT NULL,
ad text NOT NULL,
ad_height varchar(7) NOT NULL,
ad_width varchar(7) NOT NULL,
ad_skip varchar(7) NOT NULL,
align varchar(7) NOT NULL,
author bigint(20) unsigned NOT NULL default ‘0’,
autoplay varchar(7) NOT NULL,
controlbar varchar(7) NOT NULL,
copy_text varchar(120) NOT NULL,
changed_by bigint(20) unsigned NOT NULL default ‘0’,
date_created datetime NOT NULL default ‘0000-00-00 00:00:00’,
date_modified datetime NOT NULL default ‘0000-00-00 00:00:00’,
embed varchar(12) NOT NULL,
end_actions varchar(10) NOT NULL,
end_action_value varchar(255) NOT NULL,
height varchar(7) NOT NULL,
hflip varchar(7) NOT NULL,
lightbox varchar(7) NOT NULL,
lightbox_caption varchar(120) NOT NULL,
lightbox_height varchar(7) NOT NULL,
lightbox_width varchar(7) NOT NULL,
playlist varchar(10) NOT NULL,
playlist_advance varchar(7) NOT NULL,
qsel varchar(25) NOT NULL,
share varchar(7) NOT NULL,
share_title varchar(120) NOT NULL,
share_url varchar(255) NOT NULL,
speed varchar(255) NOT NULL,
sticky varchar(7) NOT NULL,
video_ads varchar(10) NOT NULL,
video_ads_post varchar(10) NOT NULL,
width varchar(7) NOT NULL,
PRIMARY KEY (id)
) made by do_action(‘wp_ajax_fv_player_db_save’), WP_Hook->do_action, WP_Hook->apply_filters, FV_Player_Db->db_store_player_data, FV_Player_Db_Player->__construct, FV_Player_Db_Player->initDB, dbDelta
[04-Dec-2018 18:23:54 UTC] WordPress database error Table ‘theredme_live.wp_fv_player_players’ doesn’t exist for query INSERT INTO wp_fv_player_players SET author = 63,changed_by = 63,date_created = ‘2018-12-04 18:23:54’,date_modified = ‘2018-12-04 18:23:54′,ab = ”,ad = ”,ad_height = ”,ad_width = ”,ad_skip = ”,align = ”,autoplay = ”,controlbar = ”,copy_text = ”,embed = ”,end_actions = ”,end_action_value = ”,height = ”,hflip = ”,lightbox = ”,lightbox_caption = ”,lightbox_height = ”,lightbox_width = ”,player_name = ”,player_slug = ”,playlist = ”,playlist_advance = ”,qsel = ”,share = ”,share_title = ”,share_url = ”,speed = ”,sticky = ”,video_ads = ”,video_ads_post = ”,width = ”,videos = ’20’ made by do_action(‘wp_ajax_fv_player_db_save’), WP_Hook->do_action, WP_Hook->apply_filters, FV_Player_Db->db_store_player_data, FV_Player_Db_Player->save
I’ve fixed the issue – I copied the MySQL and created the table manually but I changed the videos varchar(65535) NOT NULL, to videos text NOT NULL.
Think the WordPress limit was having a fit at the idea of a 65536 VARCHAR field when really a TEXT would do.
Cheers for the insight – didn’t get round to checking the wp-admin error-log.
Hello Barney,
thank you for the follow up. You fix seems to be correct, we will use that for the next version of the plugin.
Thanks,
Martin
