InstaPy / InstaPy

📷 Instagram Bot - Tool for automated Instagram interactions
GNU General Public License v3.0
16.84k stars 3.78k forks source link

sqlite3.IntegrityError: NOT NULL constraint failed: accountsProgress.followers #5606

Closed gdefagot closed 4 years ago

gdefagot commented 4 years ago

After I stop one execution of the bot, I started getting the following error when trying to unfollow users:

INFO [2020-07-07 08:46:19] [xxxx]  Logged in successfully!
''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''
INFO [2020-07-07 08:46:19] [xxxx]  Saving account progress...
INFO [2020-07-07 08:47:12] [xxxx]  Failed to get followers count of 'b'xxxx''  ~empty list
ERROR [2020-07-07 08:47:38] [xxxx]  message
Traceback (most recent call last):
  File "/Users/xxxx/miniconda3/envs/instabot/lib/python3.8/site-packages/instapy/util.py", line 2089, in save_account_progress
    cur.execute(sql, (id, followers, following, posts))
sqlite3.IntegrityError: NOT NULL constraint failed: accountsProgress.followers

Anyone faced this issue? How can I fix this inconsistency?

EDIT: this only happens when running with headless_browser=True

stale[bot] commented 4 years ago

This issue has been automatically marked as stale because it has not had recent activity. It will be closed if no further activity occurs. Thank you for your contributions.

If this problem still occurs, please open a new issue

sekoakb commented 1 year ago

Still occurs, regardless of headless mode.