Session error with 2.0.7 version – wp_sm_sessions table exist but is empty

  • Resolved Bojan121

    (@bojan121)


    7 years, 2 months ago

    @pderksen I’m seeing this error in my log:

    [error] 1460#1460: *248541 FastCGI sent in stderr: "PHP message: WordPress database error Table 'xxxxx.wp_sm_sessions' doesn't exist for query SELECT * FROM wp_sm_sessions WHERE session_key = '2eff306ffa84dbd04bb9a6290a3bbccd' made by require('wp-blog-header.php'), require_once('wp-load.php'), require_once('wp-config.php'), require_once('wp-settings.php'), include_once('/plugins/stripe/stripe-checkout.php'), require_once('/plugins/stripe/includes/core/main.php'), SimplePay\Core\SimplePay, SimplePay\Core\SimplePay::instance, SimplePay\Core\SimplePay->__construct, SimplePay\Core\SimplePay->load, SimplePay\Core\Session->__construct, SimplePay\Core\Session->init, WP_Session::get_instance, WP_Session->__construct, WP_Session->read_data, WP_Session_Utils::get_session"

    Here is my system status:

    
### WordPress Installation ###

Site Name: Lifestyle Updated
Home URL: https://www.lifestyleupdated.com
Site URL: https://www.lifestyleupdated.com
SSL/HTTPS Enabled: Yes
Version: 4.9.1
Locale: en_US
Multisite: No
Permalinks: /%year%/%monthnum%/%day%/%postname%/
WP Memory Limit: 6 GB
WP Debug Mode: Yes
Script Debug: No

### WP Simple Pay Settings ###

WP Simple Pay Version: 2.0.7
Stripe TLS: TLS 1.2 is supported. No action required.
Simple Pay Test or Live Mode: Live Mode

### Active Theme ###

Theme: Lifestyle - 1.0
Child Theme: No
Parent Theme: -

### Active Plugins ###

Amazon Associates Link Builder: 1.5.2
Yoast SEO: 6.0
NextScripts: Social Networks Auto-Poster: 4.1.1
WP Simple Pay (Lite Version): 2.0.7
Redis Object Cache: 1.3.5
Fast Secure reCAPTCHA: 1.0.20
AJAX Search for WooCommerce: 1.1.6
WooCommerce: 3.2.6
WOOF - WooCommerce Products Filter: 1.1.8
UpdraftPlus - Backup/Restore: 1.14.2
Clean My Archives: 1.2.0
iThemes Security: 6.7.0
Custom Post Type UI: 1.5.6
Contact Form 7: 4.9.2
Enhanced E-commerce for Woocommerce store: 1.2.1.1
Google XML Sitemaps: 4.0.9
Advanced Custom Fields: 4.4.12
Fluid Video Embeds: 1.2.9
WP-Optimize: 2.1.1
nginx fastcgi Cache Purge: 0.0.2
WooZone - WooCommerce Amazon Affiliates: 9.0.6.9

### Server Environment ###

Web Server: nginx/1.10.3
PHP Version: 7.0.22-0ubuntu0.16.04.1
MySQL Version: 5.7.20-0ubuntu0.16.04.1-log
Server Timezone: UTC
Display Errors: No
Server PHP Memory Limit: 6000M
Upload Max Filesize: 20M
Post Max Size: 8M
Max Execution Time: 1200
Max Input Vars: 1000
fsockopen: Yes
cURL: 7.47.0
OpenSSL/1.0.2g
SOAP: Yes
SUHOSIN: No
WP Remote POST: Yes
WP Remote GET: Yes

### Client Information ###

IP Address: 192.241.182.201
Browser: Chrome 63.0.3239.84 (Windows)
Viewing 2 replies - 1 through 2 (of 2 total)
  • Plugin Contributor Phil Derksen

    (@pderksen)

    @bojan121 That database table should have been created with the plugin update, but somehow it didn’t happen for you.

    Could you try deactivating and reactivating WP Simple Pay to see if that fixes it?

    I’m not sure how technical you are, but another way to “reset” this is to go into your wp_options table and delete the sm_session_db_version option, then reactivate WP Simple Pay once again.

    Or you can try deleting and reinstalling the plugin altogether.

    Plugin Contributor Phil Derksen

    (@pderksen)

    @bojan121 We just released 2.0.8 that allows you to force use of PHP sessions if needed for your host. Just set the SIMPLE_PAY_USE_PHP_SESSIONS constant to true in your wp-config.php.

    define( ‘SIMPLE_PAY_USE_PHP_SESSIONS’, true );

Viewing 2 replies - 1 through 2 (of 2 total)
  • The topic ‘Session error with 2.0.7 version – wp_sm_sessions table exist but is empty’ is closed to new replies.