Node version issue in x-press publishing

jeremydmarx · January 10, 2020, 6:29am

This has been addressed in another thread I’ve commented on, but I think in general, some of the xpress-publishing project needs to be run in an earlier version of node (8.9.3). It took me a lot of research, including looking through the codecademy forums, but i had to install nvm, switch to node version 8, and only then could i npm install sqlite3, the migration.js file ran, the table was created and i can now read it in my db browser, and the npm test command worked. Maybe this needs to be addressed in the project files?
J

soringabriellupu02 · January 13, 2020, 7:37pm

Yeah same problem here. Please fix this.

soringabriellupu02 · January 13, 2020, 7:57pm

I took your advice and tried using both node versions 8 and 9 to install sqlite3 but I still get the same error. CODECADEMY WHERE ARE YOU???

michaelbarreto460776 · January 14, 2020, 7:02pm

This worked for me, its an npm package that has a lot of support features including bundling slqite3 versions as a fallbacks if there are comparability issues.

In the terminal type: npm install https://github.com/mapbox/node-sqlite3/tarball/master

I haven’t found any issues so far with using it but, I would create a git branch before installing it in case it does cause issues or if codecademy finds a better solution.

adolfoomarcalderonco · February 15, 2020, 5:43pm

Hello man, I still have the problem. I tried using this solution but sqlite3 is still not working and I don’t know how to fix this issue

_31337 · May 1, 2020, 8:40pm

look here

core0641261537 · May 5, 2020, 11:49pm

I struggled with this same problem because nvm does not work for windows, since it is specifically designed for linux, so using nvm will not work if you are using a windows system. However, there is another program that is similar to nvm that is compatible with windows produced by coreybutler. Here is the link https://github.com/coreybutler/nvm-windows. If you download this and use version 8.0.0, you should be able to install ‘sqlite3’ and all other dependencies.

hypercoder457 · June 27, 2020, 8:45pm

Hey! I found a solution. I found out that you need to run the command npm install sqlite3 --unsafe-perm(maybe?!) and then upgrade your dependencies in package.json. You have to change the sqlite-3 version to 4.2.0

j_hom · July 4, 2020, 11:25pm

This seems to have worked for me. Thank you.

chrisandrew_dev · August 13, 2020, 5:53pm

Try the following:

In a bash terminal, type npm outdated and enter to list deprecated packages
Then, type npx npm-check-updates -u and enter to update all packages
Finally, type npm install to complete the updates and update the package.json file

vianeymmx · December 28, 2020, 6:01pm

Awesome! Thanks this solution works for me.