Session expiring when Woocommerce is enabled (problem with backend)

  • Resolved Jethro Burnett Thorburn

    (@happyhealthyhonesthuman)


    3 years, 4 months ago

    Good Day Woocommerce Support,

    I hope you are all well!

    I am encountering a rather confusing issue on my WordPress backend that I have spent the day trying to resolve, but alas, I have been unsuccessful, and so I come to you requesting your support and expertise.

    When Woocommerce is disabled I am able to log into my WordPress backend / dashboard and navigate to various sections and settings.

    However, when Woocommerce is activated I encounter a problem.

    I can log in, however, anytime I click a menu item in the Dashboard, the page attempts to load but then I am prompted to log in again and there is a message stating “Your session has expired. Please log in to continue where you left off.”

    Even if I log in, wait 3 seconds and then just refresh the Dashboard, I can see an the same error message and login box.

    So to resolve this issue, I have to go into FTP (CPanel) and rename the “plugins” folder in wp-content to something else (I usually use “plugins_OFF”); and doing this then deactivates all plugins.

    I am then able to log in, and then I can click as many menu items as I want and I am not logged out at all.

    However, if I then rename the plugins folder back to its original name “plugins” and then I activate ONLY Woocommerce, so that Woocommerce is the only plugin activated, I am able to navigate without any errors. However, if I manually log out, and then log into the backend again, I log in successfully to the dashboard but from there I have the same issue where I am logged out any time I try to load a new page in the backend or refresh the page.

    The frontend of the website functions without any errors.

    I have tried troubleshooting some of the common solutions for the “WordPress keeps logging me out” problem. However, it seems to me that it is the Woocommerce plugin specifically that is causing the issue.

    I have tried the following:

    I’ve tried clearing my browser cache and cookies, and that doesn’t work.

    I’ve made sure cookies are enabled and I’ve tried different web browsers (Chrome and Edge).

    I’ve tried clearing

    My IP seems to be stable.

    I’ve cleared all the caching through my caching plugin WPRocket and disabled the plugin, I’ve checked the LiteSpeed cache and it is empty (which is fine, since I’m using a plugin for that).

    My WordPress site URL and permalink settings seem to be in order.`

    Any idea what might be causing this?

    Thank you kindly for your support.

    Best regards,
    Jethro

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

Viewing 9 replies - 1 through 9 (of 9 total)
  • Mirko P.

    (@rainfallnixfig)

    Hi Jethro @happyhealthyhonesthuman,

    As you stated that with only core WooCommerce plugin active you can log in and navigate without errors it sounds like there may be another plugin that, when active, is conflicting with WooCommerce causing the session to expire.

    I’d advice performing a conflict test:

    • Temporarily switch your theme to Storefront
    • Disable all plugins except for WooCommerce
    • Repeat the action that is causing the problem

      • If you’re not seeing the same problem after completing the conflict test, then you know the problem was with the plugins and/or theme you deactivated.

      To figure out which plugin is causing the problem, reactivate your other plugins one by one, testing after each, until you find the one causing conflict.

      You can find a more detailed explanation on how to do a conflict test here.

      When you find the plugin causing the conflict you may want to reach out to the plugin authors and let them check this.

      Thanks!

    Thread Starter Jethro Burnett Thorburn

    (@happyhealthyhonesthuman)

    Hi Mirko,

    Thank you kindly for your reply.

    You see the problem is not that I can’t log in. I can log in. The problem is that my session expires almost immediately once I log in while Woocommerce is active. Anytime I click a menu item from the Dashboard or refresh the Dashboard, I am prompted to log in again and there is a message stating “Your session has expired. Please log in to continue where you left off.”

    Perhaps this screenshot can assist: https://imgur.com/a/bbYQvoR

    I am not sure whether the errors are related?

    So basically all I can do is log into the Dashboard, but then after that I cannot do anything more, because WordPress keeps logging me out automatically.

    This means I cannot even deactivate Woocommerce from the Dashboard, because even if I log into the Dashboard and try click the “plugins” section so that I can deactivate the plugin, I cannot, because the session expires and it asks me to log in again.

    That is why I have to rename the plugins folder in FTP (wp-content/plugins) to something different, log in, rename the plugins folder back to its original name (“plugins”), and then go to the plugins section in the Dashboard and activate Woocommerce. Then I can navigate for this session only. If I then log out, and log back in again (with ONLY Woocommerce active, and a default theme), I experience the same issue where I keep getting logged out.

    So to me, this shows, that there is some problem, that when I log in with Woocommerce active, it is causing the session to expire repeatedly within seconds, and I can’t accomplish anything.`

    I have a strong suspicion that something related to Woocommerce is causing my session in the WordPress backend to expire (and hence I am automatically logged out) and asked to log in again over and over again. This happens after only a second or two after logging in, so I can’t do anything.

    To reiterate, I have ONLY the Woocommerce plugin active (no other plugins active) and this problem occurs. This is while I am using a Default theme as well.

    Unfortunately I don’t have the technical knowledge on Woocommerce to know how to go further with this problem.

    Thank you for your support Mirko.

    Mirko P.

    (@rainfallnixfig)

    Hi again,

    Thanks for the additional details.

    It sounds this is something associated with cookies. In fact, every time you log into WordPress a browser cookie is set which is intended for authenticating your session.

    If there are any errors with the cookie WordPress will see your session as unauthenticated and will automatically log you out while showing you the “session expired” notice.

    As a next step, I would suggest checking carefully all resolution methods for WordPress session expired issue mentioned here:

    https://www.navthemes.com/wordpress-session-expired-problem/

    Let us know how that goes.

    Thread Starter Jethro Burnett Thorburn

    (@happyhealthyhonesthuman)

    Hi Mirko,

    Thanks for the suggestion. I did come across that article prior to contacting Woocommerce.

    I have tried all the suggested solution and none of them work unfortunately.

    Step 1 -Clear browser cache and cookies
    I have done this on Chrome, Edge, and I downloaded a fresh install of Opera and tried that and my session still expires immediately.

    Step 2 – Make sure that you are permitting WordPress to save cookies
    This is in order

    Step 3 – Clear cache
    Done, cleared server cache, and I have had my caching plugin disabled throughout the troubleshooting process (I also checked in FTP and there are no cache files associated with the plugin either).

    Step 4 – Disable plugins
    I did this and once again when Woocommerce is the only plugin active this error occurs

    Step 5 – Extend the time you are remembered on the site
    Added that code to functions.php in my child theme, didn’t work

    Step 6 – Check your WordPress site settings
    I’ve done this and also edited wp-config to make sure Site address and WordPress URL match and are correct

    Now I wonder if this is not a clue:

    As I previously mentioned, If I rename the Woocommerce plugin folder in order to deactivate it, and then I log into WordPress and then I rename the Woocommerce plugin back to “Woocommerce” and then activate it in the Plugins tab of the WordPress Dashboard plugins section, then I am not logged out and my session doesn’t expire.

    HOWEVER, when Woocommerce is active at the time of logging in, then my session keeps expiring immediately. The weird thing to say once again, is that the log in DOES NOT FAIL. It just expires immediately thereafter. Surely this is also a clue.

    This to me shows that there is something at the step WHEN I LOG IN, that if Woocommerce is active it causes a problem. It makes sense to me why the cookies may be the problem then, since they are set at the log in step.

    I wonder if there is no way to look deeper at the cookies and specifically the ones related to Woocommerce AT LOGIN that may be entering invalid values or something that would cause authentication to fail? For example, the session expiry date and time is set to 1 second from the session created time?

    I looked in my browser to check which cookies were being created in the browser when logged in and logged out, however, it does not seem to make a difference whether Woocommerce is active or not. Please see below images to see the cookies:

    Cookies on Website

    When logged in session expiry dates are all future dates or when browsing session expires (Note: This is the same values regardless of whether Woocommerce is active or not)

    When logged out (either manually when Woocommerce is deactivated, or when I am forced out when Woocommerce is active) I refresh the page and check cookie values once again. They are different to when logged in however the values are the same regardless of whether Woocommerce is active or not).

    Mirko P.

    (@rainfallnixfig)

    Hi again,

    Thanks for performing tests and trying to troubleshoot this.

    Do you see any Error Logs under WooCommerce → Status → Logs? You should be able to display that page once you’re logged in by renaming to the original woocommerce folder under wp-content/plugins and pasting https://plantshopafrica.co.za/wp-admin/admin.php?page=wc-status&tab=logs in the browser.

    Does the same happen using the browser’s Incognito mode? It would be helpful if you could share your System Status. You should get it to display at this URL:

    https://plantshopafrica.co.za/wp-admin/admin.php?page=wc-status&tab=status

    Select “Get system report” and then “Copy for support”. Once you’ve done that, paste it here in your response.

    Cheers.

    • This reply was modified 3 years, 4 months ago by Mirko P..
    Thread Starter Jethro Burnett Thorburn

    (@happyhealthyhonesthuman)

    Hi Mirko,

    Here is what I found in Woocommerce Status Logs:

    2021-07-11T17:21:21+00:00 CRITICAL Uncaught RuntimeException: Error saving action: Error saving action: Database error. in /home/plantsho/public_html/wp-content/plugins/woocommerce/packages/action-scheduler/classes/migration/ActionScheduler_DBStoreMigrator.php:44
