Forum Replies Created

Viewing 5 replies - 31 through 35 (of 35 total)
  • Thread Starter Ian

    (@ipgill)

    Thank you. This has fixed the error.

    Thread Starter Ian

    (@ipgill)

    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
    Thread Starter Ian

    (@ipgill)

    Thank you.

    I managed to fix it by manually running the query in SQL.

    Thread Starter Ian

    (@ipgill)

    Here 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
    Thread Starter Ian

    (@ipgill)

    Thank 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
    
    
Viewing 5 replies - 31 through 35 (of 35 total)