zgall1

What would be the next steps to troubleshoot this?

Of course.

User Roles are defaults.

Roles are set to Required

The login page is the default page.

@wfphil Are you able to help with my follow up question?

When 2FA is set to Required for a role, does Wordfence prompt the user to turn on 2FA at the log in screen or do they have to go to the 2FA setup page in Wordfence on their own?

This is what I got.

chem_ecol.wp_811489daf7_options
error : Can’t create new tempfile: ‘./chem_ecol/wp_811489daf7_options.TMD’
status : Operation failed

Can I restore only that table or do I need to restore the entire database?

The options table is 0B when viewed through PHPMyAdmin.

This is what I see when I run mysqlcheck.

chem_ecol.wp_811489daf7_options
warning  : Table is marked as crashed and last repair failed
warning  : 1 client is using or hasn't closed the table properly
error    : Record at pos: 906060 is not remove-marked
error    : record delete-link-chain corrupted
error    : Corrupt

When I run that command, I get these results.

Filesystem Size Used Avail Use% Mounted on
/dev/vda1 155G 138G 18G 89% /

I am hosting the site. There is still significant space on the server and no other sites on the same server are experiencing any issues.

It did! However, there is another related problem that I just noticed.

Each of these custom posts has a set of associated category pages.

Example

• Adele – https://theninesfashion.com/celebrity-outfits-style/adele/shoes/

• Adele Shoes – https://theninesfashion.com/celebrity-outfits-style/adele/shoes/
• Adele Dress – https://theninesfashion.com/celebrity-outfits-style/adele/dress/

The canonical URL for the category page is incorrectly set to the URL of the custom post instead of the category page itself. Would you know how to fix that?

• This reply was modified 2 years, 10 months ago by zgall1.

When I add flat rate shipping, I can see options for local pickup and flat rate shipping.

I originally said that I added flat rate shipping without any change but I then realized that I did not test it properly. Stand by.

### WordPress Environment ###

WordPress address (URL): https://expressyourselfspeech.ca/staging
Site address (URL): https://expressyourselfspeech.ca/staging
WC Version: 6.3.1
REST API Version: ? 6.3.1
WC Blocks Version: ? 6.9.0
Action Scheduler Version: ? 3.4.0
WC Admin Version: ? 3.2.1
Log Directory Writable: ?
WP Version: 5.9.2
WP Multisite: –
WP Memory Limit: 256 MB
WP Debug Mode: –
WP Cron: ?
Language: en_US
External object cache: –

### Server Environment ###

Server Info: Apache
PHP Version: 8.0.10
PHP Post Max Size: 8 MB
PHP Time Limit: 180
PHP Max Input Vars: 1000
cURL Version: 7.68.0
OpenSSL/1.1.1f

SUHOSIN Installed: –
MySQL Version: 8.0.28-0ubuntu0.20.04.3
Max Upload Size: 2 MB
Default Timezone is UTC: ?
fsockopen/cURL: ?
SoapClient: ? Your server does not have the SoapClient class enabled - some gateway plugins which use SOAP may not work as expected.
DOMDocument: ?
GZip: ?
Multibyte String: ?
Remote Post: ?
Remote Get: ?

### Database ###

WC Database Version: 6.3.1
WC Database Prefix: wpstg0_
Total Database Size: 28.44MB
Database Data Size: 23.34MB
Database Index Size: 5.10MB
wpstg0_woocommerce_sessions: Data: 2.02MB + Index: 0.05MB + Engine InnoDB
wpstg0_woocommerce_api_keys: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wpstg0_woocommerce_attribute_taxonomies: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wpstg0_woocommerce_downloadable_product_permissions: Data: 0.02MB + Index: 0.06MB + Engine InnoDB
wpstg0_woocommerce_order_items: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wpstg0_woocommerce_order_itemmeta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wpstg0_woocommerce_tax_rates: Data: 0.02MB + Index: 0.06MB + Engine InnoDB
wpstg0_woocommerce_tax_rate_locations: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wpstg0_woocommerce_shipping_zones: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wpstg0_woocommerce_shipping_zone_locations: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wpstg0_woocommerce_shipping_zone_methods: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wpstg0_woocommerce_payment_tokens: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wpstg0_woocommerce_payment_tokenmeta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wpstg0_woocommerce_log: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_actionscheduler_actions: Data: 0.13MB + Index: 0.16MB + Engine InnoDB
wp_actionscheduler_claims: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_actionscheduler_groups: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_actionscheduler_logs: Data: 0.06MB + Index: 0.03MB + Engine InnoDB
wp_commentmeta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_comments: Data: 0.02MB + Index: 0.09MB + Engine InnoDB
wp_eum_logs: Data: 0.31MB + Index: 0.00MB + Engine InnoDB
wp_gf_addon_feed: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_gf_draft_submissions: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_gf_entry: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_gf_entry_meta: Data: 0.09MB + Index: 0.05MB + Engine InnoDB
wp_gf_entry_notes: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_gf_form: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_gf_form_meta: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_gf_form_revisions: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_gf_form_view: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_gf_rest_api_keys: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_links: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_options: Data: 4.03MB + Index: 0.13MB + Engine InnoDB
wp_pmxi_files: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_pmxi_hash: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_pmxi_history: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_pmxi_images: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_pmxi_imports: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_pmxi_posts: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_pmxi_templates: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_postmeta: Data: 0.38MB + Index: 0.22MB + Engine InnoDB
wp_posts: Data: 1.48MB + Index: 0.06MB + Engine InnoDB
wp_redirection_404: Data: 0.02MB + Index: 0.05MB + Engine InnoDB
wp_redirection_groups: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_redirection_items: Data: 0.02MB + Index: 0.09MB + Engine InnoDB
wp_redirection_logs: Data: 0.02MB + Index: 0.05MB + Engine InnoDB
wp_term_relationships: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_term_taxonomy: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_termmeta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_terms: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_usermeta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_users: Data: 0.02MB + Index: 0.05MB + Engine InnoDB
wp_wc_admin_note_actions: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_wc_admin_notes: Data: 0.06MB + Index: 0.00MB + Engine InnoDB
wp_wc_category_lookup: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_wc_customer_lookup: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_wc_download_log: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_wc_order_coupon_lookup: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_wc_order_product_lookup: Data: 0.02MB + Index: 0.06MB + Engine InnoDB
wp_wc_order_stats: Data: 0.02MB + Index: 0.05MB + Engine InnoDB
wp_wc_order_tax_lookup: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_wc_product_attributes_lookup: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_wc_product_meta_lookup: Data: 0.02MB + Index: 0.09MB + Engine InnoDB
wp_wc_rate_limits: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_wc_reserved_stock: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_wc_tax_rate_classes: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_wc_webhooks: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_woocommerce_api_keys: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_woocommerce_attribute_taxonomies: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_woocommerce_downloadable_product_permissions: Data: 0.02MB + Index: 0.06MB + Engine InnoDB
wp_woocommerce_log: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_woocommerce_order_itemmeta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_woocommerce_order_items: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_woocommerce_payment_tokenmeta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_woocommerce_payment_tokens: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_woocommerce_sessions: Data: 3.02MB + Index: 0.05MB + Engine InnoDB
wp_woocommerce_shipping_zone_locations: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_woocommerce_shipping_zone_methods: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_woocommerce_shipping_zones: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_woocommerce_tax_rate_locations: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_woocommerce_tax_rates: Data: 0.02MB + Index: 0.06MB + Engine InnoDB
wp_wpfm_backup: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_wpmailsmtp_debug_events: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_wpmailsmtp_tasks_meta: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_wpml_mails: Data: 0.14MB + Index: 0.00MB + Engine InnoDB
wp_yoast_indexable: Data: 0.14MB + Index: 0.09MB + Engine InnoDB
wp_yoast_indexable_hierarchy: Data: 0.02MB + Index: 0.05MB + Engine InnoDB
wp_yoast_migrations: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_yoast_primary_term: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_yoast_seo_links: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wpstg0_actionscheduler_actions: Data: 0.14MB + Index: 0.16MB + Engine InnoDB
wpstg0_actionscheduler_claims: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wpstg0_actionscheduler_groups: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wpstg0_actionscheduler_logs: Data: 0.11MB + Index: 0.13MB + Engine InnoDB
wpstg0_commentmeta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wpstg0_comments: Data: 0.02MB + Index: 0.09MB + Engine InnoDB
wpstg0_eum_logs: Data: 2.52MB + Index: 0.00MB + Engine InnoDB
wpstg0_gf_addon_feed: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wpstg0_gf_draft_submissions: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wpstg0_gf_entry: Data: 0.05MB + Index: 0.03MB + Engine InnoDB
wpstg0_gf_entry_meta: Data: 0.11MB + Index: 0.08MB + Engine InnoDB
wpstg0_gf_entry_notes: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wpstg0_gf_form: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wpstg0_gf_form_meta: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wpstg0_gf_form_revisions: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wpstg0_gf_form_view: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wpstg0_gf_rest_api_keys: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wpstg0_links: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wpstg0_options: Data: 3.48MB + Index: 0.08MB + Engine InnoDB
wpstg0_pmxi_files: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wpstg0_pmxi_hash: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wpstg0_pmxi_history: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wpstg0_pmxi_images: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wpstg0_pmxi_imports: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wpstg0_pmxi_posts: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wpstg0_pmxi_templates: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wpstg0_postmeta: Data: 0.50MB + Index: 0.28MB + Engine InnoDB
wpstg0_posts: Data: 1.52MB + Index: 0.06MB + Engine InnoDB
wpstg0_redirection_404: Data: 0.02MB + Index: 0.05MB + Engine InnoDB
wpstg0_redirection_groups: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wpstg0_redirection_items: Data: 0.02MB + Index: 0.09MB + Engine InnoDB
wpstg0_redirection_logs: Data: 0.02MB + Index: 0.05MB + Engine InnoDB
wpstg0_term_relationships: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wpstg0_term_taxonomy: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wpstg0_termmeta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wpstg0_terms: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wpstg0_usermeta: Data: 0.05MB + Index: 0.03MB + Engine InnoDB
wpstg0_users: Data: 0.02MB + Index: 0.05MB + Engine InnoDB
wpstg0_wc_admin_note_actions: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wpstg0_wc_admin_notes: Data: 0.06MB + Index: 0.00MB + Engine InnoDB
wpstg0_wc_category_lookup: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wpstg0_wc_customer_lookup: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wpstg0_wc_download_log: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wpstg0_wc_order_coupon_lookup: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wpstg0_wc_order_product_lookup: Data: 0.02MB + Index: 0.06MB + Engine InnoDB
wpstg0_wc_order_stats: Data: 0.02MB + Index: 0.05MB + Engine InnoDB
wpstg0_wc_order_tax_lookup: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wpstg0_wc_product_attributes_lookup: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wpstg0_wc_product_meta_lookup: Data: 0.02MB + Index: 0.09MB + Engine InnoDB
wpstg0_wc_rate_limits: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wpstg0_wc_reserved_stock: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wpstg0_wc_tax_rate_classes: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wpstg0_wc_webhooks: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wpstg0_wpfm_backup: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wpstg0_wpmailsmtp_debug_events: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wpstg0_wpmailsmtp_tasks_meta: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wpstg0_wpml_mails: Data: 0.25MB + Index: 0.00MB + Engine InnoDB
wpstg0_yoast_indexable: Data: 0.13MB + Index: 0.09MB + Engine InnoDB
wpstg0_yoast_indexable_hierarchy: Data: 0.02MB + Index: 0.05MB + Engine InnoDB
wpstg0_yoast_migrations: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wpstg0_yoast_primary_term: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wpstg0_yoast_seo_links: Data: 0.02MB + Index: 0.03MB + Engine InnoDB

