Missing tables: wp_woocommerce_sessions

Resolved ppoz4
(@ppoz4)

3 years, 2 months ago

Hi,
The users of my website are facing an “empty cart” problem when they place a product, via their smartphone. I’ve tried to disable all plugins with only WooCommerce enabled, and also tried disabling then reactivating WooCommerce but still get the same ’empty cart’ errors. On a desktop/laptop it all works perfectly.
After checking WooCommerce Status, I realized that woocommerce_sessions table was missing in my database.
WooCommerce database version: 4.9.2
Is there any way to recreate the table manually? I’m not a data wizard unfortunately
Thanks in advance,
Pete

The page I need help with: [log in to see the link]

Viewing 7 replies - 1 through 7 (of 7 total)

Plugin Support

(@gabrielfuentes)

Hi Pete 👋

When WooCommerce is deactivated and activated again, it runs a check for WooCommerces database tables, and with that, it should create any missing table.

If the issue persists, please check that the database user that WordPress uses has the permissions to create tables.

Also, could you please go to Dashboard > Settings > Tools > Verify Database and let us know what you see there?

Cheers!

Thread Starter

ppoz4

(@ppoz4)

3 years, 2 months ago

Hi @gabrielfuentes
Thanks for your reply! (You’ve struck a complete novice here!)
I’m unsure how to check that the database user that WordPress uses has the permissions to create tables sorry.
Unfortunately I have very limited code knowledge so I had a friend of mine setup and develop my website, I can log into my site’s Dashboard but my Dashboard settings doesn’t show a Tools> Verify Database option…?
Am I looking in the wrong place looking on my site’s Dashboard?
Apologies again for the complete lack of code knowledge
Cheers!
Pete

Nico

(@nicolamustone)

Automattic Happiness Engineer

3 years, 2 months ago

Hello,

I can log into my site’s Dashboard but my Dashboard settings doesn’t show a Tools> Verify Database option…?

I think that @gabrielfuentes meant WooCommerce > Status > Tools > Product lookup tables > Click – Regenerate (Button on right)

Thread Starter

ppoz4

(@ppoz4)

3 years, 2 months ago

Hi Nicola,
Thanks for that! Lookup tables are regenerating now… I’ll let you know if it works 🙂
Cheers!
Pete

Thread Starter

ppoz4

(@ppoz4)

3 years, 2 months ago

Unfortunately that doesn’t seemed to have resolved the missing table issue @nicolamustone

Verifying database… One or more tables are still missing: wp_woocommerce_sessions

Is there anything obvious in my System Status Report?


### WordPress Environment ###

WordPress address (URL): https://www.peerecords.com/site
Site address (URL): https://www.peerecords.com/site
WC Version: 4.9.2
REST API Version: ✔ 4.9.2
WC Blocks Version: ✔ 4.0.0
Action Scheduler Version: ✔ 3.1.6
WC Admin Version: ✔ 1.8.3
Log Directory Writable: ✔
WP Version: 5.6
WP Multisite: –
WP Memory Limit: 512 MB
WP Debug Mode: –
WP Cron: ✔
Language: en
External object cache: –

### Server Environment ###

Server Info: LiteSpeed
PHP Version: 7.4.14
PHP Post Max Size: 64 MB
PHP Time Limit: 6000
PHP Max Input Vars: 3000
cURL Version: 7.71.0
OpenSSL/1.1.1d

SUHOSIN Installed: –
MySQL Version: 5.6.50
Max Upload Size: 64 MB
Default Timezone is UTC: ✔
fsockopen/cURL: ✔
SoapClient: ✔
DOMDocument: ✔
GZip: ✔
Multibyte String: ✔
Remote Post: ✔
Remote Get: ✔

### Database ###

