search

tomaarsen / TwitchMarkovChain

Twitch Bot for generating messages based on what it learned from chat
MIT License
118 stars 25 forks source link

no such table: MarkovStartA Error #21

Closed Rainerr123 closed 3 years ago

Rainerr123 commented 3 years ago

after installing requirements and generating the settings.json.

sudo python3 MarkovChainBot.py [2021-10-10 16:35:36,001] [Database] [INFO ] - Updating Database to new version - supports better punctuation handling. [2021-10-10 16:35:36,003] [Database] [INFO ] - Created a copy of the database called "MarkovChain__modified.db". The update will modify this file. Traceback (most recent call last): File "MarkovChainBot.py", line 570, in MarkovChain() File "MarkovChainBot.py", line 30, in init self.db = Database(self.chan) File "/home/rainer/TwitchMarkovChain/Database.py", line 96, in init self.update_v3(channel) File "/home/rainer/TwitchMarkovChain/Database.py", line 411, in update_v3 modify_start(table) File "/home/rainer/TwitchMarkovChain/Database.py", line 331, in modify_start data = self.execute(f"SELECT * FROM {table};", fetch=True) File "/home/rainer/TwitchMarkovChain/Database.py", line 516, in execute cur.execute(sql) sqlite3.OperationalError: no such table: MarkovStartA

tomaarsen commented 3 years ago

Hello! This looks a lot like #20, perhaps the comments there will help you out? If not, let me know.

Also, are you using a fresh installation without having used the bot in the past? Or did you run this previously, and then updated?

Rainerr123 commented 3 years ago

Thanks tom! the fix from that worked perfectly, thanks for the help :)