### Post Type Counts ###

acf-field: 123
acf-field-group: 8
attachment: 100
nav_menu_item: 16
page: 13
post: 11
product: 1
revision: 145
services: 5
shop_order: 2

### Security ###

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

### Active Plugins (2) ###

WooCommerce Canada Post Shipping: by WooCommerce – 2.5.27
WooCommerce: by Automattic – 6.3.1

### Inactive Plugins (21) ###

Advanced Custom Fields PRO: by Delicious Brains – 5.12.1
Classic Editor: by WordPress Contributors – 1.6.2
Disable Comments: by WPDeveloper – 2.3.4
Disable Feeds: by Samir Shah
BBpress support by Matthew Sigley – 1.4.4

Easy Updates Manager Premium: by Easy Updates Manager Team – 9.0.12
Gravity Forms: by Gravity Forms – 2.6.1
Gravity Forms Event Tracking: by Ronald Huereca – 2.4.11
Gravity Forms reCAPTCHA Add-On: by Gravity Forms – 1.1
Jetpack: by Automattic – 10.7
Redirection: by John Godley – 5.2.3
Social Feed Gallery: by QuadLayers – 3.3.6
UpdraftPlus - Backup/Restore: by UpdraftPlus.Com
DavidAnderson – 1.22.11

WooCommerce - ShipStation Integration: by WooCommerce – 4.1.48
WooCommerce Payments: by Automattic – 3.9.0 (update to version 3.9.1 is available)
WooCommerce Stripe Gateway: by WooCommerce – 6.3.0
WordPress Importer: by wordpressdotorg – 0.7
WP Mail Logging: by Wysija – 1.10.4
WP Mail SMTP: by WPForms – 3.3.0
WP STAGING PRO: by WP-STAGING – 4.1.8
Yoast Duplicate Post: by Enrico Battocchi & Team Yoast – 4.4
Yoast SEO: by Team Yoast – 18.4.1

### Settings ###

API Enabled: –
Force SSL: –
Currency: CAD ($)
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: #2273 - /?page_id=2273
Cart: #2274 - /?page_id=2274
Checkout: #2275 - /?page_id=2275
My account: #2276 - /?page_id=2276
Terms and conditions: ? Page not set

### Theme ###

Name: Storefront
Version: 4.0.0
Author URL: https://woocommerce.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 ###

Overrides: –

### Action Scheduler ###

Complete: 385
Oldest: 2022-03-01 09:28:40 -0500
Newest: 2022-03-30 05:25:25 -0400

### Status report information ###

Generated at: 2022-03-30 13:19:41 -04:00

• This reply was modified 2 years, 11 months ago by zgall1.

I turned off all plugins except for WooCommerce and WooCommerce Canada Post Shipping and it is still not working.

You can test it at this link.

https://expressyourselfspeech.ca/staging/?page_id=2274

I think your first message was actually right. I changed the form to Ajax only and I believe that events are now firing as expected.

There was an .htaccess file in a cache with the permissions of 664 (so an extra write permission). I changed it to 644 just in case but it made no difference.

I executed the changes manually and the error is now gone. I guess that is fine for now.

There is clearly another cause as my file permissions are correct. Is there any further debugging that you can do? Can I provide you with any logs?