• Resolved DickRaney

    (@dickraney)


    [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)
  • I have the same error!

    Wordpress will no longer work after that!

    Maria T

    (@mariatogonon)

    Hey @dickraney, @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

    (@danieliser)

    @mickdom, @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.

    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

    Thread Starter DickRaney

    (@dickraney)

    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

    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 4 years, 5 months ago by DickRaney.

    Hello danieliser,

    please note that I have another error! I couldn’t see that at first, sorry.

    Best regards!

    Hello danieliser,

    have you determine anything yet?

    Plugin Author Daniel Iser

    (@danieliser)

    @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?

    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

    @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?

    @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 4 years, 3 months ago by mickdom.

    @mickdom Thanks for your information.

    @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

    field values must quoted `

    • This reply was modified 4 years, 3 months ago by mickdom.
    • This reply was modified 4 years, 3 months ago by mickdom.
    • This reply was modified 4 years, 3 months ago by mickdom.

    @mickdom
    Thank you veri much for your information. It has been my solution.

Viewing 15 replies - 1 through 15 (of 17 total)
  • The topic ‘PHP Error Log’ is closed to new replies.