Stack trace:
#0 /home/plantsho/public_html/wp-content/plugins/woocommerce/packages/action-scheduler/classes/data-stores/ActionScheduler_HybridStore.php(242): ActionScheduler_DBStoreMigrator->save_action(Object(ActionScheduler_Action), NULL)
#1 /home/plantsho/public_html/wp-content/plugins/woocommerce/packages/action-scheduler/classes/ActionScheduler_ActionFactory.php(177): ActionScheduler_HybridStore->save_action(Object(ActionScheduler_Action))
#2 /home/plantsho/public_html/wp-content/plugins/woocommerce/packages/action-scheduler/classes/ActionScheduler_ActionFactory.php(84): ActionScheduler_ActionFactory->store(Object(ActionScheduler_Action))
#3 /home/plantsho/public_html/wp-content/plugins/woocommerce/packages/action-scheduler/functions.php(36): ActionScheduler_ActionFactory->single in /home/plantsho/public_html/wp-content/plugins/woocommerce/packages/action-scheduler/classes/migration/ActionScheduler_DBStoreMigrator.php on line 44

2021-07-11T17:21:21+00:00 CRITICAL Uncaught RuntimeException: Error saving action: Error saving action: Database error. in /home/plantsho/public_html/wp-content/plugins/woocommerce/packages/action-scheduler/classes/migration/ActionScheduler_DBStoreMigrator.php:44
Stack trace:
#0 /home/plantsho/public_html/wp-content/plugins/woocommerce/packages/action-scheduler/classes/data-stores/ActionScheduler_HybridStore.php(242): ActionScheduler_DBStoreMigrator->save_action(Object(ActionScheduler_Action), NULL)
#1 /home/plantsho/public_html/wp-content/plugins/woocommerce/packages/action-scheduler/classes/ActionScheduler_ActionFactory.php(177): ActionScheduler_HybridStore->save_action(Object(ActionScheduler_Action))
#2 /home/plantsho/public_html/wp-content/plugins/woocommerce/packages/action-scheduler/classes/ActionScheduler_ActionFactory.php(84): ActionScheduler_ActionFactory->store(Object(ActionScheduler_Action))
#3 /home/plantsho/public_html/wp-content/plugins/woocommerce/packages/action-scheduler/functions.php(36): ActionScheduler_ActionFactory->single in /home/plantsho/public_html/wp-content/plugins/woocommerce/packages/action-scheduler/classes/migration/ActionScheduler_DBStoreMigrator.php on line 44

