You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
Hello! Having issues with the setup, it looks like the channel crawler is trying to reference a value from the un-initialized channels table?
The only channel that populates is 'users', the subsequent SQL insertions all fail due to the tables not being initialized correctly. Is there a setup step I missed?
Log:
[INFO] statbot.event: Initializing SQL lookup tables...
[INFO] statbot.event: Processing X users...
[INFO] statbot.event: Processing X guilds...
[INFO] statbot.event:
[INFO] statbot.event: Ready!
[INFO] statbot.sql: Looking up channel crawl progress for {server} #{channel}
[INFO] statbot.sql: Inserting new channel crawl progress for {server} #{channel}
[ERROR] statbot.sql: Exception occurred in 'with' scope!
Traceback (most recent call last):
File ".../python3.9/site-packages/sqlalchemy/engine/base.py", line 1819, in _execute_context
self.dialect.do_execute(
File ".../python3.9/site-packages/sqlalchemy/engine/default.py", line 732, in do_execute
cursor.execute(statement, parameters)
psycopg2.errors.ForeignKeyViolation: insert or update on table "channel_crawl" violates foreign key constraint "channel_crawl_channel_id_fkey"
DETAIL: Key (channel_id)=(1002...) is not present in table "channels".
The text was updated successfully, but these errors were encountered:
In case somebody runs into this same issue, a few things:
-> First, drop the psql DB, if you've already run the initialization script.
-> Second, comment out any mention of voice_region in the code (deprecated)
-> Third, I also needed to change for guild in set(self.guilds) & set(self.config["guild-ids"]): (Line 171 in client.py)
to: for guild in set(self.guilds):
-> Then I just repeat the psql setup, ran the bot command, and it ran perfectly
Happy to submit a PR to get statbot to work with modern discord.py, if this project is still maintained. :)
Hello! Having issues with the setup, it looks like the channel crawler is trying to reference a value from the un-initialized channels table?
The only channel that populates is 'users', the subsequent SQL insertions all fail due to the tables not being initialized correctly. Is there a setup step I missed?
Log:
The text was updated successfully, but these errors were encountered: