Node version issue in x-press publishing

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

5 Likes

Yeah same problem here. Please fix this.

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???

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.

7 Likes

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

look here :wink:

1 Like

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.

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

This seems to have worked for me. Thank you.

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

Awesome! Thanks this solution works for me.