• Resolved slalani

    (@slalani)


    I have just installed SG Security plugin on WordPress setup. After trying to visit the dashboard, I’m displayed this error

    JSON.parse: unexpected character at line 1 column 1 of the JSON data

    Screenshot: https://prnt.sc/1bdsi9h

Viewing 4 replies - 1 through 4 (of 4 total)
  • Plugin Author Stanimir Stoyanov

    (@sstoqnov)

    SiteGround Representative

    Hey @slalani

    Would it be possible to provide your site url, please?

    Regards,
    Stanimir

    Thread Starter slalani

    (@slalani)

    Hi @sstoqnov

    I restored the last backup from my Siteground dashboard and installed the plugin again, and this seems to have fixed the problem.

    I don’t know what caused the problem in the first place. But thank you for your prompt reply.

    Plugin Author Stanimir Stoyanov

    (@sstoqnov)

    SiteGround Representative

    Hey @slalani

    Please check the error_log file in your public_html folder for more details about the issue.

    Regards,
    Stanimir

    Thread Starter slalani

    (@slalani)

    Thanks @sstoqnov

    Here is a dump of the log

    [15-Jul-2021 06:39:15 UTC] WordPress database error You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ') hci_termmeta.meta_key = 'order' OR hci_termmeta.meta_key IS NULL )
    ) ORDER BY ' at line 2 for query SELECT DISTINCT t.term_id, tt.parent, tt.count, tt.taxonomy FROM hci_terms AS t  LEFT JOIN hci_termmeta ON ( t.term_id = hci_termmeta.term_id AND hci_termmeta.meta_key='order') INNER JOIN hci_term_taxonomy AS tt ON t.term_id = tt.term_id WHERE tt.taxonomy IN ('product_cat') AND ( 
      ) hci_termmeta.meta_key = 'order' OR hci_termmeta.meta_key IS NULL )
    ) ORDER BY hci_termmeta.meta_value+0 ASC, t.name ASC  made by do_action_ref_array('generate_category_lookup_table'), WP_Hook->do_action, WP_Hook->apply_filters, Automattic\WooCommerce\Admin\CategoryLookup->regenerate, get_terms, WP_Term_Query->query, WP_Term_Query->get_terms
    [15-Jul-2021 08:57:36 UTC] PHP Fatal error:  Allowed memory size of 805306368 bytes exhausted (tried to allocate 46447276840 bytes) in /home/customer/www/****.com/public_html/wp-content/plugins/woocommerce/includes/wc-core-functions.php on line 476
    [15-Jul-2021 08:57:36 UTC] PHP Fatal error:  Allowed memory size of 805306368 bytes exhausted (tried to allocate 46447276840 bytes) in /home/customer/www/****.com/public_html/wp-content/plugins/woocommerce/includes/wc-core-functions.php on line 476
    [15-Jul-2021 08:58:10 UTC] PHP Fatal error:  Allowed memory size of 805306368 bytes exhausted (tried to allocate 38743650032 bytes) in /home/customer/www/****.com/public_html/wp-content/plugins/woocommerce/includes/wc-core-functions.php on line 476
    [15-Jul-2021 08:58:13 UTC] PHP Fatal error:  Allowed memory size of 805306368 bytes exhausted (tried to allocate 46447276840 bytes) in /home/customer/www/****.com/public_html/wp-content/plugins/woocommerce/includes/wc-core-functions.php on line 476
    [15-Jul-2021 08:58:13 UTC] PHP Fatal error:  Allowed memory size of 805306368 bytes exhausted (tried to allocate 46447276840 bytes) in /home/customer/www/****.com/public_html/wp-content/plugins/woocommerce/includes/wc-core-functions.php on line 476
    [15-Jul-2021 09:00:34 UTC] PHP Fatal error:  Allowed memory size of 805306368 bytes exhausted (tried to allocate 21666586884 bytes) in /home/customer/www/****.com/public_html/wp-content/plugins/woocommerce/includes/wc-core-functions.php on line 476
    [15-Jul-2021 09:00:34 UTC] PHP Fatal error:  Allowed memory size of 805306368 bytes exhausted (tried to allocate 21666586884 bytes) in /home/customer/www/****.com/public_html/wp-content/plugins/woocommerce/includes/wc-core-functions.php on line 476
    [15-Jul-2021 09:00:34 UTC] PHP Fatal error:  Allowed memory size of 805306368 bytes exhausted (tried to allocate 21666586884 bytes) in /home/customer/www/****.com/public_html/wp-content/plugins/woocommerce/includes/wc-core-functions.php on line 476
    [15-Jul-2021 09:02:27 UTC] PHP Fatal error:  Allowed memory size of 805306368 bytes exhausted (tried to allocate 21563653636 bytes) in /home/customer/www/****.com/public_html/wp-content/plugins/woocommerce/includes/wc-core-functions.php on line 476
    [15-Jul-2021 09:10:24 UTC] PHP Fatal error:  Allowed memory size of 805306368 bytes exhausted (tried to allocate 43104389116 bytes) in /home/customer/www/****.com/public_html/wp-content/plugins/woocommerce/includes/wc-core-functions.php on line 476
    [15-Jul-2021 09:42:51 UTC] WordPress database error Deadlock found when trying to get lock; try restarting transaction for query DELETE FROM <code>hci_options</code> WHERE <code>option_name</code> = '_transient_wc_onboarding_product_data' made by require('wp-blog-header.php'), wp, WP->main, WP->parse_request, do_action_ref_array('parse_request'), WP_Hook->do_action, WP_Hook->apply_filters, rest_api_loaded, rest_get_server, do_action('rest_api_init'), WP_Hook->do_action, WP_Hook->apply_filters, Automattic\WooCommerce\Admin\API\Init->rest_api_init, Automattic\WooCommerce\Admin\API\OnboardingProfile->register_routes, Automattic\WooCommerce\Admin\API\OnboardingProfile->get_collection_params, Automattic\WooCommerce\Admin\API\OnboardingProfile::get_profile_properties, Automattic\WooCommerce\Admin\Features\Onboarding::get_allowed_product_types, Automattic\WooCommerce\Admin\Features\Onboarding::append_product_data, get_transient, delete_option
    

    Looks like the error was caused by the WooCommerce plugin? I had updated this plugin before installing the SG Security plugin.

Viewing 4 replies - 1 through 4 (of 4 total)

The topic ‘JSON.parse error’ is closed to new replies.