-
Hi,
I am receiving the following database error:
WordPress database error You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ”wp_options’ WHERE ‘option_name’ LIKE ‘wp_fetch_search_console_data_ba’ at line 1 for query SELECT COUNT(*) FROM ‘wp_options’ WHERE ‘option_name’ LIKE ‘wp_fetch_search_console_data_batch_%’ made by require_once(‘wp-load.php’), require_once(‘/srv/htdocs/wp-config.php’), require_once(‘wp-settings.php’), do_action(‘init’), WP_Hook->do_action, WP_Hook->apply_filters, CMB2_Bootstrap_270->include_cmb, cmb2_bootstrap, do_action(‘cmb2_admin_init’), WP_Hook->do_action, WP_Hook->apply_filters, RankMathAdminOptions->register_option_page, include(‘/plugins/seo-by-rank-math/includes/modules/search-console/views/options.php’), RankMathSearch_ConsoleData_Fetcher->is_empty, WP_Background_Process->is_queue_empty
First seen: 2020-06-30 14:07:06 America/New_York
Last seen: 2020-07-01 12:07:08 America/New_York
Total events: 1087Can someone help with this?
-
Thank you for responding. I did as you suggested and uninstalled/reinstalled the plugin. I am still receiving database error messages. In addition to the previous error, here is another one:
WordPress database error You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ”wp_options’ WHERE ‘option_name’ LIKE ‘wp\\_fetch\\_search\\_console\\_data\\_ba’ at line 1 for query SELECT COUNT(*) FROM ‘wp_options’ WHERE ‘option_name’ LIKE ‘wp\\_fetch\\_search\\_console\\_data\\_batch\\_%’ made by require_once(‘wp-load.php’), require_once(‘/srv/htdocs/wp-config.php’), require_once(‘wp-settings.php’), do_action(‘init’), WP_Hook->do_action, WP_Hook->apply_filters, CMB2_Bootstrap_270->include_cmb, cmb2_bootstrap, do_action(‘cmb2_admin_init’), WP_Hook->do_action, WP_Hook->apply_filters, RankMath\Admin\Options->register_option_page, include(‘/plugins/seo-by-rank-math/includes/modules/search-console/views/options.php’), RankMath\Search_Console\Data_Fetcher->is_empty, WP_Background_Process->is_queue_empty
First seen: 2020-06-30 14:07:06 America/New_York
Last seen: 2020-07-02 07:21:52 America/New_York
Total events: 1880I am assuming this error occured when I opened the search console.
I am also receiving this warning concerning HubSpot: (Maybe there is a conflict between plugins)
Warning: session_start(): Cannot start session when headers already sent in /srv/htdocs/wp-content/plugins/hubspot-for-woocommerce/public/class-hubwoo-public.php on line 310
First seen: 2020-06-30 12:14:32 America/New_York
Last seen: 2020-07-02 07:24:27 America/New_York
Total events: 4245Stack Trace
———–
1. session_start()
/srv/htdocs/wp-content/plugins/hubspot-for-woocommerce/public/class-hubwoo-public.php:310
2. Hubwoo_Public->hubwoo_abncart_start_session(”)
/wordpress/core/5.4.2/wp-includes/class-wp-hook.php:287
3. WP_Hook->apply_filters(null, Array(1))
/wordpress/core/5.4.2/wp-includes/class-wp-hook.php:311
4. WP_Hook->do_action(Array(1))
/wordpress/core/5.4.2/wp-includes/plugin.php:478
5. do_action(‘init’)
/wordpress/core/5.4.2/wp-settings.php:540
6. require_once(‘/wordpress/core/5.4.2/…’)
/srv/htdocs/wp-config.php:85
7. require_once(‘/srv/htdocs/wp-config.php’)
/wordpress/core/5.4.2/wp-load.php:42
8. require_once(‘/wordpress/core/5.4.2/…’)
/wordpress/core/5.4.2/wp-cron.php:44Context
——-
URL : /wp-cron.php?doing_wp_cron=1593689066.6226179599761962890625
Referer : https://thebarkacademy.com/wp-cron.php?doing_wp_cron=1593689066.6226179599761962890625
HTTP Method : POST
HTTP Host : thebarkacademy.com
HTTP Status : 200
isSSL : Yes
Current Filter : init
Execution Time : 0.631 s
Memory Usage : 72.87 MiB
PHP SAPI : fpm-fcgiHello,
Thank you for contacting Rank Math and sorry for any inconvenience that might have been caused due to that.
Assuming you are using the latest version of all the plugins and the themes (please update if not yet), it would seem like a conflict with one of the plugins or the theme you are using.
To determine that, please follow this troubleshooting guide:
https://rankmath.com/kb/check-plugin-conflicts/Only the site admin would know and your users won’t be affected by this troubleshooting.
Please let us know if you find the culprit, else we might need to take a closer look at the settings. Please edit the first post on this ticket and include your WP logins plus a sccreencast(using http://www.loom.com) to reproduce the issue in the designated Sensitive Data section.
It is completely secure and only our support staff has access to that section. If you want, you can use the below plugin to generate a temporary login URL to your website and share that with us instead:
https://wordpress.org/plugins/temporary-login-without-password/
You can use the above plugin in conjunction with the WP Security Audit Log to monitor what changes our staff might make on your website (if any):
https://wordpress.org/plugins/wp-security-audit-log/
We really look forward to helping you.
The ticket ‘Database Error’ is closed to new replies.