Title: mdoolittle's Replies | WordPress.org --- # mdoolittle [ ](https://wordpress.org/support/users/mdoolittle/) * [Profile](https://wordpress.org/support/users/mdoolittle/) * [Topics Started](https://wordpress.org/support/users/mdoolittle/topics/) * [Replies Created](https://wordpress.org/support/users/mdoolittle/replies/) * [Reviews Written](https://wordpress.org/support/users/mdoolittle/reviews/) * [Topics Replied To](https://wordpress.org/support/users/mdoolittle/replied-to/) * [Engagements](https://wordpress.org/support/users/mdoolittle/engagements/) * [Favorites](https://wordpress.org/support/users/mdoolittle/favorites/) Search replies: ## Forum Replies Created Viewing 2 replies - 1 through 2 (of 2 total) * Forum: [Plugins](https://wordpress.org/support/forum/plugins-and-hacks/) In reply to: [[EmbedPress – PDF Embedder, 3D PDF FlipBook, Google Reviews, YouTube Videos, Upload & Embed PDF documents] New Update and Database errors](https://wordpress.org/support/topic/new-update-and-database-errors/) * Thread Starter [mdoolittle](https://wordpress.org/support/users/mdoolittle/) * (@mdoolittle) * [10 months, 1 week ago](https://wordpress.org/support/topic/new-update-and-database-errors/#post-18645878) * Thank you! The developer version of 4.4.1 worked great. No errors. * Forum: [Plugins](https://wordpress.org/support/forum/plugins-and-hacks/) In reply to: [[EmbedPress – PDF Embedder, 3D PDF FlipBook, Google Reviews, YouTube Videos, Upload & Embed PDF documents] New Update and Database errors](https://wordpress.org/support/topic/new-update-and-database-errors/) * Thread Starter [mdoolittle](https://wordpress.org/support/users/mdoolittle/) * (@mdoolittle) * [10 months, 1 week ago](https://wordpress.org/support/topic/new-update-and-database-errors/#post-18645603) * No 4.4.1 does not fix my issue- I still get the following: * **WordPress database error:** [Specified key was too long; max key length is 1000 bytes] `CREATE TABLE IF NOT EXISTS ilwp_embedpress_analytics_content ( id bigint(20) unsigned NOT NULL AUTO_INCREMENT, content_id varchar(255) NOT NULL, content_type varchar(50) NOT NULL DEFAULT 'unknown', embed_type varchar(100) NOT NULL, embed_url text NOT NULL, post_id bigint(20) unsigned DEFAULT NULL, page_url text DEFAULT NULL, title varchar(500) DEFAULT NULL, total_views bigint( 20) unsigned DEFAULT 0, total_impressions bigint(20) unsigned DEFAULT 0, total_clicks bigint(20) unsigned DEFAULT 0, created_at datetime DEFAULT CURRENT_TIMESTAMP, updated_at datetime DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, PRIMARY KEY (id), UNIQUE KEY unique_page_embed (page_url(255), embed_type), KEY idx_content_type( content_type), KEY idx_embed_type (embed_type), KEY idx_post_id (post_id), KEY idx_created_at (created_at), KEY idx_total_views (total_views) ) DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci` * **WordPress database error:** [Specified key was too long; max key length is 1000 bytes] `CREATE TABLE IF NOT EXISTS ilwp_embedpress_analytics_views ( id bigint(20) unsigned NOT NULL AUTO_INCREMENT, content_id varchar(255) NOT NULL, user_id varchar(255) DEFAULT NULL, session_id varchar(255) NOT NULL, user_ip varchar(45) DEFAULT NULL, user_agent text DEFAULT NULL, referrer_url text DEFAULT NULL, page_url text DEFAULT NULL, interaction_type enum('impression', 'click',' view', 'play', 'pause', 'complete') NOT NULL DEFAULT 'impression', interaction_data json DEFAULT NULL, view_duration int(11) unsigned DEFAULT 0, created_at datetime DEFAULT CURRENT_TIMESTAMP, PRIMARY KEY (id), KEY idx_content_id (content_id), KEY idx_user_id (user_id), KEY idx_session_id (session_id), KEY idx_interaction_type( interaction_type), KEY idx_created_at (created_at), KEY idx_user_ip (user_ip), KEY idx_content_interaction (content_id, interaction_type), KEY idx_daily_stats( content_id, interaction_type, created_at), KEY idx_user_content_interaction ( user_id, content_id, interaction_type), KEY idx_deduplication (user_id, content_id, interaction_type, created_at) ) DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci` * **WordPress database error:** [Specified key was too long; max key length is 1000 bytes] `CREATE TABLE IF NOT EXISTS ilwp_embedpress_analytics_browser_info( id bigint(20) unsigned NOT NULL AUTO_INCREMENT, user_id varchar(255) DEFAULT NULL, session_id varchar(255) NOT NULL, browser_fingerprint varchar(64) DEFAULT NULL, browser_name varchar(100) DEFAULT NULL, browser_version varchar(50) DEFAULT NULL, operating_system varchar(100) DEFAULT NULL, device_type enum('desktop',' mobile', 'tablet', 'unknown') DEFAULT 'unknown', screen_resolution varchar(20) DEFAULT NULL, language varchar(10) DEFAULT NULL, timezone varchar(50) DEFAULT NULL, country varchar(100) DEFAULT NULL, city varchar(100) DEFAULT NULL, user_agent text DEFAULT NULL, created_at datetime DEFAULT CURRENT_TIMESTAMP, PRIMARY KEY( id), UNIQUE KEY unique_user_fingerprint (user_id, browser_fingerprint), KEY idx_user_id( user_id), KEY idx_session_id (session_id), KEY idx_browser_fingerprint (browser_fingerprint), KEY idx_browser_name (browser_name), KEY idx_operating_system (operating_system), KEY idx_device_type (device_type), KEY idx_country (country), KEY idx_created_at( created_at) ) DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci` * **WordPress database error:** [Specified key was too long; max key length is 1000 bytes] `CREATE TABLE IF NOT EXISTS ilwp_embedpress_analytics_referrers ( id bigint(20) unsigned NOT NULL AUTO_INCREMENT, referrer_url text NOT NULL, referrer_domain varchar(255) NOT NULL, referrer_source varchar(100) DEFAULT NULL, utm_source varchar(100) DEFAULT NULL, utm_medium varchar(100) DEFAULT NULL, utm_campaign varchar(255) DEFAULT NULL, utm_term varchar(255) DEFAULT NULL, utm_content varchar( 255) DEFAULT NULL, total_views bigint(20) unsigned DEFAULT 0, total_clicks bigint( 20) unsigned DEFAULT 0, unique_visitors bigint(20) unsigned DEFAULT 0, first_visit datetime DEFAULT CURRENT_TIMESTAMP, last_visit datetime DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, created_at datetime DEFAULT CURRENT_TIMESTAMP, updated_at datetime DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, PRIMARY KEY ( id), UNIQUE KEY unique_referrer_url (referrer_url(255)), KEY idx_referrer_domain( referrer_domain), KEY idx_referrer_source (referrer_source), KEY idx_utm_source( utm_source), KEY idx_utm_medium (utm_medium), KEY idx_utm_campaign (utm_campaign), KEY idx_total_views (total_views), KEY idx_total_clicks (total_clicks), KEY idx_unique_visitors( unique_visitors), KEY idx_first_visit (first_visit), KEY idx_last_visit (last_visit), KEY idx_created_at (created_at) ) DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci` Viewing 2 replies - 1 through 2 (of 2 total)