i need help setting up my discord bot

i need someone to help me configure the database [ i am extremely new to this ]

23662a0f-52b0-4ee2-a28b-416c37c66f31

What language?
What library?
What type of database?

bot language is nodejs
MySQL

Did you create your MySQL service next to your bot on your dashboard, and did you add the reference variable for your database to your bot service?

i created a discord bot using the Discord bot builder app on steam, i want to deploy it on railway, but before that i need to setup a database and then link it to my bot, im having trouble on how to do that

I have never used Discord Bot Builder, so I am not 100% sure how it works as far as hosting it
At the very least, you will need to create the MySQL database, and connect it to the bot service using reference variables. Then you will reference the database variables with process.env.DATABASE_URL or whatever the name of the variable is

i deployed my github repo
and there is a deployment error
==============

Using Nixpacks

==============


context: 7db1cc06ab0b89e3ad4fbbb0923c9d23

Nixpacks build failed





Nixpacks was unable to generate a build plan for this app.

Please check the documentation for supported languages: https://nixpacks.com



The contents of the app directory are:



.gitattributes

Can you share the GitHub repo?

sure
whats ur github username ?
its a private repo , ill add u to the collaborator

vfehring

invited you

You are getting a deploy error because there is nothing in your repository

wait what ?
i pushed the files to my repo

All I see in the repo you added me to is a .gitattributes file

i pushed the files again
some error occured
mb
the bot started
i wanted to setup the databse now
and i have 0 knowledge on sql
I wanted to know if i wanted to store the memberid [discord] in one of my tables what should i enter in the type column and in the constraints column

The discord api treats ids as strings in lost libraries
Also, does this bot play music?

no

Okay, I only ask because I saw things regarding current track

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'rank text' at line 1 im getting this error on adding the column
its a block in the software im using
if i want to i can add that feature but it has no utility in the bot im building

Okay, I only ask because music bots are not allowed on the service

yea sure i wont add that nw

I don’t see how you would even connect to a database with this code. There is no connection variable to set for the database that I can find

can i screenshare and show what im building ? as i have connected the database inside the files of the bot

Give me about 10 minutes and I can jump into polar express with you and try and help you figure it out

sure
@Vin you there
?

Be there in just a minute. Got tied up with something

nw