WC Database Version: 4.9.2
WC Database Prefix: wp_
Total Database Size: 108.98MB
Database Data Size: 100.56MB
Database Index Size: 8.42MB
wp_woocommerce_sessions: Data: 0.00MB + Index: 0.00MB + Engine
wp_woocommerce_api_keys: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp_woocommerce_attribute_taxonomies: Data: 0.00MB + Index: 0.01MB + Engine MyISAM
wp_woocommerce_downloadable_product_permissions: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp_woocommerce_order_items: Data: 0.26MB + Index: 0.12MB + Engine MyISAM
wp_woocommerce_order_itemmeta: Data: 1.38MB + Index: 1.11MB + Engine MyISAM
wp_woocommerce_tax_rates: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp_woocommerce_tax_rate_locations: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp_woocommerce_shipping_zones: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp_woocommerce_shipping_zone_locations: Data: 0.00MB + Index: 0.01MB + Engine MyISAM
wp_woocommerce_shipping_zone_methods: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp_woocommerce_payment_tokens: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp_woocommerce_payment_tokenmeta: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp_woocommerce_log: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp_actionscheduler_actions: Data: 0.07MB + Index: 0.04MB + Engine MyISAM
wp_actionscheduler_claims: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp_actionscheduler_groups: Data: 0.00MB + Index: 0.01MB + Engine MyISAM
wp_actionscheduler_logs: Data: 0.05MB + Index: 0.04MB + Engine MyISAM
wp_bad_behavior: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp_be_product_alert_favorites: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp_be_product_alert_favorites_sessions: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp_be_product_alert_sessions: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp_be_product_alert_signups: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp_commentmeta: Data: 0.10MB + Index: 0.08MB + Engine MyISAM
wp_comments: Data: 1.75MB + Index: 0.76MB + Engine MyISAM
wp_links: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp_mail_bank: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp_mail_bank_email_logs: Data: 15.52MB + Index: 0.05MB + Engine InnoDB
wp_mail_bank_logs: Data: 57.48MB + Index: 0.07MB + Engine MyISAM
wp_mail_bank_meta: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp_options: Data: 1.96MB + Index: 0.19MB + Engine MyISAM
wp_pimwick_gift_card: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp_pimwick_gift_card_activity: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp_postmeta: Data: 7.78MB + Index: 3.19MB + Engine MyISAM
wp_posts: Data: 3.62MB + Index: 0.51MB + Engine MyISAM
wp_termmeta: Data: 0.01MB + Index: 0.02MB + Engine MyISAM
wp_terms: Data: 0.01MB + Index: 0.04MB + Engine MyISAM
wp_term_relationships: Data: 0.04MB + Index: 0.10MB + Engine MyISAM
wp_term_taxonomy: Data: 0.01MB + Index: 0.01MB + Engine MyISAM
wp_usermeta: Data: 0.84MB + Index: 0.54MB + Engine MyISAM
wp_users: Data: 0.03MB + Index: 0.04MB + Engine MyISAM
wp_wc_admin_notes: Data: 0.01MB + Index: 0.00MB + Engine MyISAM
wp_wc_admin_note_actions: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp_wc_category_lookup: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp_wc_customer_lookup: Data: 0.07MB + Index: 0.06MB + Engine MyISAM
wp_wc_download_log: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp_wc_order_coupon_lookup: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp_wc_order_product_lookup: Data: 0.22MB + Index: 0.19MB + Engine MyISAM
wp_wc_order_stats: Data: 0.09MB + Index: 0.06MB + Engine MyISAM
wp_wc_order_tax_lookup: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp_wc_product_meta_lookup: Data: 0.03MB + Index: 0.05MB + Engine MyISAM
wp_wc_reserved_stock: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp_wc_tax_rate_classes: Data: 0.00MB + Index: 0.01MB + Engine MyISAM
wp_wc_webhooks: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp_wfBlockedIPLog: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp_wfBlocks7: Data: 0.06MB + Index: 0.03MB + Engine MyISAM
wp_wfConfig: Data: 4.62MB + Index: 0.02MB + Engine MyISAM
wp_wfCrawlers: Data: 0.01MB + Index: 0.00MB + Engine MyISAM
wp_wfFileChanges: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp_wfFileMods: Data: 0.38MB + Index: 0.09MB + Engine MyISAM
wp_wfHits: Data: 1.48MB + Index: 0.36MB + Engine MyISAM
wp_wfHoover: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp_wfIssues: Data: 0.04MB + Index: 0.01MB + Engine MyISAM
wp_wfKnownFileList: Data: 1.08MB + Index: 0.13MB + Engine MyISAM
wp_wfLiveTrafficHuman: Data: 0.01MB + Index: 0.02MB + Engine MyISAM
wp_wfLocs: Data: 0.01MB + Index: 0.00MB + Engine MyISAM
wp_wfLogins: Data: 0.14MB + Index: 0.04MB + Engine MyISAM
wp_wfls_2fa_secrets: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_wfls_settings: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_wfNotifications: Data: 0.04MB + Index: 0.01MB + Engine MyISAM
wp_wfPendingIssues: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp_wfReverseCache: Data: 0.01MB + Index: 0.00MB + Engine MyISAM
wp_wfSNIPCache: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp_wfStatus: Data: 0.15MB + Index: 0.06MB + Engine MyISAM
wp_wfTrafficRates: Data: 0.01MB + Index: 0.01MB + Engine MyISAM
wp_yoast_indexable: Data: 0.95MB + Index: 0.20MB + Engine MyISAM
wp_yoast_indexable_hierarchy: Data: 0.00MB + Index: 0.01MB + Engine MyISAM
wp_yoast_migrations: Data: 0.00MB + Index: 0.01MB + Engine MyISAM
wp_yoast_primary_term: Data: 0.01MB + Index: 0.01MB + Engine MyISAM
wp_yoast_seo_links: Data: 0.16MB + Index: 0.05MB + Engine MyISAM
wp_yoast_seo_meta: Data: 0.03MB + Index: 0.03MB + Engine MyISAM

