UNIQUE constraint failed: twitter_token error at the account renewal when Squawker opens.

j-fbriere commented 3 months ago

Checklist

[X] I am able to reproduce the bug with the latest version.
[X] I made sure that there are no existing issues - open or closed - which I could contribute my information to.
[X] I have taken the time to fill in all the required details. I understand that the bug report will be dismissed otherwise.
[X] This issue contains only one bug, that only occurs in Squawker

Affected version

3.7.6

Steps to reproduce the bug

Open Squawker
If applicable, enter the account renewal code that is asked
the error appears

Expected behavior

When I open Squawker I get a message to "enter auth key sent to your e-mail", once I get the code and enter it, there is no error and the feed shows the tweets.

Actual behavior

When I open Squawker I get a message to "enter auth key sent to your e-mail", once I get the code and enter it, I get this error:

DatabaseException(UNIQUE constraint failed: twitter_token.oauth_token (code 1555 SQLITE_CONSTRAINT_PRIMARYKEY)) sql 'INSERT INTO twitter_token (guest, id_str, screen_name, oauth_token, oauth_token_secret, created_at) VALUES (?, ?, ?, ?, ?, ?)' args [0, 272595305, [twitter_account], 272595305-ayiR8qzr2fuWGtZvNtVpJnGsCUh0MMB7ocFK7nVw, EcxzlpE41SnoX6W3uEvSRVZ8XWeQqyFUSAuLwV8MZqLF8, 2024-03-11T05:57:26.203662]

Screenshots/Screen recordings

No response

Logs

No response

Affected Android/Custom ROM version

No response

Affected device model

No response

Additional information

No response

j-fbriere commented 3 months ago

Version v3.7.7 fixes this issue.

DUOLabs333 commented 3 months ago

I still have this issue, even with version 3.7.8.

j-fbriere commented 3 months ago

Does it happens when you open Squawker?
Can you show your screen with the error message?
Can you go in the settings after that, or Squawker is not usable at that point?

DUOLabs333 commented 3 months ago

It seems like it happens intermittently, so I can't reliably reproduce the issue. It only happens when I open a Twitter post in Squawker (through the Share menu).

j-fbriere commented 3 months ago

Next time this happens please take a snapshot of the screen and post it here so that I can see the exact error message. Thank you.

moocow1452 commented 3 months ago

Had this, logged in on Chrome and it seemed to go away?

DUOLabs333 commented 2 months ago

I got it, and was able to screenshot it this time.

j-fbriere commented 2 months ago

Version v3.8.1 should fix it.

DUOLabs333 commented 2 months ago

I just installed the new version --- the error seems to have been resolved. Thanks!

j-fbriere / squawker