Forum Replies Created
-
-
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.
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