2021-07-11T17:22:13+00:00 CRITICAL Uncaught RuntimeException: Error saving action: Error saving action: Database error. in /home/plantsho/public_html/wp-content/plugins/woocommerce/packages/action-scheduler/classes/migration/ActionScheduler_DBStoreMigrator.php:44
Stack trace:
#0 /home/plantsho/public_html/wp-content/plugins/woocommerce/packages/action-scheduler/classes/data-stores/ActionScheduler_HybridStore.php(242): ActionScheduler_DBStoreMigrator->save_action(Object(ActionScheduler_Action), NULL)
#1 /home/plantsho/public_html/wp-content/plugins/woocommerce/packages/action-scheduler/classes/ActionScheduler_ActionFactory.php(177): ActionScheduler_HybridStore->save_action(Object(ActionScheduler_Action))
#2 /home/plantsho/public_html/wp-content/plugins/woocommerce/packages/action-scheduler/classes/ActionScheduler_ActionFactory.php(84): ActionScheduler_ActionFactory->store(Object(ActionScheduler_Action))
#3 /home/plantsho/public_html/wp-content/plugins/woocommerce/packages/action-scheduler/functions.php(36): ActionScheduler_ActionFactory->single in /home/plantsho/public_html/wp-content/plugins/woocommerce/packages/action-scheduler/classes/migration/ActionScheduler_DBStoreMigrator.php on line 44

2021-07-11T17:24:15+00:00 CRITICAL Uncaught RuntimeException: Error saving action: Error saving action: Database error. in /home/plantsho/public_html/wp-content/plugins/woocommerce/packages/action-scheduler/classes/migration/ActionScheduler_DBStoreMigrator.php:44
Stack trace:
#0 /home/plantsho/public_html/wp-content/plugins/woocommerce/packages/action-scheduler/classes/data-stores/ActionScheduler_HybridStore.php(242): ActionScheduler_DBStoreMigrator->save_action(Object(ActionScheduler_Action), NULL)
#1 /home/plantsho/public_html/wp-content/plugins/woocommerce/packages/action-scheduler/classes/ActionScheduler_ActionFactory.php(177): ActionScheduler_HybridStore->save_action(Object(ActionScheduler_Action))
#2 /home/plantsho/public_html/wp-content/plugins/woocommerce/packages/action-scheduler/classes/ActionScheduler_ActionFactory.php(84): ActionScheduler_ActionFactory->store(Object(ActionScheduler_Action))
#3 /home/plantsho/public_html/wp-content/plugins/woocommerce/packages/action-scheduler/functions.php(36): ActionScheduler_ActionFactory->single in /home/plantsho/public_html/wp-content/plugins/woocommerce/packages/action-scheduler/classes/migration/ActionScheduler_DBStoreMigrator.php on line 44

