Migration error when deployed with Docker

[EmetDuncan]

I have tried to run my own instance of the bot using Docker, but I unfortunately am unable to get it working. Not sure what exactly is prompting only deny_allow_lists_guilds to fail. The bot goes online but the only command it can use is the /about command.

bot-1 | Waiting for database...................
bot-1 | Database ready
bot-1 | /usr/local/venv/lib/python3.13/site-packages/cleo/parser.py:147: DeprecationWarning: 'maxsplit' is passed as positional argument
bot-1 | matches = re.split(r"\s*|\s*", token, 2)
bot-1 | Migrating: 2023_11_17_092808_guilds_table
bot-1 | Migrated: 2023_11_17_092808_guilds_table (0.07s)
bot-1 | Migrating: 2023_11_17_094206_text_channels_table
bot-1 | Migrated: 2023_11_17_094206_text_channels_table (0.16s)
bot-1 | Migrating: 2023_11_19_180926_import_json
bot-1 | Migrated: 2023_11_19_180926_import_json (0.00s)
bot-1 | Migrating: 2024_06_19_182807_guild_settings
bot-1 | Migrated: 2024_06_19_182807_guild_settings (0.25s)
bot-1 | Migrating: 2024_06_22_154629_channels_enabled
bot-1 | Migrated: 2024_06_22_154629_channels_enabled (0.08s)
bot-1 | Migrating: 2024_06_22_155714_websites_option
bot-1 | Migrated: 2024_06_22_155714_websites_option (0.16s)
bot-1 | Migrating: 2024_06_24_175057_members_table
bot-1 | Migrated: 2024_06_24_175057_members_table (0.15s)
bot-1 | Migrating: 2024_06_25_131246_custom_websites_table
bot-1 | Migrated: 2024_06_25_131246_custom_websites_table (0.14s)
bot-1 | Migrating: 2024_08_29_005648_default_states
bot-1 | Migrated: 2024_08_29_005648_default_states (0.16s)
bot-1 | Migrating: 2024_08_30_133515_roles_table
bot-1 | Migrated: 2024_08_30_133515_roles_table (0.13s)
bot-1 | Migrating: 2024_08_30_143125_default_role_state
bot-1 | Migrated: 2024_08_30_143125_default_role_state (0.15s)
bot-1 | Migrating: 2024_09_02_143111_websites_and_views
bot-1 | Migrated: 2024_09_02_143111_websites_and_views (0.16s)
bot-1 | Migrating: 2024_11_02_214523_remove_instagram_view
bot-1 | Migrated: 2024_11_02_214523_remove_instagram_view (0.15s)
bot-1 | Migrating: 2024_11_02_220821_add_bluesky_view
bot-1 | Migrated: 2024_11_02_220821_add_bluesky_view (0.14s)
bot-1 | Migrating: 2025_01_06_222619_new_bluesky_view
bot-1 | Migrated: 2025_01_06_222619_new_bluesky_view (0.05s)
bot-1 | Migrating: 2025_01_11_221023_add_snapchat
bot-1 | Migrated: 2025_01_11_221023_add_snapchat (0.14s)
bot-1 | Migrating: 2025_01_26_140544_refacto_members
bot-1 | Migrated: 2025_01_26_140544_refacto_members (0.53s)
bot-1 | Migrating: 2025_01_26_223431_add_more_websites
bot-1 | Migrated: 2025_01_26_223431_add_more_websites (0.15s)
bot-1 | Migrating: 2025_03_16_145300_add_twitch_spotify
bot-1 | Migrated: 2025_03_16_145300_add_twitch_spotify (0.15s)
bot-1 | Migrating: 2025_03_16_211708_create_events
bot-1 | Migrated: 2025_03_16_211708_create_events (0.06s)
bot-1 | Migrating: 2025_03_16_234024_add_bot_members
bot-1 | Migrated: 2025_03_16_234024_add_bot_members (0.19s)
bot-1 | Migrating: 2025_03_18_133740_add_webhook_support
bot-1 | Migrated: 2025_03_18_133740_add_webhook_support (0.15s)
bot-1 | Migrating: 2025_06_03_021604_add_silent_replies
bot-1 | Migrated: 2025_06_03_021604_add_silent_replies (0.22s)
bot-1 | Migrating: 2025_06_08_104941_deny_allow_lists_guilds
bot-1 |
bot-1 | QueryException
bot-1 |
bot-1 | (1101, "BLOB, TEXT, GEOMETRY or JSON column 'keywords' can't have a default value")
bot-1 |
bot-1 | at /usr/local/venv/lib/python3.13/site-packages/masoniteorm/connections/MySQLConnection.py:226 in query
bot-1 | 222│ return self.format_cursor_results(cursor.fetchone())
bot-1 | 223│ else:
bot-1 | 224│ return self.format_cursor_results(cursor.fetchall())
bot-1 | 225│ except Exception as e:
bot-1 | → 226│ raise QueryException(str(e)) from e
bot-1 | 227│ finally:
bot-1 | 228│ self._cursor.close()
bot-1 | 229│ if self.get_transaction_level() <= 0:
bot-1 | 230│ self.open = 0
bot-1 | Migration failed but continuing...
bot-1 | [11/10/2025 22:08:28] [INFO] discore.bot Bot initialising... discore v0.11, discord.py v2.5.2
bot-1 | [11/10/2025 22:08:28] [WARNING] discord.client PyNaCl is not installed, voice will NOT be supported
bot-1 | [11/10/2025 22:08:28] [INFO] cogs.setup [ACTIVITY] Starting custom activity
bot-1 | [11/10/2025 22:08:28] [WARNING] cogs.setup [TOP.GG] config.topgg_token not set, autopost disabled
bot-1 | [11/10/2025 22:08:28] [INFO] discore.bot Cogs successfully loaded: 'LinkFix', 'Commands', 'Developer', 'Setup'
bot-1 | [11/10/2025 22:08:28] [INFO] discord.client logging in using static token
bot-1 | [11/10/2025 22:08:29] [WARNING] cogs.setup config.dev_guild not set, skipping dev commands sync
bot-1 | [11/10/2025 22:08:29] [WARNING] cogs.setup config.sku not set, premium features unavailable
bot-1 | [11/10/2025 22:08:29] [INFO] discore.bot Slash commands successfully synced: 'settings', 'about'
bot-1 | /usr/local/venv/lib/python3.13/site-packages/discord/http.py:554: DeprecationWarning: parameter 'timeout' of type 'float' is deprecated, please use 'timeout=ClientWSTimeout(ws_close=...)'
bot-1 | return await self.__session.ws_connect(url, **kwargs)
bot-1 | [11/10/2025 22:08:29] [INFO] discord.gateway Shard ID 0 has connected to Gateway (Session ID: ).
bot-1 | [11/10/2025 22:08:29] [INFO] discore.bot Connected to Discord as 'FixTweetBot' (id : ) ver. 3.3.2
bot-1 | [11/10/2025 22:08:33] [INFO] discore.bot Bot launched in 4.652s, ready to use (prefix '!')

