offside db postgresql

[geeks121]

i tried offside db using postgresql from bit.io but nothing happened

[davidjameshowell]

Could you provide more details on the issue you are facing and what you have done thus far to help troubleshoot?

[geeks121]

i tried with heroku verified : 0
using postgresql from bit.io and the setting above not triggered to use offside DB . as i read the readme ,, to use offside db i should set heroku verified to 0 right? ..

and if i set
heroku verified : 0
use_psql : 0
the bot will setup without any database

i setup db connection in secrets github ..

[ncomerci]

HEROKU_VERIFIED variable is hardcoded in deploy.yml and update.yml, simple fix here

[davidjameshowell]

The only real reason it is hard coded is any value that is listed in secret becomes redacted in logs, which subsequently means anything with a "1" becomes an asterisk. Can make debugging a pain.

[ncomerci]

Yes, I get your point but I ran into the same problem mentioned here when I did my deploy and I solved it this way so I could change it quickly. I think it would be good to clarify this issue in the readme because I think it is not very clear 🙌🏻😉

[aditya-shri]

Yes, I get your point but I ran into the same problem mentioned here when I did my deploy and I solved it this way so I could change it quickly. I think it would be good to clarify this issue in the readme because I think it is not very clear 🙌🏻wink

Hi bro, I used the bit.io database but after deployment heroku is giving following error:

2022-04-14 20:09:39.204][panic][ERROR] thread 'main' panicked at 'Failed to disable Foreign Key Checks during migrations: DatabaseError(__Unknown, "QueryParsingError: Unsupported command: SET CONSTRAINTS ALL DEFERRED\nvalidate_unsupported_cmd")': src/db/mod.rs:449

If I use Heroku Postgres it works but for bitio,it doesn't works.
Any suggestion?