{"id":17020775,"date":"2023-09-02T14:44:36","date_gmt":"2023-09-02T14:44:36","guid":{"rendered":"https:\/\/wordpress.org\/support\/?post_type=topic&p=17020775"},"modified":"2023-09-02T15:07:14","modified_gmt":"2023-09-02T15:07:14","slug":"database-error-391","status":"publish","type":"topic","link":"https:\/\/wordpress.org\/support\/topic\/database-error-391\/","title":{"rendered":"database error"},"content":{"rendered":"\n

Hi, I’m getting this in my error WP logs. I’m at the most recent version.<\/p>\n\n\n\n

Date: [02-Sep-2023 11:19:33 UTC]
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 ‘WHERE id = ‘3875’ LIMIT 1′ at line 5 for query UPDATE wpmi_sbb_blacklist<\/code><\/p>\n\n\n\n

        WHERE id = '3875' LIMIT 1 made by require('wp-blog-header.php'), require_once('wp-load.php'), require_once('wp-config.php'), require_once('wp-settings.php'), include_once('\/plugins\/stopbadbots\/stopbadbots.php'), sbb_complete_bot_data\n\n        botflag = '2', \n\n        botip = '103.131.71.182', \n\n        SET botua = '\\\"Mozilla\\\\\/5.0 (compatible; coccocbot-web\\\\\/1.0; +http:\\\\\/\\\\\/help.coccoc.com\\\\\/searchengine)\\\"', <\/code><\/pre>\n\n\n\n
=== Begin System Info (Generated 2023-09-02 14:42:02) ===<\/p>\n\n\n\n
— Plugin<\/p>\n\n\n\n
Name: stopbadbots
Version: 9.09<\/p>\n\n\n\n
— Site Info<\/p>\n\n\n\n
Site URL: https:\/\/junctioncreek.com
Home URL: https:\/\/junctioncreek.com
Multisite: No<\/p>\n\n\n\n
— Hosting Provider<\/p>\n\n\n\n
Host: langelier.whc.ca<\/p>\n\n\n\n
— User Browser<\/p>\n\n\n\n
Mozilla\/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit\/537.36 (KHTML, like Gecko) Chrome\/116.0.0.0 Safari\/537.36<\/p>\n\n\n\n
— WordPress Configuration<\/p>\n\n\n\n
Version: 6.3.1
Language: en_US
Permalink Structure: \/%postname%\/
Active Theme: Weaver Xtreme 6.3.0
ABSPATH: \/home\/junction\/public_html\/
Plugin Dir: \/home\/junction\/public_html\/wp-content\/plugins\/stopbadbots\/
Table Prefix: Length: 5 Status: Acceptable
EnabledMemory Limit: 128M<\/p>\n\n\n\n
— WordPress Active Theme<\/p>\n\n\n\n
Theme Name: Weaver Xtreme 6.3.0<\/p>\n\n\n\n
— Must-Use Plugins<\/p>\n\n\n\n
ManageWP – Worker Loader:<\/p>\n\n\n\n
— WordPress Active Plugins<\/p>\n\n\n\n
Classic Editor: 1.6.3
https:\/\/wordpress.org\/plugins\/classic-editor\/<\/p>\n\n\n\n
Events Manager: 6.4.5.1
https:\/\/wp-events-plugin.com<\/p>\n\n\n\n
Heartbeat Control by WP Rocket: 2.0.1
https:\/\/wordpress.org\/plugins\/heartbeat-control\/<\/p>\n\n\n\n
ManageWP – Worker: 4.9.17
https:\/\/managewp.com<\/p>\n\n\n\n
Ninja Forms: 3.6.29
http:\/\/ninjaforms.com\/?utm_source=Ninja+Forms+Plugin&utm_medium=readme<\/p>\n\n\n\n
Page Builder by SiteOrigin: 2.25.3
https:\/\/siteorigin.com\/page-builder\/<\/p>\n\n\n\n
Pretty Links: 3.5.2
https:\/\/prettylinks.com\/pl\/plugin-uri<\/p>\n\n\n\n
Site Kit by Google: 1.108.0
https:\/\/sitekit.withgoogle.com<\/p>\n\n\n\n
SiteOrigin Widgets Bundle: 1.54.0
https:\/\/siteorigin.com\/widgets-bundle\/<\/p>\n\n\n\n
StopBadBots: 9.09
http:\/\/stopbadbots.com<\/p>\n\n\n\n
The Post Grid: 7.2.9
https:\/\/www.radiustheme.com\/downloads\/the-post-grid-pro-for-wordpress\/<\/p>\n\n\n\n
The SEO Framework: 4.2.8
https:\/\/theseoframework.com\/<\/p>\n\n\n\n
Weaver Xtreme Theme Support: 6.3.1
http:\/\/weavertheme.com\/plugins<\/p>\n\n\n\n
Wordfence Security: 7.10.3
http:\/\/www.wordfence.com\/<\/p>\n\n\n\n
WP Crontrol: 1.15.3
https:\/\/wordpress.org\/plugins\/wp-crontrol\/<\/p>\n\n\n\n
Yoast Duplicate Post: 4.5
https:\/\/yoast.com\/wordpress\/plugins\/duplicate-post\/<\/p>\n\n\n\n
— WordPress Inactive Plugins<\/p>\n\n\n\n
LiteSpeed Cache: 5.6
https:\/\/www.litespeedtech.com\/products\/cache-plugins\/wordpress-acceleration<\/p>\n\n\n\n
— Webserver Configuration<\/p>\n\n\n\n
OS Type & Version: PHP Version: 7.4.33
MySQL Version: 10.3.39
Webserver Info: LiteSpeed<\/p>\n\n\n\n
— PHP Configuration<\/p>\n\n\n\n
Memory Limit: 512M
Upload Max Size: 64M
Post Max Size: 64M
Upload Max Filesize: 64M
Time Limit: 60
Max Input Vars: 1000
Display Errors: N\/A<\/p>\n\n\n\n
— PHP Extensions<\/p>\n\n\n\n
cURL: Supported
fsockopen: Supported
SOAP Client: Installed
Suhosin: Not Installed<\/p>\n\n\n\n
=== End System Info ===<\/p>\n\n\n\n


<\/p>\n","protected":false},"template":"","class_list":["post-17020775","topic","type-topic","status-publish","hentry"],"jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/wordpress.org\/support\/wp-json\/wp\/v2\/topic\/17020775","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/wordpress.org\/support\/wp-json\/wp\/v2\/topic"}],"about":[{"href":"https:\/\/wordpress.org\/support\/wp-json\/wp\/v2\/types\/topic"}],"version-history":[{"count":1,"href":"https:\/\/wordpress.org\/support\/wp-json\/wp\/v2\/topic\/17020775\/revisions"}],"predecessor-version":[{"id":17020804,"href":"https:\/\/wordpress.org\/support\/wp-json\/wp\/v2\/topic\/17020775\/revisions\/17020804"}],"wp:attachment":[{"href":"https:\/\/wordpress.org\/support\/wp-json\/wp\/v2\/media?parent=17020775"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}