2021-07-11T17:24:15+00:00 CRITICAL Uncaught RuntimeException: Error saving action: Error saving action: Database error. in /home/plantsho/public_html/wp-content/plugins/woocommerce/packages/action-scheduler/classes/migration/ActionScheduler_DBStoreMigrator.php:44
Stack trace:
#0 /home/plantsho/public_html/wp-content/plugins/woocommerce/packages/action-scheduler/classes/data-stores/ActionScheduler_HybridStore.php(242): ActionScheduler_DBStoreMigrator->save_action(Object(ActionScheduler_Action), NULL)
#1 /home/plantsho/public_html/wp-content/plugins/woocommerce/packages/action-scheduler/classes/ActionScheduler_ActionFactory.php(177): ActionScheduler_HybridStore->save_action(Object(ActionScheduler_Action))
#2 /home/plantsho/public_html/wp-content/plugins/woocommerce/packages/action-scheduler/classes/ActionScheduler_ActionFactory.php(84): ActionScheduler_ActionFactory->store(Object(ActionScheduler_Action))
#3 /home/plantsho/public_html/wp-content/plugins/woocommerce/packages/action-scheduler/functions.php(36): ActionScheduler_ActionFactory->single in /home/plantsho/public_html/wp-content/plugins/woocommerce/packages/action-scheduler/classes/migration/ActionScheduler_DBStoreMigrator.php on line 44

2021-07-11T17:25:55+00:00 CRITICAL Uncaught RuntimeException: Error saving action: Error saving action: Database error. in /home/plantsho/public_html/wp-content/plugins/woocommerce/packages/action-scheduler/classes/migration/ActionScheduler_DBStoreMigrator.php:44
Stack trace:
#0 /home/plantsho/public_html/wp-content/plugins/woocommerce/packages/action-scheduler/classes/data-stores/ActionScheduler_HybridStore.php(242): ActionScheduler_DBStoreMigrator->save_action(Object(ActionScheduler_Action), NULL)
#1 /home/plantsho/public_html/wp-content/plugins/woocommerce/packages/action-scheduler/classes/ActionScheduler_ActionFactory.php(177): ActionScheduler_HybridStore->save_action(Object(ActionScheduler_Action))
#2 /home/plantsho/public_html/wp-content/plugins/woocommerce/packages/action-scheduler/classes/ActionScheduler_ActionFactory.php(84): ActionScheduler_ActionFactory->store(Object(ActionScheduler_Action))
#3 /home/plantsho/public_html/wp-content/plugins/woocommerce/packages/action-scheduler/functions.php(36): ActionScheduler_ActionFactory->single in /home/plantsho/public_html/wp-content/plugins/woocommerce/packages/action-scheduler/classes/migration/ActionScheduler_DBStoreMigrator.php on line 44

2021-07-11T17:26:16+00:00 CRITICAL Uncaught RuntimeException: Error saving action: Error saving action: Database error. in /home/plantsho/public_html/wp-content/plugins/woocommerce/packages/action-scheduler/classes/migration/ActionScheduler_DBStoreMigrator.php:44
Stack trace:
#0 /home/plantsho/public_html/wp-content/plugins/woocommerce/packages/action-scheduler/classes/data-stores/ActionScheduler_HybridStore.php(242): ActionScheduler_DBStoreMigrator->save_action(Object(ActionScheduler_Action), NULL)
#1 /home/plantsho/public_html/wp-content/plugins/woocommerce/packages/action-scheduler/classes/ActionScheduler_ActionFactory.php(177): ActionScheduler_HybridStore->save_action(Object(ActionScheduler_Action))
#2 /home/plantsho/public_html/wp-content/plugins/woocommerce/packages/action-scheduler/classes/ActionScheduler_ActionFactory.php(84): ActionScheduler_ActionFactory->store(Object(ActionScheduler_Action))
#3 /home/plantsho/public_html/wp-content/plugins/woocommerce/packages/action-scheduler/functions.php(36): ActionScheduler_ActionFactory->single in /home/plantsho/public_html/wp-content/plugins/woocommerce/packages/action-scheduler/classes/migration/ActionScheduler_DBStoreMigrator.php on line 44

