PHP Error Log

  • Resolved DickRaney

    (@dickraney)


    4 years, 5 months ago

    [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)
  • Plugin Author Daniel Iser

    (@danieliser)

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

    • This reply was modified 4 years, 2 months ago by Daniel Iser. Reason: forgot the link
    Thread Starter DickRaney

    (@dickraney)

    I’m running:
    Ver 15.1 distrib 10.2.33 MariaDB for Linux (x86_64)

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