Title: Database error – embedpress_analytics_views Last modified: January 26, 2026 --- # Database error – embedpress_analytics_views * Resolved [Jean Hertz](https://wordpress.org/support/users/gvatec2021h/) * (@gvatec2021h) * [3 months, 1 week ago](https://wordpress.org/support/topic/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. Viewing 4 replies - 1 through 4 (of 4 total) * Plugin Support [AR Rasel](https://wordpress.org/support/users/arrasel403/) * (@arrasel403) * [3 months, 1 week ago](https://wordpress.org/support/topic/database-error-embedpress_analytics_views/#post-18799412) * Hi [@gvatec2021h](https://wordpress.org/support/users/gvatec2021h/), * Hope you’re doing well. Sorry to hear you’re experiencing this issue. * We’ve applied a fix in our development version of the plugin. Please download the Dev version from [this link](https://d.pr/f/LLzkMp) and install it on your site, then check again. We’re hopeful this will resolve the issue. * Let us know how it goes, and we’ll be happy to assist further if needed. * Thanks! * Thread Starter [Jean Hertz](https://wordpress.org/support/users/gvatec2021h/) * (@gvatec2021h) * [3 months, 1 week ago](https://wordpress.org/support/topic/database-error-embedpress_analytics_views/#post-18802097) * Thank you very much for your quick reply. I had already uploaded your latest Dev version. Re uploaded again. Still getting errors so I deactivated the analytics part. Looks ok for now. At this point I prefer to leave it as is for the next few weeks. Later, I’ll come back to try to activate the analytics side again and recheck what can be done. * Many thanks. * Plugin Support [AR Rasel](https://wordpress.org/support/users/arrasel403/) * (@arrasel403) * [2 months, 2 weeks ago](https://wordpress.org/support/topic/database-error-embedpress_analytics_views/#post-18822271) * Hi [@gvatec2021h](https://wordpress.org/support/users/gvatec2021h/), * We’ve included the fix in our latest release. Please update the plugin to the newest version and check from your end. Let us know whether the issue still persists. * Looking forward to your update. Thanks! * Plugin Support [AR Rasel](https://wordpress.org/support/users/arrasel403/) * (@arrasel403) * [2 months, 2 weeks ago](https://wordpress.org/support/topic/database-error-embedpress_analytics_views/#post-18825604) * Hi [@gvatec2021h](https://wordpress.org/support/users/gvatec2021h/), * I hope this message finds you well. I wanted to follow up on a previous support request that you submitted. I understand that the thread was marked as resolved due to a lack of activity, but I wanted to let you know that you are always welcome to re-open the topic if you have any further questions or concerns. * Before opening a new request, however, I kindly request that you take a moment to read through this post. It may contain the answers to your questions or provide you with a solution to your issue. If you still require assistance after reading this post, please do not hesitate to reopen the thread or submit a new request. * Thank you for your attention to this matter. I look forward to hearing from you soon. Viewing 4 replies - 1 through 4 (of 4 total) You must be [logged in](https://login.wordpress.org/?redirect_to=https%3A%2F%2Fwordpress.org%2Fsupport%2Ftopic%2Fdatabase-error-embedpress_analytics_views%2F%3Foutput_format%3Dmd&locale=en_US) to reply to this topic. * ![](https://ps.w.org/embedpress/assets/icon-128x128.gif?rev=3419899) * [EmbedPress – PDF Embedder, Embed PDF viewer, YouTube Videos, 3D FlipBook, Social feeds & more](https://wordpress.org/plugins/embedpress/) * [Frequently Asked Questions](https://wordpress.org/plugins/embedpress/#faq) * [Support Threads](https://wordpress.org/support/plugin/embedpress/) * [Active Topics](https://wordpress.org/support/plugin/embedpress/active/) * [Unresolved Topics](https://wordpress.org/support/plugin/embedpress/unresolved/) * [Reviews](https://wordpress.org/support/plugin/embedpress/reviews/) ## Tags * [Database Error](https://wordpress.org/support/topic-tag/database-error/) * 7 replies * 2 participants * Last reply from: [AR Rasel](https://wordpress.org/support/users/arrasel403/) * Last activity: [2 months, 2 weeks ago](https://wordpress.org/support/topic/database-error-embedpress_analytics_views/#post-18825604) * Status: resolved