WooCommerce (pref)_wc_reserved_stock table creation failed

Hello @h_ou20,

Thanks for reaching out to WooCommerce Support.

Looking at the error message, it is possible that the WooCommerce plugin is unable to create a necessary table in your WordPress database.

To troubleshoot this, please try creating the database completely first. To do this, please go to?WooCommerce > Status > Tools?and then click on “Verify base database tables”. Once you’ve done that, let us know the results and if you’re still seeing the same database error messages.

Thanks!

Thank you for your response @rajeshml , yes i’ve checked via “verify database” but i see the message again.

Also WooCommerce System Status Report as follows:

###
<br>### WordPress Environment ###<br><br>WordPress address (URL): https://localhost/shp<br>Site address (URL): https://localhost/shp<br>WC Version: 9.2.3<br>Legacy REST API Package Version: The Legacy REST API plugin is not installed on this site.<br>Action Scheduler Version: ? 3.8.1<br>Log Directory Writable: ?<br>WP Version: 6.6.1<br>WP Multisite: –<br>WP Memory Limit: 512 MB<br>WP Debug Mode: –<br>WP Cron: ?<br>Language: en_US<br>External object cache: –<br><br>### Server Environment ###<br><br>Server Info: Apache/2.4.58 (Win64) OpenSSL/3.1.3 PHP/8.2.12<br>PHP Version: 8.2.12<br>PHP Post Max Size: 40 MB<br>PHP Time Limit: 120<br>PHP Max Input Vars: 1000<br>cURL Version: 8.4.0<br>OpenSSL/3.1.3<br><br>SUHOSIN Installed: –<br>MySQL Version: 10.4.32-MariaDB<br>Max Upload Size: 40 MB<br>Default Timezone is UTC: ?<br>fsockopen/cURL: ?<br>SoapClient: ? Your server does not have the SoapClient class enabled - some gateway plugins which use SOAP may not work as expected.<br>DOMDocument: ?<br>GZip: ?<br>Multibyte String: ?<br>Remote Post: ? wp_remote_post() failed. Contact your hosting provider. 403<br>Remote Get: ?<br><br>### Database ###<br><br>WC Database Version: 9.2.3<br>WC Database Prefix: SY_WP_<br>Total Database Size: 13.33MB<br>Database Data Size: 9.28MB<br>Database Index Size: 4.05MB<br>SY_WP_woocommerce_sessions: ? Table does not exist<br>SY_WP_woocommerce_api_keys: ? Table does not exist<br>SY_WP_woocommerce_attribute_taxonomies: ? Table does not exist<br>SY_WP_woocommerce_downloadable_product_permissions: ? Table does not exist<br>SY_WP_woocommerce_order_items: ? Table does not exist<br>SY_WP_woocommerce_order_itemmeta: ? Table does not exist<br>SY_WP_woocommerce_tax_rates: ? Table does not exist<br>SY_WP_woocommerce_tax_rate_locations: ? Table does not exist<br>SY_WP_woocommerce_shipping_zones: ? Table does not exist<br>SY_WP_woocommerce_shipping_zone_locations: ? Table does not exist<br>SY_WP_woocommerce_shipping_zone_methods: ? Table does not exist<br>SY_WP_woocommerce_payment_tokens: ? Table does not exist<br>SY_WP_woocommerce_payment_tokenmeta: ? Table does not exist<br>SY_WP_woocommerce_log: ? Table does not exist<br>sy_wp_actionscheduler_actions: Data: 0.06MB + Index: 0.11MB + Engine InnoDB<br>sy_wp_actionscheduler_claims: Data: 0.02MB + Index: 0.02MB + Engine InnoDB<br>sy_wp_actionscheduler_groups: Data: 0.02MB + Index: 0.02MB + Engine InnoDB<br>sy_wp_actionscheduler_logs: Data: 0.06MB + Index: 0.03MB + Engine InnoDB<br>sy_wp_commentmeta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB<br>sy_wp_comments: Data: 0.02MB + Index: 0.09MB + Engine InnoDB<br>sy_wp_cube_relationships: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>sy_wp_cwp_forms_leads: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>sy_wp_e_events: Data: 0.02MB + Index: 0.02MB + Engine InnoDB<br>sy_wp_e_submissions: Data: 0.02MB + Index: 0.27MB + Engine InnoDB<br>sy_wp_e_submissions_actions_log: Data: 0.02MB + Index: 0.11MB + Engine InnoDB<br>sy_wp_e_submissions_values: Data: 0.02MB + Index: 0.03MB + Engine InnoDB<br>sy_wp_facetwp_index: Data: 0.02MB + Index: 0.05MB + Engine InnoDB<br>sy_wp_gla_attribute_mapping_rules: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>sy_wp_gla_budget_recommendations: Data: 0.19MB + Index: 0.14MB + Engine InnoDB<br>sy_wp_gla_merchant_issues: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>sy_wp_gla_shipping_rates: Data: 0.02MB + Index: 0.03MB + Engine InnoDB<br>sy_wp_gla_shipping_times: Data: 0.02MB + Index: 0.02MB + Engine InnoDB<br>sy_wp_links: Data: 0.02MB + Index: 0.02MB + Engine InnoDB<br>sy_wp_mailpoet_automations: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>sy_wp_mailpoet_automation_runs: Data: 0.02MB + Index: 0.08MB + Engine InnoDB<br>sy_wp_mailpoet_automation_run_logs: Data: 0.02MB + Index: 0.06MB + Engine InnoDB<br>sy_wp_mailpoet_automation_run_subjects: Data: 0.02MB + Index: 0.03MB + Engine InnoDB<br>sy_wp_mailpoet_automation_triggers: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>sy_wp_mailpoet_automation_versions: Data: 0.02MB + Index: 0.02MB + Engine InnoDB<br>sy_wp_mailpoet_custom_fields: Data: 0.02MB + Index: 0.02MB + Engine InnoDB<br>sy_wp_mailpoet_dynamic_segment_filters: Data: 0.02MB + Index: 0.02MB + Engine InnoDB<br>sy_wp_mailpoet_feature_flags: Data: 0.02MB + Index: 0.02MB + Engine InnoDB<br>sy_wp_mailpoet_forms: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>sy_wp_mailpoet_log: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>sy_wp_mailpoet_migrations: Data: 0.02MB + Index: 0.02MB + Engine InnoDB<br>sy_wp_mailpoet_newsletters: Data: 0.02MB + Index: 0.05MB + Engine InnoDB<br>sy_wp_mailpoet_newsletter_links: Data: 0.02MB + Index: 0.05MB + Engine InnoDB<br>sy_wp_mailpoet_newsletter_option: Data: 0.02MB + Index: 0.02MB + Engine InnoDB<br>sy_wp_mailpoet_newsletter_option_fields: Data: 0.02MB + Index: 0.02MB + Engine InnoDB<br>sy_wp_mailpoet_newsletter_posts: Data: 0.02MB + Index: 0.02MB + Engine InnoDB<br>sy_wp_mailpoet_newsletter_segment: Data: 0.02MB + Index: 0.02MB + Engine InnoDB<br>sy_wp_mailpoet_newsletter_templates: Data: 2.52MB + Index: 0.00MB + Engine InnoDB<br>sy_wp_mailpoet_scheduled_tasks: Data: 0.02MB + Index: 0.03MB + Engine InnoDB<br>sy_wp_mailpoet_scheduled_task_subscribers: Data: 0.02MB + Index: 0.02MB + Engine InnoDB<br>sy_wp_mailpoet_segments: Data: 0.02MB + Index: 0.03MB + Engine InnoDB<br>sy_wp_mailpoet_sending_queues: Data: 0.02MB + Index: 0.03MB + Engine InnoDB<br>sy_wp_mailpoet_settings: Data: 0.02MB + Index: 0.02MB + Engine InnoDB<br>sy_wp_mailpoet_statistics_bounces: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>sy_wp_mailpoet_statistics_clicks: Data: 0.02MB + Index: 0.05MB + Engine InnoDB<br>sy_wp_mailpoet_statistics_forms: Data: 0.02MB + Index: 0.02MB + Engine InnoDB<br>sy_wp_mailpoet_statistics_newsletters: Data: 0.02MB + Index: 0.03MB + Engine InnoDB<br>sy_wp_mailpoet_statistics_opens: Data: 0.02MB + Index: 0.08MB + Engine InnoDB<br>sy_wp_mailpoet_statistics_unsubscribes: Data: 0.02MB + Index: 0.05MB + Engine InnoDB<br>sy_wp_mailpoet_statistics_woocommerce_purchases: Data: 0.02MB + Index: 0.08MB + Engine InnoDB<br>sy_wp_mailpoet_stats_notifications: Data: 0.02MB + Index: 0.03MB + Engine InnoDB<br>sy_wp_mailpoet_subscribers: Data: 0.02MB + Index: 0.23MB + Engine InnoDB<br>sy_wp_mailpoet_subscriber_custom_field: Data: 0.02MB + Index: 0.02MB + Engine InnoDB<br>sy_wp_mailpoet_subscriber_ips: Data: 0.02MB + Index: 0.02MB + Engine InnoDB<br>sy_wp_mailpoet_subscriber_segment: Data: 0.02MB + Index: 0.03MB + Engine InnoDB<br>sy_wp_mailpoet_subscriber_tag: Data: 0.02MB + Index: 0.03MB + Engine InnoDB<br>sy_wp_mailpoet_tags: Data: 0.02MB + Index: 0.02MB + Engine InnoDB<br>sy_wp_mailpoet_user_agents: Data: 0.02MB + Index: 0.02MB + Engine InnoDB<br>sy_wp_mailpoet_user_flags: Data: 0.02MB + Index: 0.02MB + Engine InnoDB<br>sy_wp_options: Data: 4.05MB + Index: 0.06MB + Engine InnoDB<br>sy_wp_postmeta: Data: 0.19MB + Index: 0.16MB + Engine InnoDB<br>sy_wp_posts: Data: 0.13MB + Index: 0.06MB + Engine InnoDB<br>sy_wp_social_users: Data: 0.02MB + Index: 0.03MB + Engine InnoDB<br>sy_wp_termmeta: Data: 0.06MB + Index: 0.03MB + Engine InnoDB<br>sy_wp_terms: Data: 0.02MB + Index: 0.03MB + Engine InnoDB<br>sy_wp_term_relationships: Data: 0.02MB + Index: 0.02MB + Engine InnoDB<br>sy_wp_term_taxonomy: Data: 0.02MB + Index: 0.03MB + Engine InnoDB<br>sy_wp_usermeta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB<br>sy_wp_users: Data: 0.02MB + Index: 0.05MB + Engine InnoDB<br>sy_wp_wc_admin_notes: Data: 0.06MB + Index: 0.00MB + Engine InnoDB<br>sy_wp_wc_admin_note_actions: Data: 0.02MB + Index: 0.02MB + Engine InnoDB<br>sy_wp_wc_category_lookup: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>sy_wp_wc_customer_lookup: Data: 0.02MB + Index: 0.03MB + Engine InnoDB<br>sy_wp_wc_download_log: Data: 0.02MB + Index: 0.03MB + Engine InnoDB<br>sy_wp_wc_orders: Data: 0.02MB + Index: 0.11MB + Engine InnoDB<br>sy_wp_wc_orders_meta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB<br>sy_wp_wc_order_addresses: Data: 0.02MB + Index: 0.06MB + Engine InnoDB<br>sy_wp_wc_order_coupon_lookup: Data: 0.02MB + Index: 0.03MB + Engine InnoDB<br>sy_wp_wc_order_operational_data: Data: 0.02MB + Index: 0.03MB + Engine InnoDB<br>sy_wp_wc_order_product_lookup: Data: 0.02MB + Index: 0.06MB + Engine InnoDB<br>sy_wp_wc_order_stats: Data: 0.02MB + Index: 0.05MB + Engine InnoDB<br>sy_wp_wc_order_tax_lookup: Data: 0.02MB + Index: 0.03MB + Engine InnoDB<br>sy_wp_wc_product_attributes_lookup: Data: 0.02MB + Index: 0.02MB + Engine InnoDB<br>sy_wp_wc_product_download_directories: Data: 0.02MB + Index: 0.02MB + Engine InnoDB<br>sy_wp_wc_product_meta_lookup: Data: 0.02MB + Index: 0.11MB + Engine InnoDB<br>sy_wp_wc_rate_limits: Data: 0.02MB + Index: 0.02MB + Engine InnoDB<br>sy_wp_wc_reserved_stock: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>sy_wp_wc_tax_rate_classes: Data: 0.02MB + Index: 0.02MB + Engine InnoDB<br>sy_wp_wc_webhooks: Data: 0.02MB + Index: 0.02MB + Engine InnoDB<br>sy_wp_woocommerce_api_keys: Data: 0.02MB + Index: 0.03MB + Engine InnoDB<br>sy_wp_woocommerce_attribute_taxonomies: Data: 0.02MB + Index: 0.02MB + Engine InnoDB<br>sy_wp_woocommerce_downloadable_product_permissions: Data: 0.02MB + Index: 0.06MB + Engine InnoDB<br>sy_wp_woocommerce_log: Data: 0.02MB + Index: 0.02MB + Engine InnoDB<br>sy_wp_woocommerce_order_itemmeta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB<br>sy_wp_woocommerce_order_items: Data: 0.02MB + Index: 0.02MB + Engine InnoDB<br>sy_wp_woocommerce_payment_tokenmeta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB<br>sy_wp_woocommerce_payment_tokens: Data: 0.02MB + Index: 0.02MB + Engine InnoDB<br>sy_wp_woocommerce_sessions: Data: 0.02MB + Index: 0.02MB + Engine InnoDB<br>sy_wp_woocommerce_shipping_zones: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>sy_wp_woocommerce_shipping_zone_locations: Data: 0.02MB + Index: 0.03MB + Engine InnoDB<br>sy_wp_woocommerce_shipping_zone_methods: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>sy_wp_woocommerce_tax_rates: Data: 0.02MB + Index: 0.06MB + Engine InnoDB<br>sy_wp_woocommerce_tax_rate_locations: Data: 0.02MB + Index: 0.03MB + Engine InnoDB<br>sy_wp_wpforms_logs: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>sy_wp_wpforms_payments: Data: 0.02MB + Index: 0.14MB + Engine InnoDB<br>sy_wp_wpforms_payment_meta: Data: 0.02MB + Index: 0.05MB + Engine InnoDB<br>sy_wp_wpforms_tasks_meta: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br><br>### Post Type Counts ###<br><br>attachment: 13<br>custom_css: 1<br>customize_changeset: 5<br>cwp_form_fields: 1<br>elementor_library: 1<br>listing: 10<br>lp-ads: 3<br>mailpoet_page: 1<br>nav_menu_item: 67<br>page: 17<br>post: 4<br>price_plan: 3<br>wp_font_face: 33<br>wp_font_family: 12<br>wp_navigation: 1<br><br>### Security ###<br><br>Secure connection (HTTPS): ?<br>					Your store is not using HTTPS. Learn more about HTTPS and SSL Certificates.<br>Hide errors from visitors: ?<br><br>### Active Plugins (21) ###<br><br>Redux Framework: by Team Redux – 4.4.18<br>Advanced Custom Fields: by WP Engine – 6.3.6<br>CubeWP Forms: by CubeWP – 1.1.2<br>CubeWP Framework: by CubeWP – 1.1.16<br>Elementor Pro: by Elementor.com – 3.23.3<br>Elementor: by Elementor.com – 3.23.4<br>FacetWP - Elementor: by FacetWP<br>LLC – 1.6.7<br><br>FacetWP: by FacetWP<br>LLC – 4.3.3<br><br>Google for WooCommerce: by WooCommerce – 2.8.5<br>Jetpack: by Automattic – 13.8<br>ListingPro Ads: by CridioStudio (Dev Team) – 1.3<br>ListingPro Plugin: by CridioStudio (Dev Team) – 2.9.3<br>ListingPro Reviews: by CridioStudio (Dev Team) – 1.4<br>MailPoet: by MailPoet – 5.1.1<br>Nextend Social Login: by Nextendweb – 3.1.14<br>Pinterest for WooCommerce: by WooCommerce – 1.4.8<br>TikTok: by TikTok – 1.2.8<br>WooPayments: by WooCommerce – 8.1.1<br>WooCommerce: by Automattic – 9.2.3<br>WordPress Importer: by wordpressdotorg – 0.8.2<br>WPForms Lite: by WPForms – 1.9.0.4<br><br>### Inactive Plugins (1) ###<br><br>Image Optimizer by Elementor – Compress, Resize and Optimize Images: by Elementor.com – 1.5.2<br><br>### Settings ###<br><br>Legacy API Enabled: –<br>Force SSL: –<br>Currency: AED (?.?)<br>Currency Position: right_space<br>Thousand Separator: .<br>Decimal Separator: ,<br>Number of Decimals: 2<br>Taxonomies: Product Types: external (external)<br>grouped (grouped)<br>simple (simple)<br>variable (variable)<br><br>Taxonomies: Product Visibility: exclude-from-catalog (exclude-from-catalog)<br>exclude-from-search (exclude-from-search)<br>featured (featured)<br>outofstock (outofstock)<br>rated-1 (rated-1)<br>rated-2 (rated-2)<br>rated-3 (rated-3)<br>rated-4 (rated-4)<br>rated-5 (rated-5)<br><br>Connected to WooCommerce.com: –<br>Enforce Approved Product Download Directories: ?<br>HPOS feature enabled: ?<br>Order datastore: Automattic\WooCommerce\Internal\DataStores\Orders\OrdersTableDataStore<br>HPOS data sync enabled: –<br><br>### Logging ###<br><br>Enabled: ?<br>Handler: Automattic\WooCommerce\Internal\Admin\Logging\LogHandlerFileV2<br>Retention period: 30 days<br>Level threshold: –<br>Log directory size: 52 KB<br><br>### WC Pages ###<br><br>Shop base: #672 - /shop/<br>Cart: #673 - /cart/ -  Contains the woocommerce/cart block<br>Checkout: #674 - /checkout/ -  Contains the woocommerce/checkout block<br>My account: #675 - /my-account/<br>Terms and conditions: ? Page not set<br><br>### Theme ###<br><br>Name: Listingpro<br>Version: 2.9.3<br>Author URL: https://themeforest.net/user/cridiostudio<br>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<br>WooCommerce Support: ? Not declared<br><br>### Templates ###<br><br>Overrides: –<br><br>### WooPayments ###<br><br>Version: 8.1.1<br>Connected to WPCOM: ? No<br>Logging: Disabled<br><br>### MailPoet ###<br><br>Sending Method: PHPMail<br>Send all site's emails with: Default WordPress sending method<br>Task Scheduler method: Action Scheduler<br>Cron ping URL: https://localhost/shp?mailpoet_router&endpoint=cron_daemon&action=ping<br><br>### Admin ###<br><br>Enabled Features: activity-panels<br>analytics<br>product-block-editor<br>coupons<br>core-profiler<br>customize-store<br>customer-effort-score-tracks<br>import-products-task<br>experimental-fashion-sample-products<br>shipping-smart-defaults<br>shipping-setting-tour<br>homescreen<br>marketing<br>mobile-app-banner<br>navigation<br>onboarding<br>onboarding-tasks<br>pattern-toolkit-full-composability<br>product-custom-fields<br>remote-inbox-notifications<br>remote-free-extensions<br>payment-gateway-suggestions<br>printful<br>shipping-label-banner<br>subscriptions<br>store-alerts<br>transient-notices<br>woo-mobile-welcome<br>wc-pay-promotion<br>wc-pay-welcome-page<br>launch-your-store<br><br>Disabled Features: experimental-blocks<br>minified-js<br>product-pre-publish-modal<br>settings<br>async-product-editor-category-field<br>product-editor-template-system<br><br>Daily Cron: ? Next scheduled: 2024-09-07 07:49:32 +00:00<br>Options: ?<br>Notes: 57<br>Onboarding: completed<br><br>### Action Scheduler ###<br><br>Complete: 137<br>Oldest: 2024-09-06 07:50:29 +0000<br>Newest: 2024-09-06 11:21:51 +0000<br><br>Pending: 4<br>Oldest: 2024-09-06 11:23:48 +0000<br>Newest: 2024-09-07 09:08:09 +0000<br><br><br>### Status report information ###<br><br>Generated at: 2024-09-06 11:23:39 +00:00<br>

###

• This reply was modified 2 months, 2 weeks ago by h_ou20.

Hey, @h_ou20!

Thanks for sharing the SSR.

I noticed the tables on your database all have a SY_ prefix which is not default.

Have you modified the table prefix yourself?
If not, whatever did this is probably causing the issue.

Can you please run a conflict test to see if the issue persists?

To test, you’ll first want to change the theme on your site to Storefront, then you’ll want to deactivate all plugins except for WooCommerce. After this, please reinstall WooCommerce to make sure the tables are correctly created and check if the issue persists.

If that fixes the problem, re-enable the other plugins one by one (gradually), checking after each, to see where the issue is coming from.

— Be sure you have a good backup in place of your full site and database. You can ask your host for backup functionality or you can consider using a service like Jetpack. If something goes wrong, you will be able to restore it.

— It is important to consider as well a staging functionality in case you would not like to touch your production site (you can ask your host if they offer this service), or you can use WP Staging for quickly spinning up a new test site.

You can find more about this in this guide.

Please let us know about your findings.

Have a wonderful day!