2021-07-11T17:26:16+00:00 CRITICAL Uncaught RuntimeException: Error saving action: Error saving action: Database error. in /home/plantsho/public_html/wp-content/plugins/woocommerce/packages/action-scheduler/classes/migration/ActionScheduler_DBStoreMigrator.php:44
Stack trace:
#0 /home/plantsho/public_html/wp-content/plugins/woocommerce/packages/action-scheduler/classes/data-stores/ActionScheduler_HybridStore.php(242): ActionScheduler_DBStoreMigrator->save_action(Object(ActionScheduler_Action), NULL)
#1 /home/plantsho/public_html/wp-content/plugins/woocommerce/packages/action-scheduler/classes/ActionScheduler_ActionFactory.php(177): ActionScheduler_HybridStore->save_action(Object(ActionScheduler_Action))
#2 /home/plantsho/public_html/wp-content/plugins/woocommerce/packages/action-scheduler/classes/ActionScheduler_ActionFactory.php(84): ActionScheduler_ActionFactory->store(Object(ActionScheduler_Action))
#3 /home/plantsho/public_html/wp-content/plugins/woocommerce/packages/action-scheduler/functions.php(36): ActionScheduler_ActionFactory->single in /home/plantsho/public_html/wp-content/plugins/woocommerce/packages/action-scheduler/classes/migration/ActionScheduler_DBStoreMigrator.php on line 44

2021-07-11T17:42:22+00:00 CRITICAL Uncaught Error: Class 'ActionScheduler_StoreSchema' not found in /home/plantsho/public_html/wp-content/plugins/action-scheduler_OFF/classes/data-stores/ActionScheduler_DBStore.php:34
Stack trace:
#0 /home/plantsho/public_html/wp-includes/class-wp-hook.php(290): ActionScheduler_DBStore->init()
#1 /home/plantsho/public_html/wp-includes/class-wp-hook.php(316): WP_Hook->apply_filters(NULL, Array)
#2 /home/plantsho/public_html/wp-includes/plugin.php(484): WP_Hook->do_action(Array)
#3 /home/plantsho/public_html/wp-settings.php(560): do_action('init')
#4 /home/plantsho/public_html/wp-config.php(81): require_once('/home/plantsho/...')
#5 /home/plantsho/public_html/wp-load.php(37): require_once('/home/plantsho/...')
#6 /home/plantsho/public_html/wp-cron.php(44): require_once('/home/plantsho/...')
#7 {main}
  thrown in /home/plantsho/public_html/wp-content/plugins/action-scheduler_OFF/classes/data-stores/ActionScheduler_DBStore.php on line 34

    AND HERE IS THE SYSTEM REPORT:

    
### WordPress Environment ###

WordPress address (URL): https://plantshopafrica.co.za
Site address (URL): https://plantshopafrica.co.za
WC Version: 5.4.1
REST API Version: ? 5.4.1
WC Blocks Version: ? 5.1.0
Action Scheduler Version: ? 3.2.1
WC Admin Version: ? 2.4.1
Log Directory Writable: ?
WP Version: 5.7.2
WP Multisite: –
WP Memory Limit: 2 GB
WP Debug Mode: –
WP Cron: ?
Language: en_GB
External object cache: –

### Server Environment ###

Server Info: LiteSpeed
PHP Version: 7.4.20
PHP Post Max Size: 2 GB
PHP Time Limit: 300
PHP Max Input Vars: 10000
cURL Version: 7.71.0
OpenSSL/1.1.1d

SUHOSIN Installed: –
MySQL Version: 5.5.5-10.3.30-MariaDB
Max Upload Size: 1 GB
Default Timezone is UTC: ?
fsockopen/cURL: ?
SoapClient: ?
DOMDocument: ?
GZip: ?
Multibyte String: ?
Remote Post: ?
Remote Get: ?

### Database ###

