Ian
Forum Replies Created
-
Thank you. This has fixed the error.
Thank you.
I managed to create the tables manually in SQL.
Just have one last error as below:
WordPress database error Unknown column 'new' in 'where clause' for query SELECT * FROM wp_aioseo_notifications WHERE 1 = 1 AND <code>dismissed</code> = 0 AND <code>new</code> = 1 AND (start <= '2021-09-17 05:47:05' OR start IS NULL) AND (end >= '2021-09-17 05:47:05' OR end IS NULL) ORDER BY start DESC, created DESC /* 1 = 1 */ made by require_once('wp-admin/admin-header.php'), do_action('admin_enqueue_scripts'), WP_Hook->do_action, WP_Hook->apply_filters, AIOSEO\Plugin\Common\Main\Main->enqueueAssets, AIOSEO\Plugin\Common\Models\Notification::getNewNotifications, AIOSEO\Plugin\Common\Utils\Database->run
Forum: Plugins
In reply to: [LiteSpeed Cache] WordPress database error TableThank you.
I managed to fix it by manually running the query in SQL.
Forum: Plugins
In reply to: [WooCommerce] Scheduled actions issue after updating WCHere is further information received via email:
WordPress version 5.7.2 Current theme: Virtue Child (version 3.3.1) Current plugin: WooCommerce (version 5.3.0) PHP version 7.4.16 Error Details ============= An error of type E_ERROR was caused in line 79 of the file /home2/nanotech/public_html/wp-content/plugins/woocommerce/packages/action-scheduler/classes/ActionScheduler_wcSystemStatus.php. Error message: Uncaught Error: Call to a member function format() on null in /home2/nanotech/public_html/wp-content/plugins/woocommerce/packages/action-scheduler/classes/ActionScheduler_wcSystemStatus.php:79 Stack trace: #0 /home2/nanotech/public_html/wp-content/plugins/woocommerce/packages/action-scheduler/classes/ActionScheduler_wcSystemStatus.php(52): ActionScheduler_wcSystemStatus->get_action_status_date('pending', 'oldest') #1 /home2/nanotech/public_html/wp-content/plugins/woocommerce/packages/action-scheduler/classes/ActionScheduler_wcSystemStatus.php(27): ActionScheduler_wcSystemStatus->get_oldest_and_newest(Array) #2 /home2/nanotech/public_html/wp-content/plugins/woocommerce/packages/action-scheduler/classes/ActionScheduler_AdminView.php(50): ActionScheduler_wcSystemStatus->render() #3 /home2/nanotech/public_html/wp-includes/class-wp-hook.php(292): ActionScheduler_AdminView->system_status_report('') #4 /home2/nanotech/public_html/wp-includes/class-wp-hook.php(316): WP_Hook->apply_filters('', Array) #5 /home2/nanotec
Forum: Plugins
In reply to: [WooCommerce] Scheduled actions issue after updating WCThank you for your help.
### WordPress Environment ### WordPress address (URL): https://nanotechnologysolutions.com.au Site address (URL): https://nanotechnologysolutions.com.au WC Version: 5.3.0 REST API Version: ? 5.3.0 WC Blocks Version: ? 4.9.1 Action Scheduler Version: ? 3.1.6 WC Admin Version: ? 2.2.6 Log Directory Writable: ? WP Version: 5.7.2 WP Multisite: – WP Memory Limit: 256 MB WP Debug Mode: – WP Cron: – Language: en_AU External object cache: – ### Server Environment ### Server Info: LiteSpeed PHP Version: 7.4.16 PHP Post Max Size: 8 MB PHP Time Limit: 30 PHP Max Input Vars: 1000 cURL Version: 7.71.0 OpenSSL/1.1.1d SUHOSIN Installed: – MySQL Version: 10.3.28-MariaDB-cll-lve Max Upload Size: 8 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: 5.3.0 WC Database Prefix: wp_ Total Database Size: 26.28MB Database Data Size: 19.92MB Database Index Size: 6.36MB wp_woocommerce_sessions: Data: 0.03MB + 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_order_items: Data: 0.02MB + Index: 0.02MB + Engine InnoDB wp_woocommerce_order_itemmeta: Data: 0.06MB + Index: 0.03MB + Engine InnoDB wp_woocommerce_tax_rates: Data: 0.02MB + Index: 0.06MB + Engine InnoDB wp_woocommerce_tax_rate_locations: Data: 0.02MB + Index: 0.03MB + Engine InnoDB wp_woocommerce_shipping_zones: Data: 0.02MB + Index: 0.00MB + 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_payment_tokens: Data: 0.02MB + Index: 0.02MB + Engine InnoDB wp_woocommerce_payment_tokenmeta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB wp_woocommerce_log: Data: 0.02MB + Index: 0.02MB + Engine InnoDB wp_actionscheduler_actions: Data: 1.52MB + Index: 0.78MB + Engine InnoDB wp_commentmeta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB wp_comments: Data: 0.05MB + Index: 0.09MB + Engine InnoDB wp_ewwwio_images: Data: 0.34MB + Index: 0.19MB + Engine InnoDB wp_ewwwio_queue: Data: 0.02MB + Index: 0.02MB + Engine InnoDB wp_links: Data: 0.02MB + Index: 0.02MB + Engine InnoDB wp_litespeed_cssjs: Data: 0.08MB + Index: 0.03MB + Engine InnoDB wp_litespeed_img_optm: Data: 0.16MB + Index: 0.11MB + Engine InnoDB wp_litespeed_img_optming: Data: 0.02MB + Index: 0.03MB + Engine InnoDB wp_litespeed_optimizer: Data: 0.02MB + Index: 0.06MB + Engine InnoDB wp_nf3_actions: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wp_nf3_action_meta: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wp_nf3_chunks: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wp_nf3_fields: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wp_nf3_field_meta: Data: 0.06MB + Index: 0.00MB + Engine InnoDB wp_nf3_forms: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wp_nf3_form_meta: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wp_nf3_objects: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wp_nf3_object_meta: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wp_nf3_relationships: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wp_nf3_upgrades: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wp_nf_objectmeta: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wp_nf_objects: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wp_nf_relationships: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wp_ninja_forms_fav_fields: Data: 0.05MB + Index: 0.00MB + Engine InnoDB wp_ninja_forms_fields: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wp_options: Data: 2.22MB + Index: 0.14MB + Engine InnoDB wp_postmeta: Data: 3.52MB + Index: 3.03MB + Engine InnoDB wp_posts: Data: 1.44MB + Index: 0.13MB + Engine InnoDB wp_po_plugins: Data: 0.08MB + Index: 0.06MB + Engine InnoDB wp_termmeta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB wp_terms: Data: 0.02MB + Index: 0.03MB + Engine InnoDB wp_term_relationships: Data: 0.05MB + Index: 0.02MB + Engine InnoDB wp_term_taxonomy: Data: 0.02MB + Index: 0.03MB + Engine InnoDB wp_test: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wp_test2: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wp_usermeta: Data: 0.08MB + Index: 0.03MB + Engine InnoDB wp_users: Data: 0.02MB + Index: 0.05MB + Engine InnoDB wp_wcpdf_invoice_number: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wp_wc_download_log: Data: 0.02MB + Index: 0.03MB + Engine InnoDB wp_wc_product_meta_lookup: Data: 0.02MB + Index: 0.09MB + 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_wfBlockedIPLog: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wp_wfBlocks7: Data: 0.08MB + Index: 0.05MB + Engine InnoDB wp_wfConfig: Data: 1.27MB + Index: 0.00MB + Engine InnoDB wp_wfCrawlers: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wp_wfFileChanges: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wp_wfFileMods: Data: 3.52MB + Index: 0.00MB + Engine InnoDB wp_wfHits: Data: 1.02MB + Index: 0.33MB + Engine InnoDB wp_wfHoover: Data: 0.02MB + Index: 0.02MB + Engine InnoDB wp_wfIssues: Data: 0.02MB + Index: 0.06MB + Engine InnoDB wp_wfKnownFileList: Data: 1.52MB + Index: 0.00MB + Engine InnoDB wp_wfLiveTrafficHuman: Data: 0.02MB + Index: 0.02MB + Engine InnoDB wp_wfLocs: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wp_wfLogins: Data: 1.50MB + Index: 0.22MB + Engine InnoDB 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.02MB + Index: 0.00MB + Engine InnoDB wp_wfPendingIssues: Data: 0.02MB + Index: 0.06MB + Engine InnoDB wp_wfReverseCache: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wp_wfSNIPCache: Data: 0.02MB + Index: 0.05MB + Engine InnoDB wp_wfStatus: Data: 0.13MB + Index: 0.09MB + Engine InnoDB wp_wfTrafficRates: Data: 0.02MB + Index: 0.00MB + Engine InnoDB ### Post Type Counts ### attachment: 244 custom_css: 2 jp_img_sitemap: 1 jp_sitemap: 1 jp_sitemap_master: 1 nav_menu_item: 11 page: 21 post: 5 product: 117 product_variation: 195 revision: 18 shop_coupon: 3 shop_order: 28 ### Security ### Secure connection (HTTPS): ? Hide errors from visitors: ? ### Active Plugins (12) ### All in One SEO: by All in One SEO Team – 4.1.1.1 Classic Editor: by WordPress Contributors – 1.6 LiteSpeed Cache: by LiteSpeed Technologies – 3.6.4 Ninja Forms: by Saturday Drive – 3.5.4 Plugin Organizer: by Jeff Sterup – 10.1.5 UpdraftPlus - Backup/Restore: by UpdraftPlus.com DavidAnderson – 1.16.56 Virtue/Ascend/Pinnacle Toolkit: by Kadence WP – 4.9.6 WooCommerce Stripe Gateway: by WooCommerce – 5.2.0 WooCommerce PDF Invoices & Packing Slips: by Ewout Fernhout – 2.9.0 WooCommerce: by Automattic – 5.3.0 Woopra: by <a href="https://www.woopra.com">Elie Khoury</a> – 2.9.4 Wordfence Security: by Wordfence – 7.5.3 ### Inactive Plugins (3) ### Action Scheduler: by Automattic – 3.1.6 Post Type Switcher: by Triple J Software Inc. – 3.2.1 WooCommerce Admin: by WooCommerce – 2.3.1 ### Dropin Plugins (2) ### advanced-cache.php: advanced-cache.php maintenance.php: maintenance.php ### Must Use Plugins (2) ### installatron_hide_status_test.php: by – Plugin Organizer MU: by Jeff Sterup – 10.1.5 ### Settings ### API Enabled: ? Force SSL: ? Currency: AUD (A$) Currency Position: left_space Thousand Separator: , Decimal Separator: . Number of Decimals: 0 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: #860 - /estore/ Cart: #861 - /estore-cart/ Checkout: #862 - /estore-checkout/ My account: #863 - /my-account/ Terms and conditions: ? Page not set ### Theme ### Name: Virtue Child Version: 3.3.1 Author URL: https://nanotechnologysolutions.com.au/ Child Theme: ? Parent Theme Name: Virtue Parent Theme Version: 3.4.5 Parent Theme Author URL: https://kadencewp.com/ WooCommerce Support: ? ### Templates ### Overrides: virtue/woocommerce/archive-product.php virtue/woocommerce/content-product.php virtue/woocommerce/content-single-product.php virtue-child/woocommerce/emails/admin-cancelled-order.php virtue-child/woocommerce/emails/admin-failed-order.php virtue-child/woocommerce/emails/admin-new-order.php virtue/woocommerce/loop/loop-end.php virtue/woocommerce/loop/loop-start.php virtue/woocommerce/loop/price.php virtue/woocommerce/loop/rating.php virtue/woocommerce/loop/sale-flash.php virtue/woocommerce/single-product/add-to-cart/external.php virtue/woocommerce/single-product/add-to-cart/grouped.php virtue/woocommerce/single-product/add-to-cart/simple.php virtue/woocommerce/single-product/add-to-cart/variable.php virtue/woocommerce/single-product/price.php virtue/woocommerce/single-product/product-image.php virtue/woocommerce/single-product/product-thumbnails.php virtue/woocommerce/single-product/sale-flash.php virtue/woocommerce/single-product.php virtue/woocommerce/content-product_cat.php virtue/woocommerce/taxonomy-product_cat.php virtue/woocommerce/taxonomy-product_tag.php