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 'json DEFAULT NULL, view_duration int(11) unsigned DEFAULT 0, ' at line 11]
CREATE TABLE IF NOT EXISTS wp_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(191)), KEY idx_user_id (user_id(191)), KEY idx_session_id (session_id(191)), KEY idx_interaction_type (interaction_type), KEY idx_created_at (created_at), KEY idx_user_ip (user_ip), KEY idx_content_interaction (content_id(191), interaction_type), KEY idx_daily_stats (content_id(191), interaction_type, created_at), KEY idx_user_content_interaction (user_id(100), content_id(100), interaction_type), KEY idx_deduplication (user_id(100), content_id(100), interaction_type, created_at) ) DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci

100 Years – Port Talbot Harriers