### Post Type Counts ###

amn_mi-lite: 3
attachment: 907
audio: 96
ccf_field: 4
ccf_form: 1
custom_css: 1
feedback: 154
gallery: 2
mc4wp-form: 2
nav_menu_item: 12
oembed_cache: 27
optionsframework: 11
page: 45
post: 122
product: 153
product_tabpage: 1
product_variation: 150
revision: 1534
shop_coupon: 2
shop_order: 1191
shop_order_refund: 5
slider: 1
tourdates: 27
video: 40
wpcf7_contact_form: 1

### Security ###

Secure connection (HTTPS): ✔
Hide errors from visitors: ✔

### Active Plugins (31) ###

AJAX Thumbnail Rebuild: by junkcoder
ristoniinemets – 1.13

Black Studio TinyMCE Widget: by Black Studio – 2.6.9
Classic Editor: by WordPress Contributors – 1.6
Contact Form 7: by Takayuki Miyoshi – 5.3.2
Easy Theme and Plugin Upgrades: by Chris Jean – 2.0.1
Enhanced Text Widget: by Clever Widgets – 1.5.1
Envato Market: by Envato – 2.0.6
Google Analytics for WordPress by MonsterInsights: by MonsterInsights – 7.15.1
Intuitive Custom Post Order: by hijiri – 3.1.2.1
Jetpack by WordPress.com: by Automattic – 9.3.1
Limit Login Attempts Reloaded: by Limit Login Attempts Reloaded – 2.19.2
MC4WP: Mailchimp for WordPress: by ibericode – 4.8.3
Meta Box: by MetaBox.io – 5.3.8
One Click Demo Import: by ProteusThemes – 2.6.1
PW WooCommerce Gift Cards: by Pimwick
LLC – 1.170

Really Simple SSL: by Really Simple Plugins – 4.0.7
Soundboard Custom Post Types: by Gerda Gimpl – 5.05
Soundboard Meta Boxes: by Gerda Gimpl – 5.06
Soundboard Share Buttons: by Gerda Gimpl – 5.05
Soundboard Shortcodes: by Gerda Gimpl – 5.05
Soundboard Widgets: by Gerda Gimpl – 5.07
UpdraftPlus - Backup/Restore: by UpdraftPlus.Com
DavidAnderson – 1.16.47

