ERROR: "Please install sqlite3 package manually" when I execute "sequelize db:migrate"

Question

I'm trying to create a sample app, using this article:

https://arjunphp.com/restful-api-using-async-await-node-express-sequelize/

But when a try to execute database migration with sequenze-cli on sqlite, a have always the same error:

C:\WORKING\todo\todos-manager>sequelize db:migrate

Sequelize CLI [Node: 10.16.0, CLI: 5.5.0, ORM: 5.8.12]

Loaded configuration file "config\config.json".
Using environment "development".

ERROR: Please install sqlite3 package manually

I've already tried to rebuild, with no success.

Any ideas?

You have to install `sqlite3` package additionally, as said in the error message. Run `npm install sqlite3 --save`. — Anna Tolochko, Jul 09 '19 at 11:22
Strange. Have you tried completely removing the `node_modules` directory and running fresh `npm install`? — Anna Tolochko, Jul 10 '19 at 12:28

score 1 · Answer 1 · answered Jul 12 '19 at 07:28

1

UPDATE:

the error does not occur if I use the statement:

npx sequelize-cli db:migrate

instead of

sequelize db:migrate

and migration completes successful!

I hope it's useful to someone.

Thanks to all!

answered Jul 12 '19 at 07:28

elena

123
1
11

This worked for me too, no idea why though. So annoying – Amon Apr 11 '20 at 04:16

score 1 · Answer 2 · answered Jul 12 '19 at 07:51

1

First install sequelize-cli globally

sudo npm install -g sequelize-cli

Then use the following command to execute migrations.

sequelize db:migrate

answered Jul 12 '19 at 07:51

Abdullah Masood

11
3

score 1 · Answer 3 · answered Sep 16 '20 at 17:52

1

Might be bit late but writing this for since there is no accepted answer yet :)

I tried with Node10.x , your installed sqlite3 version might not be matching with Node-version, so please switch your version to Node8.x or 9.x.

Use NVM to switch between versions and try avoid installing packages globally.

answered Sep 16 '20 at 17:52

Mohamed Niyaz Sirajudeen

149
1
15

thanks for the answers, can you show which commands you ran? – Chris Sep 16 '20 at 21:09
Install nvm and type this command : nvm install 8. Node8 version will get installed, then do nvm list which will show the list of node versions installed in your system. To use specific version, do nvm use . After switching to Node8 version , I did npm install and it worked for me. – Mohamed Niyaz Sirajudeen Sep 17 '20 at 11:04

score 0 · Answer 4 · answered Apr 24 '20 at 17:40

0

in my case both:
npx sequelize-cli db:migrate
and
sequelize db:migrate
didn't work.
I don't know if its a bad practice but only global installation:
npm i -g sqlite3
solve the issue for me

answered Apr 24 '20 at 17:40

Eden Sharvit

765
11
14

score 0 · Answer 5 · answered May 19 '20 at 20:26

0

In my case sqllite3 was not installed due to node version mismatch . I switched my node version to v9.11.1 and the error is gone afterwards.

answered May 19 '20 at 20:26

Shravan Hebbar

199
1
7

Elliott de Launay · Answer 6 · 2021-12-14T22:46:55.170

0

Setting unsafe-perm worked for me:

npm i --unsafe-perm

edited Dec 14 '21 at 22:46

answered Dec 14 '21 at 22:24

Elliott de Launay

1,027
13
31

score 0 · Answer 7 · answered May 15 '22 at 14:31

0

If your down here without a fix, it might be possible you have npm postinstall scripts disabled like me. For me the fix was to:

cd project
cd node_modules/sqlite3
npm install
cd ../../
npx sequelize-cli db:migrate

And now it works

answered May 15 '22 at 14:31

Gavin

632
8
10

score 0 · Answer 8 · answered Sep 02 '23 at 21:38

0

If you have still not been able to get it to work at this stage then run this in the project folder:

npm update

npx sequelize-cli db:migrate

answered Sep 02 '23 at 21:38

LComingHome

91
2
8

ERROR: "Please install sqlite3 package manually" when I execute "sequelize db:migrate"

8 Answers8