MySQL Connection not available. | Railway | Page 1

lavish yoke Apr 20, 2023, 2:31 PM

#

this error wasn't showing up much but lately it started getting a bit more and usually restarting the bot solves the problem but I want it not to appear at all

ruby hearthBOT Apr 20, 2023, 2:31 PM

#

Project ID: bd35da20-981f-49ac-8333-eb8c89c3acbd

lavish yoke Apr 20, 2023, 2:32 PM

#

bd35da20-981f-49ac-8333-eb8c89c3acbd

fossil quiver Apr 20, 2023, 3:26 PM

#

what are your database connection settings?

lavish yoke Apr 23, 2023, 2:02 AM

#

what do you mean by database connection settings ?

lavish yoke Apr 24, 2023, 2:31 PM

#

i mean i cant find it

#

is this ?

fossil quiver Apr 24, 2023, 4:31 PM

#

show me a screenshot of the service variables please

lavish yoke Apr 25, 2023, 8:00 PM

#

#

sorry for the late reply btw

fossil quiver Apr 25, 2023, 8:26 PM

#

you should be using variable references, please read this
https://docs.railway.app/develop/variables#reference-variables

once you have that setup, come back and show me another screenshot please

lavish yoke Apr 27, 2023, 2:34 PM

#

is it okay now ?

fossil quiver Apr 27, 2023, 2:36 PM

#

yes

lavish yoke Apr 27, 2023, 2:40 PM

#

okay thank you very much 🙏

fossil quiver Apr 27, 2023, 2:40 PM

#

no problem

clear osprey Apr 27, 2023, 5:37 PM

#

Likely cause: you're prematurely closing the connection in your code. Make sure the connection is available for the cursor you created. Check all of your .close() statements, especially on con

#MySQL Connection not available.