WC Database Version: 5.4.1
WC Database Prefix: _FS6_
Total Database Size: 23.91MB
Database Data Size: 23.76MB
Database Index Size: 0.15MB
_FS6_woocommerce_sessions: Data: 0.01MB + Index: 0.00MB + Engine MyISAM
_FS6_woocommerce_api_keys: Data: 0.00MB + Index: 0.01MB + Engine MyISAM
_FS6_woocommerce_attribute_taxonomies: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
_FS6_woocommerce_downloadable_product_permissions: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
_FS6_woocommerce_order_items: Data: 0.02MB + Index: 0.01MB + Engine MyISAM
_FS6_woocommerce_order_itemmeta: Data: 0.05MB + Index: 0.03MB + Engine MyISAM
_FS6_woocommerce_tax_rates: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
_FS6_woocommerce_tax_rate_locations: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
_FS6_woocommerce_shipping_zones: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
_FS6_woocommerce_shipping_zone_locations: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
_FS6_woocommerce_shipping_zone_methods: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
_FS6_woocommerce_payment_tokens: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
_FS6_woocommerce_payment_tokenmeta: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
_FS6_woocommerce_log: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
_FS6_actionscheduler_actions: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
_FS6_actionscheduler_claims: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
_FS6_actionscheduler_groups: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
_FS6_actionscheduler_logs: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
_FS6_adtribes_my_conversions: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
_FS6_atum_order_itemmeta: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
_FS6_atum_order_items: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
_FS6_atum_product_data: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
_FS6_bp_activity: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
_FS6_bp_activity_meta: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
_FS6_bp_notifications: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
_FS6_bp_notifications_meta: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
_FS6_bp_xprofile_data: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
_FS6_bp_xprofile_fields: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
_FS6_bp_xprofile_groups: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
_FS6_bp_xprofile_meta: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
_FS6_cf_forms: Data: 0.13MB + Index: 0.00MB + Engine MyISAM
_FS6_cf_form_entries: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
_FS6_cf_form_entry_meta: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
_FS6_cf_form_entry_values: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
_FS6_cf_pro_messages: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
_FS6_cf_tracking: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
_FS6_cf_tracking_meta: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
_FS6_chaty_contact_form_leads: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
_FS6_commentmeta: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
_FS6_comments: Data: 0.02MB + Index: 0.00MB + Engine MyISAM
_FS6_em_bookings: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
_FS6_em_events: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
_FS6_em_locations: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
_FS6_em_meta: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
_FS6_em_tickets: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
_FS6_em_tickets_bookings: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
_FS6_e_submissions: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
_FS6_e_submissions_actions_log: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
_FS6_e_submissions_values: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
_FS6_failed_jobs: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
_FS6_grp_google_place: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
_FS6_grp_google_review: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
_FS6_links: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
_FS6_mailchimp_carts: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
_FS6_mailchimp_jobs: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
_FS6_mclean_refs: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
_FS6_mclean_scan: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
_FS6_mgmlp_folders: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
_FS6_options: Data: 2.91MB + Index: 0.00MB + Engine MyISAM
_FS6_pmxe_exports: Data: 0.01MB + Index: 0.00MB + Engine MyISAM
_FS6_pmxe_google_cats: Data: 0.26MB + Index: 0.00MB + Engine MyISAM
_FS6_pmxe_posts: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
_FS6_pmxe_templates: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
_FS6_postmeta: Data: 7.28MB + Index: 0.00MB + Engine MyISAM
_FS6_posts: Data: 4.45MB + Index: 0.00MB + Engine MyISAM
_FS6_queue: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
_FS6_rank_math_404_logs: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
_FS6_rank_math_analytics_gsc: Data: 0.17MB + Index: 0.00MB + Engine InnoDB
_FS6_rank_math_analytics_objects: Data: 0.08MB + Index: 0.00MB + Engine InnoDB
_FS6_rank_math_internal_links: Data: 0.04MB + Index: 0.00MB + Engine MyISAM
_FS6_rank_math_internal_meta: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
_FS6_rank_math_redirections: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
_FS6_rank_math_redirections_cache: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
_FS6_shopmagic_automation_outcome: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
_FS6_shopmagic_automation_outcome_logs: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
_FS6_shopmagic_cart: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
_FS6_shopmagic_guest: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
_FS6_shopmagic_guest_meta: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
_FS6_shopmagic_optin_email: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
_FS6_signups: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
_FS6_subscribe_reloaded_subscribers: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
_FS6_termmeta: Data: 0.02MB + Index: 0.00MB + Engine MyISAM
_FS6_terms: Data: 0.01MB + Index: 0.00MB + Engine MyISAM
_FS6_term_relationships: Data: 0.02MB + Index: 0.00MB + Engine MyISAM
_FS6_term_taxonomy: Data: 0.01MB + Index: 0.00MB + Engine MyISAM
_FS6_tm_taskmeta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
_FS6_tm_tasks: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
_FS6_toolset_post_guid_id: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
_FS6_usermeta: Data: 0.03MB + Index: 0.00MB + Engine MyISAM
_FS6_users: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
_FS6_user_registration_sessions: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
_FS6_wcpdf_invoice_number: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
_FS6_wc_admin_notes: Data: 0.08MB + Index: 0.00MB + Engine MyISAM
_FS6_wc_admin_note_actions: Data: 0.01MB + Index: 0.00MB + Engine MyISAM
_FS6_wc_category_lookup: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
_FS6_wc_customer_lookup: Data: 0.00MB + Index: 0.01MB + Engine MyISAM
_FS6_wc_download_log: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
_FS6_wc_order_coupon_lookup: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
_FS6_wc_order_product_lookup: Data: 0.01MB + Index: 0.01MB + Engine MyISAM
_FS6_wc_order_stats: Data: 0.00MB + Index: 0.01MB + Engine MyISAM
_FS6_wc_order_tax_lookup: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
_FS6_wc_product_meta_lookup: Data: 0.00MB + Index: 0.01MB + Engine MyISAM
_FS6_wc_reserved_stock: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
_FS6_wc_tax_rate_classes: Data: 0.00MB + Index: 0.01MB + Engine MyISAM
_FS6_wc_webhooks: Data: 0.01MB + Index: 0.00MB + Engine MyISAM
_FS6_wdp_orders: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
_FS6_wdp_order_items: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
_FS6_wdp_rules: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
_FS6_wf301_404_logs: Data: 0.41MB + Index: 0.00MB + Engine MyISAM
_FS6_wf301_redirect_logs: Data: 0.02MB + Index: 0.00MB + Engine MyISAM
_FS6_wf301_redirect_rules: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
_FS6_wfblockediplog: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
_FS6_wfblocks7: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
_FS6_wfconfig: Data: 0.44MB + Index: 0.00MB + Engine MyISAM
_FS6_wfcrawlers: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
_FS6_wffilechanges: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
_FS6_wffilemods: Data: 4.11MB + Index: 0.00MB + Engine MyISAM
_FS6_wfhits: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
_FS6_wfhoover: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
_FS6_wfissues: Data: 0.02MB + Index: 0.00MB + Engine MyISAM
_FS6_wfknownfilelist: Data: 2.20MB + Index: 0.00MB + Engine MyISAM
_FS6_wflivetraffichuman: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
_FS6_wflocs: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
_FS6_wflogins: Data: 0.14MB + Index: 0.00MB + Engine MyISAM
_FS6_wfls_2fa_secrets: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
_FS6_wfls_settings: Data: 0.06MB + Index: 0.00MB + Engine InnoDB
_FS6_wfnotifications: Data: 0.01MB + Index: 0.00MB + Engine MyISAM
_FS6_wfpendingissues: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
_FS6_wfreversecache: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
_FS6_wfsnipcache: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
_FS6_wfstatus: Data: 0.07MB + Index: 0.00MB + Engine MyISAM
_FS6_wftrafficrates: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
_FS6_woo_shippment_provider: Data: 0.09MB + Index: 0.00MB + Engine MyISAM
_FS6_word_replacer: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
_FS6_wpgmza: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
_FS6_wpgmza_categories: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
_FS6_wpml_mails: Data: 0.16MB + Index: 0.00MB + Engine InnoDB

