Tamarah Comments - Answer Overflow

funny enough... it wasn't there but when I tested it again today, I got an error that was asking for driver. So I added the driver which led to this new error.

7 replies

DTDrizzle Team

•Created by Tamarah on 10/23/2024 in #help

Migration generation error

Oh okay, I re-read this reply and i get now. Thank you so much

32 replies

DTDrizzle Team

•Created by Tamarah on 10/23/2024 in #help

Migration generation error

thank you so much

32 replies

DTDrizzle Team

•Created by Tamarah on 10/23/2024 in #help

Migration generation error

It is hard to believe that my adding driver to the drizzle.config.js file was the main issue. I adjusted the code to my actual project and it generated

32 replies

DTDrizzle Team

•Created by Tamarah on 10/23/2024 in #help

Migration generation error

oh okay... I am using node v20.14.0... so could it matter?

32 replies

DTDrizzle Team

•Created by Tamarah on 10/23/2024 in #help

Migration generation error

i will check

32 replies

DTDrizzle Team

•Created by Tamarah on 10/23/2024 in #help

Migration generation error

okay let me check it out

32 replies

DTDrizzle Team

•Created by Tamarah on 10/23/2024 in #help

Migration generation error

wait, you used mysql database... made no changes to the db connection file or the drizzle.config.js file and it worked

32 replies

DTDrizzle Team

•Created by Tamarah on 10/23/2024 in #help

Migration generation error

I am more inclined to agree with your last reply because it seems to be complaining about the driver

32 replies

DTDrizzle Team

•Created by Tamarah on 10/23/2024 in #help

Migration generation error

so I am currently using the single client connection and from what I have gathered so far online, I thought maybe the connection could have been the reason for the new error I stated that I got today

32 replies

DTDrizzle Team

•Created by Tamarah on 10/23/2024 in #help

Migration generation error

oh okay, i was asking because the drizzle documentation suggests

 For the built in migrate function with DDL migrations we and drivers strongly encourage you to use single client connection.

 For the built in migrate function with DDL migrations we and drivers strongly encourage you to use single client connection.

32 replies

DTDrizzle Team

•Created by Tamarah on 10/23/2024 in #help

Migration generation error

also, if I may ask, how do you close a connection to the database after each database query. I got this error today:

 Can't add new command when connection is in closed state

 Can't add new command when connection is in closed state

32 replies

DTDrizzle Team

•Created by Tamarah on 10/23/2024 in #help

Migration generation error

this is the link to the repo: https://github.com/7amarah/drizzle-orm-with-mysql.git

32 replies

DTDrizzle Team

•Created by Tamarah on 10/23/2024 in #help

Migration generation error

Okay, no problem

32 replies

DTDrizzle Team

•Created by Tamarah on 10/23/2024 in #help

Migration generation error

okay... so the current code i have is in a private repo because it is for work. So maybe , what i will do is create a personal use case project and then share the code with you.

32 replies

DTDrizzle Team

•Created by Tamarah on 10/23/2024 in #help

Migration generation error

Hi @Luxaritas , so I had assistance from a friend that makes use of an older version of the drizzle-orm and the drizzle-kit that suggested I downgrade to the version he uses just to test. I made use of

"drizzle-orm": "^0.30.10",
"drizzle-kit": "^0.21.1"

"drizzle-orm": "^0.30.10",
"drizzle-kit": "^0.21.1"

as suggested, then attempted generation and migration without changing anything else in my code and it worked, which makes me wonder if it is a version issue. So is it possible that either I need to update code somewhere to accommodate the latest versions of the drizzle-orm and drizzle-kit and I don't know how to do it or the latest versions might have unexpected issue not reported yet?

32 replies

DTDrizzle Team

•Created by Tamarah on 10/23/2024 in #help

Migration generation error

yes... the generate command is what is giving the error without generating the migrations folder

32 replies

Gaming

Programming