Title: PHP Error Log Last modified: June 30, 2020 --- # PHP Error Log * Resolved [DickRaney](https://wordpress.org/support/users/dickraney/) * (@dickraney) * [5 years, 11 months ago](https://wordpress.org/support/topic/php-error-log-23/) * [29-Jun-2020 18:28:57 UTC] 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 ‘values longtext NOT NULL, uuid varchar(255) NOT NULL, consent varchar(25’ at line 10 for query CREATE TABLE wp_pum_subscribers( ID bigint(20) NOT NULL AUTO_INCREMENT, email_hash varchar(32) NOT NULL, popup_id bigint(20) NOT NULL, user_id bigint(20) NOT NULL, email varchar(191) NOT NULL, name varchar(255) NOT NULL, fname varchar(255) NOT NULL, lname varchar(255) NOT NULL, values longtext NOT NULL, uuid varchar(255) NOT NULL, consent varchar(255) NOT NULL, consent_args longtext NOT NULL, created datetime NOT NULL, PRIMARY KEY (ID), KEY email (email), KEY user_id (user_id), KEY popup_id (popup_id), KEY email_hash (email_hash) ) DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci made by require_once(‘wp-admin/admin.php’), do_action(‘popup_page_pum-subscribers’), WP_Hook->do_action, WP_Hook->apply_filters, PUM_Admin_Subscribers::page, PUM_Admin_Subscribers_Table- >prepare_items, PUM_Abstract_Database::instance, PUM_Abstract_Database->__construct, PUM_DB_Subscribers->create_table, dbDelta [29-Jun-2020 18:28:57 UTC] WordPress database error Table ‘wordpress.wp_pum_subscribers’ doesn’t exist for query SELECT` ID`, `uuid`, `popup_id`, `email_hash`, `email`, `name`, `fname`, `lname`, `values`,` user_id`, `consent_args`, `consent`, `created` FROM wp_pum_subscribers WHERE 1=1 LIMIT 20 made by require_once(‘wp-admin/admin.php’), do_action(‘popup_page_pum- subscribers’), WP_Hook->do_action, WP_Hook->apply_filters, PUM_Admin_Subscribers:: page, PUM_Admin_Subscribers_Table->prepare_items, PUM_DB_Subscribers->query [ 29-Jun-2020 18:28:57 UTC] WordPress database error Table ‘wordpress.wp_pum_subscribers’ doesn’t exist for query SELECT `ID`, `uuid`, `popup_id`, `email_hash`, `email`,` name`, `fname`, `lname`, `values`, `user_id`, `consent_args`, `consent`, `created` FROM wp_pum_subscribers WHERE 1=1 made by require_once(‘wp-admin/admin.php’), do_action(‘popup_page_pum-subscribers’), WP_Hook->do_action, WP_Hook->apply_filters, PUM_Admin_Subscribers::page, PUM_Admin_Subscribers_Table->prepare_items, PUM_DB_Subscribers- >total_rows, PUM_DB_Subscribers->query Viewing 2 replies - 16 through 17 (of 17 total) [←](https://wordpress.org/support/topic/php-error-log-23/?output_format=md) [1](https://wordpress.org/support/topic/php-error-log-23/?output_format=md) 2 * Plugin Author [Daniel Iser](https://wordpress.org/support/users/danieliser/) * (@danieliser) * [5 years, 9 months ago](https://wordpress.org/support/topic/php-error-log-23/page/2/#post-13386201) * [@itatih](https://wordpress.org/support/users/itatih/), [@mickdom](https://wordpress.org/support/users/mickdom/), [@dickraney](https://wordpress.org/support/users/dickraney/) – Can you all post your MySQL version? This seems to be an issue with a very specific version of MySQL as we have users without issue with most of them so far as we can tell. * Looking it up now, it appears that MySQL version 8.0.19 recently added a `VALUES` keyword which is unfortunate and will require not only a table structure change but also a data migration :(. * If you can manually create the table in the mean time by surrounding the `values` field with backticks that should suffice, but I don’t believe it will work for us long term as using WordPress’s built in DB table management requires leaving the quotes off. * I have opened an issue to get this worked out. You can track any further progress or make any further follow ups there as the official source of this issue going forward. As such I am marking this resolved so we can keep it all in one place. * [https://github.com/PopupMaker/Popup-Maker/issues/876](https://github.com/PopupMaker/Popup-Maker/issues/876) - This reply was modified 5 years, 9 months ago by [Daniel Iser](https://wordpress.org/support/users/danieliser/). Reason: forgot the link * Thread Starter [DickRaney](https://wordpress.org/support/users/dickraney/) * (@dickraney) * [5 years, 9 months ago](https://wordpress.org/support/topic/php-error-log-23/page/2/#post-13387553) * I’m running: Ver 15.1 distrib 10.2.33 MariaDB for Linux (x86_64) Viewing 2 replies - 16 through 17 (of 17 total) [←](https://wordpress.org/support/topic/php-error-log-23/?output_format=md) [1](https://wordpress.org/support/topic/php-error-log-23/?output_format=md) 2 The topic ‘PHP Error Log’ is closed to new replies. * ![](https://ps.w.org/popup-maker/assets/icon-256x256.gif?rev=3097653) * [Popup Maker - Boost Sales, Conversions, Optins, Subscribers with the Ultimate WP Popup Builder](https://wordpress.org/plugins/popup-maker/) * [Frequently Asked Questions](https://wordpress.org/plugins/popup-maker/#faq) * [Support Threads](https://wordpress.org/support/plugin/popup-maker/) * [Active Topics](https://wordpress.org/support/plugin/popup-maker/active/) * [Unresolved Topics](https://wordpress.org/support/plugin/popup-maker/unresolved/) * [Reviews](https://wordpress.org/support/plugin/popup-maker/reviews/) * 17 replies * 5 participants * Last reply from: [DickRaney](https://wordpress.org/support/users/dickraney/) * Last activity: [5 years, 9 months ago](https://wordpress.org/support/topic/php-error-log-23/page/2/#post-13387553) * Status: resolved