Database error – embedpress_analytics_views

Hi,

We have EmbedPress installed since a long time. Latest version.
But recently we encountered a db error :

AH01071: Got error 'PHP message: WordPress database error You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'json DEFAULT NULL,\n view_duration int(11) unsigned DEFAULT 0,\n ' at line 11 for query CREATE TABLE IF NOT EXISTS XXXXX_embedpress_analytics_views (\n id bigint(20) unsigned NOT NULL AUTO_INCREMENT,\n content_id varchar(255) NOT NULL,\n user_id varchar(255) DEFAULT NULL,\n session_id varchar(255) NOT NULL,\n user_ip varchar(45) DEFAULT NULL,\n user_agent text DEFAULT NULL,\n referrer_url text DEFAULT NULL,\n page_url text DEFAULT NULL,\n interaction_type enum('impression', 'click', 'view', 'play', 'pause', 'complete') NOT NULL DEFAULT 'impression',\n interaction_data json DEFAULT NULL,\n view_duration int(11) unsigned DEFAULT 0,\n created_at datetime DEFAULT CURRENT_TIMESTAMP,\n PRIMARY KE...', referer: XXXXXX

I tried deactivating and uninstalling the extension and reinstalling to correct this table.
But the table does not recreate.
What would you suggest to correct this error ?

In advance, thank you very much for your assistance.
Kind regards.