### Post Type Counts ###

amn_wpforms-lite: 1
attachment: 605
bnfw_notification: 2
bp-email: 30
cartflows_flow: 2
cartflows_step: 4
custom_css: 2
dc_commission: 74
elementor_library: 21
elementor-popup: 2
event: 1
jetpack_migration: 2
jp_img_sitemap: 1
jp_sitemap: 1
jp_sitemap_master: 1
location: 1
mgmlp_media_folder: 75
nav_menu_item: 25
oceanwp_library: 2
oembed_cache: 13
page: 18
post: 23
postman_sent_mail: 250
product: 37
shop_coupon: 27
shop_order: 53
shopmagic_automation: 1
tribe_events: 1
tribe_organizer: 3
tribe_venue: 2
um_directory: 1
um_form: 3
user_registration: 1
wcmp_transaction: 21
wcmp_university: 3
wcmp_vendor_notice: 1
wcps: 2
wcps_layout: 2
wof_lite_wheel: 1
wp_block: 2
wp-types-group: 1
wpforms: 3
wpuf_contact_form: 1
wpuf_input: 3

### Security ###

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

### Active Plugins (5) ###

Action Scheduler: by Automattic – 3.2.1
Elementor Pro: by Elementor.com – 3.3.1
Elementor: by Elementor.com – 3.2.5
WooCommerce Admin: by WooCommerce – 2.4.1
WooCommerce: by Automattic – 5.4.1

### Inactive Plugins (7) ###

Google Tag Manager for WordPress: by Thomas Geiger – 1.13
Preview E-mails for WooCommerce: by Digamber Pradhan – 1.6.8
UpdraftPlus - Backup/Restore: by UpdraftPlus.Com
DavidAnderson – 1.16.56