[daffychuy]

As a temporary work around, I made a change in https://github.com/Kyrela/FixTweetBot/blob/e678ab54f1da2680c30f28b900c9a43856989640/database/migrations/2025_06_08_104941_deny_allow_lists_guilds.py#L12C13-L12C81
to be table.json("keywords").nullable().after("id")

At least allows me to use it for now, but settings will pretty much be broken, good enough for now until their internet is back.

[EmetDuncan]

Awesome update! Thanks for sharing this fix!

[Kyrela]

Sorry for the late reply, is the latest version fixing the issue for you? You will need to delete the db volume to try it

[EmetDuncan]

Deleted everything and started clean. Still having issues with the latest repo:

bot-1 | Waiting for database...................
bot-1 | Database ready
bot-1 | /usr/local/venv/lib/python3.14/site-packages/cleo/parser.py:147: DeprecationWarning: 'maxsplit' is passed as positional argument
bot-1 | matches = re.split(r"\s*|\s*", token, 2)
bot-1 | Migrating: 2023_11_17_092808_guilds_table
bot-1 | Migrated: 2023_11_17_092808_guilds_table (0.07s)
bot-1 | Migrating: 2023_11_17_094206_text_channels_table
bot-1 | Migrated: 2023_11_17_094206_text_channels_table (0.14s)
bot-1 | Migrating: 2023_11_19_180926_import_json
bot-1 | Migrated: 2023_11_19_180926_import_json (0.00s)
bot-1 | Migrating: 2024_06_19_182807_guild_settings
bot-1 | Migrated: 2024_06_19_182807_guild_settings (0.16s)
bot-1 | Migrating: 2024_06_22_154629_channels_enabled
bot-1 | Migrated: 2024_06_22_154629_channels_enabled (0.08s)
bot-1 | Migrating: 2024_06_22_155714_websites_option
bot-1 | Migrated: 2024_06_22_155714_websites_option (0.15s)
bot-1 | Migrating: 2024_06_24_175057_members_table
bot-1 | Migrated: 2024_06_24_175057_members_table (0.17s)
bot-1 | Migrating: 2024_06_25_131246_custom_websites_table
bot-1 | Migrated: 2024_06_25_131246_custom_websites_table (0.21s)
bot-1 | Migrating: 2024_08_29_005648_default_states
bot-1 | Migrated: 2024_08_29_005648_default_states (0.16s)
bot-1 | Migrating: 2024_08_30_133515_roles_table
bot-1 | Migrated: 2024_08_30_133515_roles_table (0.15s)
bot-1 | Migrating: 2024_08_30_143125_default_role_state
bot-1 | Migrated: 2024_08_30_143125_default_role_state (0.15s)
bot-1 | Migrating: 2024_09_02_143111_websites_and_views
bot-1 | Migrated: 2024_09_02_143111_websites_and_views (0.17s)
bot-1 | Migrating: 2024_11_02_214523_remove_instagram_view
bot-1 | Migrated: 2024_11_02_214523_remove_instagram_view (0.15s)
bot-1 | Migrating: 2024_11_02_220821_add_bluesky_view
bot-1 | Migrated: 2024_11_02_220821_add_bluesky_view (0.15s)
bot-1 | Migrating: 2025_01_06_222619_new_bluesky_view
bot-1 | Migrated: 2025_01_06_222619_new_bluesky_view (0.05s)
bot-1 | Migrating: 2025_01_11_221023_add_snapchat
bot-1 | Migrated: 2025_01_11_221023_add_snapchat (0.15s)
bot-1 | Migrating: 2025_01_26_140544_refacto_members
bot-1 | Migrated: 2025_01_26_140544_refacto_members (0.60s)
bot-1 | Migrating: 2025_01_26_223431_add_more_websites
bot-1 | Migrated: 2025_01_26_223431_add_more_websites (0.16s)
bot-1 | Migrating: 2025_03_16_145300_add_twitch_spotify
bot-1 | Migrated: 2025_03_16_145300_add_twitch_spotify (0.15s)
bot-1 | Migrating: 2025_03_16_211708_create_events
bot-1 | Migrated: 2025_03_16_211708_create_events (0.07s)
bot-1 | Migrating: 2025_03_16_234024_add_bot_members
bot-1 | Migrated: 2025_03_16_234024_add_bot_members (0.20s)
bot-1 | Migrating: 2025_03_18_133740_add_webhook_support
bot-1 | Migrated: 2025_03_18_133740_add_webhook_support (0.16s)
bot-1 | Migrating: 2025_06_03_021604_add_silent_replies
bot-1 | Migrated: 2025_06_03_021604_add_silent_replies (0.23s)
bot-1 | Migrating: 2025_06_08_104941_deny_allow_lists_guilds
bot-1 |
bot-1 | QueryException
bot-1 |
bot-1 | (1101, "BLOB, TEXT, GEOMETRY or JSON column 'keywords' can't have a default value")
bot-1 |
bot-1 | at /usr/local/venv/lib/python3.14/site-packages/masoniteorm/connections/MySQLConnection.py:227 in query
bot-1 | 223│ return self.format_cursor_results(cursor.fetchone())
bot-1 | 224│ else:
bot-1 | 225│ return self.format_cursor_results(cursor.fetchall())
bot-1 | 226│ except Exception as e:
bot-1 | → 227│ raise QueryException(str(e)) from e
bot-1 | 228│ finally:
bot-1 | 229│ self._cursor.close()
bot-1 | 230│ if self.get_transaction_level() <= 0:
bot-1 | 231│ self.open = 0
bot-1 | Migration failed but continuing...
bot-1 | [09/11/2025 21:26:38] [INFO] discore.bot Bot initialising... discore v0.11, discord.py v2.5.2
bot-1 | /usr/local/venv/lib/python3.14/site-packages/discord/ext/commands/core.py:398: DeprecationWarning: 'asyncio.iscoroutinefunction' is deprecated and slated for removal in Python 3.16; use inspect.iscoroutinefunction() instead
bot-1 | if not asyncio.iscoroutinefunction(func):
bot-1 | [09/11/2025 21:26:38] [WARNING] discord.client PyNaCl is not installed, voice will NOT be supported
bot-1 | /usr/local/venv/lib/python3.14/site-packages/discord/ext/commands/bot.py:646: DeprecationWarning: 'asyncio.iscoroutinefunction' is deprecated and slated for removal in Python 3.16; use inspect.iscoroutinefunction() instead
bot-1 | if not asyncio.iscoroutinefunction(func):
bot-1 | [09/11/2025 21:26:38] [INFO] cogs.setup [ACTIVITY] Starting custom activity
bot-1 | [09/11/2025 21:26:38] [WARNING] cogs.setup [TOP.GG] config.topgg_token not set, autopost disabled
bot-1 | /usr/local/venv/lib/python3.14/site-packages/discord/ext/commands/bot.py:646: DeprecationWarning: 'asyncio.iscoroutinefunction' is deprecated and slated for removal in Python 3.16; use inspect.iscoroutinefunction() instead
bot-1 | if not asyncio.iscoroutinefunction(func):
bot-1 | [09/11/2025 21:26:38] [INFO] discore.bot Cogs successfully loaded: 'LinkFix', 'Commands', 'Developer', 'Setup'
bot-1 | [09/11/2025 21:26:38] [INFO] discord.client logging in using static token
bot-1 | [09/11/2025 21:26:39] [WARNING] cogs.setup config.dev_guild not set, skipping dev commands sync
bot-1 | [09/11/2025 21:26:39] [WARNING] cogs.setup config.sku not set, premium features unavailable
bot-1 | [09/11/2025 21:26:39] [INFO] discore.bot Slash commands successfully synced: 'settings', 'about'
bot-1 | /usr/local/venv/lib/python3.14/site-packages/discord/http.py:554: DeprecationWarning: parameter 'timeout' of type 'float' is deprecated, please use 'timeout=ClientWSTimeout(ws_close=...)'
bot-1 | return await self.__session.ws_connect(url, **kwargs)
bot-1 | [09/11/2025 21:26:39] [INFO] discord.gateway Shard ID 0 has connected to Gateway (Session ID: ).
bot-1 | [09/11/2025 21:26:39] [INFO] discore.bot Connected to Discord as 'FixTweetBot' (id : ) ver. 3.3.2
bot-1 | [09/11/2025 21:26:41] [INFO] discore.bot Bot launched in 3.185s, ready to use (prefix '!')

[Kyrela]

Please forgive my dumb brain. I updated the docker compose example to use mariadb instead of mysql (better, lighter). Can you please update your docker compose to follow this change? Again, with the deleted db volume.

[EmetDuncan]

Updated compose to MariaDB and now it finally works. Thank you for the fix!