• Resolved bizcomweb

    (@bizcomweb)


    I am using NP Quote Request WooCommerce by Neah Plugins (version 1.8.274) and I’m getting an error on my WP site as follows:

    WordPress database error {Table ‘wp_db.wp_npxyz2021_sessions’ doesn’t exist]
    SELECT option_value FROM wp_npxyz2021_sessions WHERE option_name + ‘_rfqtk_wp_session_94a0bc25760abd8f0a9217c9b5ba6209’ LIMIT 1

    I don’t see that db table in the database. Anyone else having this issue or know of a fix?

    Thanks

Viewing 13 replies - 1 through 13 (of 13 total)
  • Plugin Author Neah Plugins

    (@gplsaver)

    it should have been created after the update. it might be a database permission issue to create it. Please try this:
    inactivate and deactivate the plugin. it should create the table if it does not exist.
    it would be helpful to enable WordPress debug so we can see the errors in the log file.

    Can you enable WordPress debug in wp-config.php by adding

    define(‘WP_DEBUG’, true);
    define(‘WP_DEBUG_LOG’, true);
    define( ‘WP_DEBUG_DISPLAY’, false );

    to your wp-config.php

    Find wp-config.php in your WordPress directory and copy and paste the 3 lines above in that file. Make sure none of the lines are repeated in the file.
    deactivate and inactivate the plugin and check the debug.log file in the wp-content directory.

    Plugin Author Neah Plugins

    (@gplsaver)

    Hi,
    Just checking if the issue has been resolved.

    Thread Starter bizcomweb

    (@bizcomweb)

    Looks like that did the trick. I don’t see the error any longer. Thank you. Will try your recommendations if it returns.

    Plugin Author Neah Plugins

    (@gplsaver)

    thanks for the feedback.

    Hi,
    I’m having the same issue.

    WordPress database error: [Table ‘ics_dev.wp_npxyz2021_sessions’ doesn’t exist]
    UPDATE wp_npxyz2021_sessions set expiration= ‘1639796815’ where option_name = ‘_rfqtk_wp_session_4da546c60f89c28be8411cf999939575’

    I’ve deactivated / reactivated the plugin, deleted and reinstalled but not having any success. Do you have any other suggestions??

    Plugin Author Neah Plugins

    (@gplsaver)

    if you have access to the database, run the following sql code to create the table. maybe there is a permission issue and WordPress is not able to create the table during activation. you can use this plugin WP Data Access.

    CREATE TABLEwp_npxyz2021_sessions` (
    option_id bigint(20) unsigned NOT NULL AUTO_INCREMENT,
    option_name varchar(191) NOT NULL,
    option_value longtext NOT NULL,
    expiration bigint(20) NOT NULL,
    misc_value longtext,
    created timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
    updated timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
    PRIMARY KEY (option_id),
    UNIQUE KEY option_name (option_name)
    ) ENGINE=InnoDB DEFAULT CHARSET=utf8;`

    Hi, thanks for the fast reply.

    Tried to run command but getting error below. MYSQL version 5.1.73

    #1064 – 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 ‘TABLEmp_npxyz2021_sessions` (
    option_id bigint(20) unsigned NOT NULL AUTO_INCR’ at line 1

    Also tried changing option_id line to below but still didn’t work.

    CREATE TABLEmp_npxyz2021_sessions` (
    option_id bigint(20) NOT NULL AUTO_INCREMENT PRIMARY KEY,
    option_name varchar(191) NOT NULL,
    option_value longtext NOT NULL,
    expiration bigint(20) NOT NULL,
    misc_value longtext,
    created timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
    updated timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
    PRIMARY KEY (option_id),
    UNIQUE KEY option_name (option_name)
    ) ENGINE=InnoDB DEFAULT CHARSET=utf8;`

    Plugin Author Neah Plugins

    (@gplsaver)

    try this one. your is not the same. make sure there is a space between table
    and wp_npxyz2021_sessions

    CREATE TABLE wp_npxyz2021_sessions (
    option_id bigint(20) unsigned NOT NULL AUTO_INCREMENT,
    option_name varchar(191) NOT NULL,
    option_value longtext NOT NULL,
    expiration bigint(20) NOT NULL,
    misc_value longtext,
    created timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
    updated timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
    PRIMARY KEY (option_id),
    UNIQUE KEY option_name (option_name)
    ) ENGINE=InnoDB DEFAULT CHARSET=utf8;

    Okay thanks.
    New error now..
    #1293 – Incorrect table definition; there can be only one TIMESTAMP column with CURRENT_TIMESTAMP in DEFAULT or ON UPDATE clause

    Plugin Author Neah Plugins

    (@gplsaver)

    your MySQL version is kind of old 5.1.73. this is a limitation that has been lifted as of MySQL 5.6.5. I suggest you upgrade at least to that. this probably why it did not work on activation.

    Plugin Author Neah Plugins

    (@gplsaver)

    You can try updating to 1.8.279. we have made an attempt to make it backward compatible with MySQl 5.1. But 5.1 will likely still give incompatibility problems down the road. Hope this works.

    The site is running on a very old Centos 6 server so it was a little problematic to update MySQL using default yum updates. However I’ve managed to manually update it this morning so now running 6.5 and was able to successfully update the database with the new tables.

    Thanks for the great support. Much appreciated!!

    Plugin Author Neah Plugins

    (@gplsaver)

    6.5 will give you a lot less trouble 🙂

Viewing 13 replies - 1 through 13 (of 13 total)
  • The topic ‘NP Quote Request WooCommerce Table Doesn’t Exist’ is closed to new replies.