WooCommerce Ozow Gateway: by <a href="https://Ozow.com" />Ozow</a> – 1.0.0.0
WooCommerce PayFast Gateway: by WooCommerce – 1.4.19
WooCommerce PDF Invoices & Packing Slips: by Ewout Fernhout – 2.8.3
WP-Optimize - Clean, Compress, Cache: by David Anderson
Ruhani Rabin
Team Updraft – 3.1.11

### Dropin Plugins (2) ###

advanced-cache.php: advanced-cache.php
maintenance.php: maintenance.php

### Must Use Plugins (3) ###

Endurance Page Cache: by Mike Hansen – 2.0.7
SSO: by Garth Mortensen
Mike Hansen – 0.3

wp-hide-loader.php: by  –

### Settings ###

API Enabled: ?
Force SSL: –
Currency: ZAR (R)
Currency Position: left
Thousand Separator: ,
Decimal Separator: .
Number of Decimals: 2
Taxonomies: Product Types: external (external)
grouped (grouped)
simple (simple)
variable (variable)

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

Connected to WooCommerce.com: –

### WC Pages ###

Shop base: #4396 - /shop/
Basket: #2383 - /basket/
Checkout: #2384 - /checkout/
My account: #2385 - /my-account/
Terms and conditions: #4835 - /terms/

### Theme ###

Name: OceanWP Child
Version: 1.0
Author URL: https://oceanwp.org/
Child Theme: ?
Parent Theme Name: OceanWP
Parent Theme Version: 2.0.8 – 2.1.1 is available
Parent Theme Author URL: https://oceanwp.org/about-me/
WooCommerce Support: ?

### Templates ###

Overrides: oceanwp/woocommerce/cart/mini-cart.php
oceanwp/woocommerce/content-single-product.php
oceanwp-child-theme-master/woocommerce/emails/customer-new-account.php
oceanwp-child-theme-master/woocommerce/emails/customer-processing-order.php
oceanwp-child-theme-master/woocommerce/emails/email-header.php
oceanwp-child-theme-master/woocommerce/emails/email-styles.php version 3.3.0 is out of date. The core version is 4.0.0
oceanwp/woocommerce/loop/loop-start.php
oceanwp/woocommerce/single-product/title.php

Outdated Templates: ?
					
					
						Learn how to update

### Action Scheduler ###

### Status report information ###

Generated at: 2021-07-11 20:11:11 +02:00
    Mirko P.

    (@rainfallnixfig)

    Hi again,

    Thanks for providing the logs and your System Status.

    At this point, after checking the logs, it seems that WooCommerce is unable to store session data in the database. This could be due to several reasons including a corrupted database.

    I’ve found what sounds like a similar case on this page:

    https://clicknathan.com/web-design/woocommerce-actionscheduler-table-error/

    Please read through and see if there is something to be fixed in the database that could lead to the resolution of this isse.

    You could also disable Action Scheduler with this plugin https://docs.woocommerce.com/document/subscriptions/disabling-subscriptions/#:~:text=In%20order%20to%20completely%20stop,using%20Action%20Scheduler%20will%20stop and see if it makes any difference.

    Cheers.

    Thread Starter Jethro Burnett Thorburn

    (@happyhealthyhonesthuman)

    Hi everyone,

    Just an update on the problem I was experiencing where WordPress kept logging me out of Wp-admin dashboard when Woocommerce plugin was enabled.

    It turns out the problem wasn’t with Woocommerce but that there were some tables in the database which where not structured properly. I suspect this happened when we copied the database over from healthwithjet.com to plantshopafrica.co.za. In some of the tables there was not a Primary Key set and it was not set to Auto Increment.

    This meant that entries were being made into the tables with an ID of 0, because Auto Increment and Primary Key were not set on the tables.

    I had some problems with the action_scheduler tables.

    I also had a problem with the wp_usermeta table, where it was unable to put a value in the table properly because the metaID was being set to 0. I think this may have been the exact table that was causing me to be logged out because Woocommerce was trying to write something into the table but the Primary Key and Auto Incrament were not set, so it was logging me out.

    I manually deleted all the entries in the various tables in the database that had table entries with IDs of 0 using a MySQL query for each table. I then manually added the Primary Key and set it to Auto Increment for the tables.

    This resolved my problem.

    I can work in wp-admin again while Woocommerce is activated with no problems at all.

    What a great success!

    Best regards,
    Jethro

    Mirko P.

    (@rainfallnixfig)

    Hey Jethro @happyhealthyhonesthuman,

    I’m very happy to know that you’ve come up with a solution here.

    I had a bit of a clue of something not properly functioning in the database. I’m now going to mark this as resolved. Feel free to start a new thread if you have any more questions!

    Cheers.

Viewing 9 replies - 1 through 9 (of 9 total)
  • The topic ‘Session expiring when Woocommerce is enabled (problem with backend)’ is closed to new replies.