i need help setting up my discord bot
i need someone to help me configure the database [ i am extremely new to this ]
29 Replies
Project ID:
23662a0f-52b0-4ee2-a28b-416c37c66f3123662a0f-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 thatI 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 isi 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
Getting Started | Nixpacks
App source + Nix packages + Docker = Image
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 filei 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 columnThe 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 buildingOkay, 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