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 15 replies - 1 through 15 (of 17 total) 1 [2](https://wordpress.org/support/topic/php-error-log-23/page/2/?output_format=md) [→](https://wordpress.org/support/topic/php-error-log-23/page/2/?output_format=md) * [mickdom](https://wordpress.org/support/users/mickdom/) * (@mickdom) * [5 years, 11 months ago](https://wordpress.org/support/topic/php-error-log-23/#post-13055351) * I have the same error! * Wordpress will no longer work after that! * [Maria T](https://wordpress.org/support/users/mariatogonon/) * (@mariatogonon) * [5 years, 11 months ago](https://wordpress.org/support/topic/php-error-log-23/#post-13061233) * Hey [@dickraney](https://wordpress.org/support/users/dickraney/), [@mickdom](https://wordpress.org/support/users/mickdom/)– sorry for the inconvenience this has caused you, and thanks for bringing this to our attention. ​ ​I will now forward this to our lead developer and we will keep you posted as soon as we get any feedback. * We appreciate your patience. * Plugin Author [Daniel Iser](https://wordpress.org/support/users/danieliser/) * (@danieliser) * [5 years, 11 months ago](https://wordpress.org/support/topic/php-error-log-23/#post-13061664) * [@mickdom](https://wordpress.org/support/users/mickdom/), [@dickraney](https://wordpress.org/support/users/dickraney/)– Hmm was everything working previously? Can you confirm that the pum_subscribers table does in fact exist? * We haven’t seen this in any of our testing so if you can bear with me and help Me track down why it’s happening we will get it worked out. * [mickdom](https://wordpress.org/support/users/mickdom/) * (@mickdom) * [5 years, 11 months ago](https://wordpress.org/support/topic/php-error-log-23/#post-13065460) * Hello danieliser, * Sorry for the late reply. I couldn’t repeat it before. After updating your plugin, I have to delete the plugin folder and restore it from the backup. Otherwise WordPress no longer works. My error message is attached as loom-video-link. The tables _actionscheduler_ * do not exist in the database! * [https://www.loom.com/share/82623096a5ee4a2a9d1ce38625f178b0](https://www.loom.com/share/82623096a5ee4a2a9d1ce38625f178b0) * Thread Starter [DickRaney](https://wordpress.org/support/users/dickraney/) * (@dickraney) * [5 years, 11 months ago](https://wordpress.org/support/topic/php-error-log-23/#post-13065599) * I don’t know if this is a real error or not. I actually copied that error data from this site [https://plugintests.com/plugins/popup-maker/latest](https://plugintests.com/plugins/popup-maker/latest) * I was looking for something else and just ran across it, and since I use the plugin, I was concerned. * It may not be a valid issue. - This reply was modified 5 years, 11 months ago by [DickRaney](https://wordpress.org/support/users/dickraney/). * [mickdom](https://wordpress.org/support/users/mickdom/) * (@mickdom) * [5 years, 11 months ago](https://wordpress.org/support/topic/php-error-log-23/#post-13065633) * Hello danieliser, * please note that I have another error! I couldn’t see that at first, sorry. * Best regards! * [mickdom](https://wordpress.org/support/users/mickdom/) * (@mickdom) * [5 years, 10 months ago](https://wordpress.org/support/topic/php-error-log-23/#post-13070251) * Hello danieliser, * have you determine anything yet? * Plugin Author [Daniel Iser](https://wordpress.org/support/users/danieliser/) * (@danieliser) * [5 years, 10 months ago](https://wordpress.org/support/topic/php-error-log-23/#post-13087717) * [@mickdom](https://wordpress.org/support/users/mickdom/) – We were not able to duplicate this so far, the only reports have been from an automated report and yourself so I’m curious if your still seeing it and if it goes away if you activate the Health Check plugin’s Troubleshooting mode on our plugin alone? * [itatih](https://wordpress.org/support/users/itatih/) * (@itatih) * [5 years, 9 months ago](https://wordpress.org/support/topic/php-error-log-23/#post-13203576) * I have the same error! pum_subscribers table does not exist. At what point is the table created? I use newsletter plugin, I dont use subscriber form of popup maker. Regards! * 03-Aug-2020 12:47:01 UTC] Error Table ‘wp80.wp80_pum_subscribers’ doesn’t exist de la base de datos de WordPress para la consulta SELECT `ID`, `uuid`, `popup_id`,` email_hash`, `email`, `name`, `fname`, `lname`, `values`, `user_id`, `consent_args`,` consent`, `created` FROM wp80_pum_subscribers WHERE 1=1 LIMIT 20 realizada por 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 [03-Aug-2020 12:47:01 UTC] Error Table‘ wp80.wp80_pum_subscribers’ doesn’t exist de la base de datos de WordPress para la consulta SELECT `ID`, `uuid`, `popup_id`, `email_hash`, `email`, `name`, ` fname`, `lname`, `values`, `user_id`, `consent_args`, `consent`, `created` FROM wp80_pum_subscribers WHERE 1=1 realizada por 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 * [mickdom](https://wordpress.org/support/users/mickdom/) * (@mickdom) * [5 years, 9 months ago](https://wordpress.org/support/topic/php-error-log-23/#post-13203643) * @danielliser: * It will not go away (…Health Check plugin’s Troubleshooting mode on our plugin alone)! I still haven’t been able to update your plugin. * The only thing I noticed at the beginning is that I accidentally double-clicked your update at the beginning. Maybe that helps? * [mickdom](https://wordpress.org/support/users/mickdom/) * (@mickdom) * [5 years, 9 months ago](https://wordpress.org/support/topic/php-error-log-23/#post-13213977) * [@danieliser](https://wordpress.org/support/users/danieliser/): * I created the tables manually: * actionscheduler_actions, actionscheduler_claims, actionscheduler_groups (with entry “action-scheduler-migration”), actionscheduler_logs * Then the update works! * But only the following plugins use the tables (reference: WP-Optimize): * woocommerce, wpforms-lite, email-subscribers, woocommerce-abandoned-cart, invoicing, newsletter-optin-box, wp-marketing-automations - This reply was modified 5 years, 9 months ago by [mickdom](https://wordpress.org/support/users/mickdom/). * [itatih](https://wordpress.org/support/users/itatih/) * (@itatih) * [5 years, 9 months ago](https://wordpress.org/support/topic/php-error-log-23/#post-13223720) * [@mickdom](https://wordpress.org/support/users/mickdom/) Thanks for your information. * [itatih](https://wordpress.org/support/users/itatih/) * (@itatih) * [5 years, 9 months ago](https://wordpress.org/support/topic/php-error-log-23/#post-13246559) * [@danieliser](https://wordpress.org/support/users/danieliser/) Please I need your help. I have a problem with the database. When Popup Maker tries to create wp_pum_subscribers table, I see an error in php-error.log The Mysqls version is 8.0.20. Thanks * The error you see in the log is: [12-Aug-2020 20:05:16 UTC] 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 de la base de datos de WordPress para la consulta 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 realizada por 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 * [mickdom](https://wordpress.org/support/users/mickdom/) * (@mickdom) * [5 years, 9 months ago](https://wordpress.org/support/topic/php-error-log-23/#post-13246650) * field values must quoted ` - This reply was modified 5 years, 9 months ago by [mickdom](https://wordpress.org/support/users/mickdom/). - This reply was modified 5 years, 9 months ago by [mickdom](https://wordpress.org/support/users/mickdom/). - This reply was modified 5 years, 9 months ago by [mickdom](https://wordpress.org/support/users/mickdom/). * [itatih](https://wordpress.org/support/users/itatih/) * (@itatih) * [5 years, 9 months ago](https://wordpress.org/support/topic/php-error-log-23/#post-13294290) * [@mickdom](https://wordpress.org/support/users/mickdom/) Thank you veri much for your information. It has been my solution. Viewing 15 replies - 1 through 15 (of 17 total) 1 [2](https://wordpress.org/support/topic/php-error-log-23/page/2/?output_format=md) [→](https://wordpress.org/support/topic/php-error-log-23/page/2/?output_format=md) 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, 8 months ago](https://wordpress.org/support/topic/php-error-log-23/page/2/#post-13387553) * Status: resolved