WooCommerce Free Shipping Per Product: by WPRuby – 1.1.0
Australia Post WooCommerce Extension PRO: by WPRuby – 3.1.0
Product Alerts for WooCommerce: by Bolder Elements – 2.2
WooCommerce: by Automattic – 4.9.2
Wordfence Security: by Wordfence – 7.4.14
Hotlink Protection: by Hors Hipsrectors – 2017.08.13
Yoast SEO: by Team Yoast – 15.7
Mail Bank: by Tech Banker – 4.0.13
WP Hardening: by Astra Security – 1.2

### Inactive Plugins (5) ###

Advanced Editor Tools (previously TinyMCE Advanced): by Automattic – 5.6.0
Rearrange Woocommerce Products: by Aslam Doctor – 2.3.6
Secure Folder wp-content/uploads: by Daniel Satria a/n RuangLaba – 1.2
SoundCloud Shortcode: by SoundCloud Inc. – 3.0.2
W3 Total Cache: by BoldGrid – 2.1.0

### Must Use Plugins (1) ###

installatron_hide_status_test.php: by  –

### Settings ###

API Enabled: ✔
Force SSL: –
Currency: AUD ($)
Currency Position: left
Thousand Separator: ,
Decimal Separator: .
Number of Decimals: 2
Taxonomies: Product Types: external (external)
grouped (grouped)
pw gift card (pw-gift-card)
simple (simple)
variable (variable)

Taxonomies: Product Visibility: exclude-from-catalog (exclude-from-catalog)
exclude-from-catalog (exclude-from-catalog-2)
exclude-from-search (exclude-from-search)
featured (featured)
outofstock (outofstock)
outofstock (outofstock-2)
rated-1 (rated-1)
rated-1 (rated-1-2)
rated-2 (rated-2)
rated-2 (rated-2-2)
rated-3 (rated-3)
rated-3 (rated-3-2)
rated-4 (rated-4)
rated-4 (rated-4-2)
rated-5 (rated-5)
rated-5 (rated-5-2)

Connected to WooCommerce.com: ✔

### WC Pages ###

Shop base: #30 - /store/
Cart: #31 - /cart/
Checkout: #32 - /checkout/
My account: #33 - /my-account/
Terms and conditions: ❌ Page not set

### Theme ###

Name: Soundboard
Version: 5.07
Author URL: http://www.red-sun-design.com
Child Theme: ❌ – If you are modifying WooCommerce on a parent theme that you did not build personally we recommend using a child theme. See: How to create a child theme
WooCommerce Support: ✔

### Templates ###

Archive Template: Your theme has a woocommerce.php file
you will not be able to override the woocommerce/archive-product.php custom template since woocommerce.php has priority over archive-product.php. This is intended to prevent display issues.

Overrides: –

### Action Scheduler ###

Canceled: 1
Oldest: 2021-02-02 00:43:47 +0000
Newest: 2021-02-02 00:43:47 +0000

Complete: 47
Oldest: 2021-01-05 04:49:26 +0000
Newest: 2021-02-02 04:48:02 +0000

Plugin Support

Ena P (a11n)

(@drwpcom)

3 years, 1 month ago

Hi @ppoz4. Sorry that we missed your last response.

I can see from your system report that the wp_woocommerce_sessions table does exist. Is the empty cart problem still happening? If so, another thing to check is to make sure that your Cart, Checkout and My Account pages are not cached by any plugins on the site, nor from server caching.

Thread Starter

ppoz4

(@ppoz4)

3 years, 1 month ago

Hi Ena @drwpcom
Yea the empty cart issue continued even after deleting and reinstalling WooCommerce, and I read elsewhere that caching can cause the problem, checked everything and that wasn’t the case.
So after the frustration of not being able to find a fix or any support, I deleted WooCommerce from the site and installed WP EasyCart. Problem solved
Thanks for getting back to me though
Pete

This reply was modified 3 years, 1 month ago by ppoz4.

Viewing 7 replies - 1 through 7 (of 7 total)

The topic ‘Missing tables: wp_woocommerce_sessions’ is closed to new replies.