Bigbrotherbot not starting up..

[kev60fps]

ProgrammingError: (1064, '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 'groups WHERE keyword = "mod" LIMIT 1' at line 1')

Even tried removing the plugins that the log is telling me has some faults. Nothing works. Everything is default. So what can the issue be here?

250418 19:55:32 BOT 'www.bigbrotherbot.net (b3) v1.9.2 [nt] [PoisonIvy] [Win32 standalone]'
250418 19:55:32 BOT 'Python: 2.7.4 (default, Apr 6 2013, 19:54:46) [MSC v.1500 32 bit (Intel)]'
250418 19:55:32 BOT 'Default encoding: ascii'
250418 19:55:32 BOT 'Starting Cod2Parser v1.3.0 for server 91.159.113.176:28960'
250418 19:55:32 BOT '--------------------------------------------'
250418 19:55:32 BOT 'Attempting to connect to database mysql://b3:******@localhost/b3...'
250418 19:55:32 BOT 'Connected to database [1 times]'
250418 19:55:32 BOT 'Game log E:/TCAFiles/Users/admin/105/kev/Zom/games_mp.log'
250418 19:55:32 BOT 'Starting bot reading file E:\TCAFiles\Users\admin\105\kev\Zom\games_mp.log'
250418 19:55:32 BOT 'rcon status Cache Expire Time: [2 sec] Type: [memory]'
250418 19:55:32 BOT 'Loading Plugins (external plugin directory: E:\TCAFiles\Users\admin\105\b3\extplugins)'
250418 19:55:32 BOT 'Loading Plugin #1 censor [E:\TCAFiles\Users\admin\105\b3\conf\plugin_censor.xml]'
250418 19:55:32 BOT 'CensorPlugin: Loading config E:\TCAFiles\Users\admin\105\b3\conf\plugin_censor.xml for CensorPlugin'
250418 19:55:32 BOT 'Plugin censor (3.1 - ThorN, xlr8or, Bravo17, Courgette) loaded'
250418 19:55:32 BOT 'Loading Plugin #2 admin [E:\TCAFiles\Users\admin\105\b3\conf\plugin_admin.xml]'
250418 19:55:32 BOT 'AdminPlugin: Loading config E:\TCAFiles\Users\admin\105\b3\conf\plugin_admin.xml for AdminPlugin'
250418 19:55:32 ERROR '[SELECT * FROM groups WHERE keyword = "superadmin" LIMIT 1] None'
250418 19:55:32 ERROR 'Error loading plugin admin'
Traceback (most recent call last):
File "b3\parser.pyo", line 674, in loadPlugins
File "b3\plugin.pyo", line 56, in init
File "b3\plugin.pyo", line 115, in loadConfig
File "b3\plugins\admin.pyo", line 163, in onLoadConfig
File "b3\parser.pyo", line 895, in getGroupLevel
File "b3\decorators.pyo", line 60, in call
File "b3\parser.pyo", line 887, in getGroup
File "b3\storage\database.pyo", line 857, in getGroup
File "b3\storage\database.pyo", line 323, in query
ProgrammingError: (1064, '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 'groups WHERE keyword = "superadmin" LIMIT 1' at line 1')
250418 19:55:32 BOT 'Loading Plugin #3 stats [E:\TCAFiles\Users\admin\105\b3\conf\plugin_stats.xml]'
250418 19:55:32 BOT 'StatsPlugin: Loading config E:\TCAFiles\Users\admin\105\b3\conf\plugin_stats.xml for StatsPlugin'
250418 19:55:32 BOT 'Plugin stats (1.3.7 - ThorN, GrosBedo) loaded'
250418 19:55:32 BOT 'Loading Plugin #4 status [E:\TCAFiles\Users\admin\105\b3\conf\plugin_status.xml]'
250418 19:55:32 BOT 'StatusPlugin: Loading config E:\TCAFiles\Users\admin\105\b3\conf\plugin_status.xml for StatusPlugin'
250418 19:55:32 BOT 'Plugin status (1.4.13 - ThorN) loaded'
250418 19:55:32 BOT 'Loading Plugin #5 welcome [E:\TCAFiles\Users\admin\105\b3\conf\plugin_welcome.xml]'
250418 19:55:32 BOT 'WelcomePlugin: Loading config E:\TCAFiles\Users\admin\105\b3\conf\plugin_welcome.xml for WelcomePlugin'
250418 19:55:32 BOT 'Plugin welcome (1.1 - ThorN) loaded'
250418 19:55:32 BOT 'Loading Plugin publist'
250418 19:55:32 BOT 'PublistPlugin: No config file found for PublistPlugin. (was not required either)'
250418 19:55:32 BOT 'Plugin publist (1.10.2 - ThorN, Courgette) loaded'
250418 19:55:32 BOT 'Starting parser'
250418 19:55:32 BOT 'Client found in storage 1, welcome back World'
250418 19:55:36 BOT 'Starting plugins'
250418 19:55:36 ERROR "STDERR 'Traceback (most recent call last):\n'"
250418 19:55:36 ERROR 'STDERR ' File "b3\\init.pyo", line 182, in start\n''
250418 19:55:36 ERROR 'STDERR ' File "b3\\parser.pyo", line 520, in start\n''
250418 19:55:36 ERROR 'STDERR ' File "b3\\parser.pyo", line 780, in startPlugins\n''
250418 19:55:36 ERROR 'STDERR ' File "b3\\parser.pyo", line 770, in start_plugin\n''
250418 19:55:36 ERROR 'STDERR "KeyError: 'admin'\n"'
250418 19:55:38 BOT 'Shutting down...'
250418 19:55:38 BOT 'Shutting down database connections...'

[82ndab-Bravo17]

Its been a long time since I have used B3, but I think that means that you haven't created the tables in the database

[grb-ani]

Try using the latest version of B3 1.12. My guess is the version you're currently using doesn't include fix 9b86a68 which escapes the keyword groups for MySQL 8.

Edit, having said that, the PR was in 2019 and last official release was 2018 so you might be out of luck there. Your only option may be to use B3 from source (or older version MySQL...).