v2.18.0 update gave black screen, then nothing.

mumblebaj

@richard238 You want to update both first.

Richard238

Great ok, thank you.

What’s the best way to do those two updates, please?

mumblebaj

@richard238 Just google update npm and update node. Once those are updated then you can do the rest. Uninstall mysql and run npm install in the MMM-MysqlQuery folder. Hopefully that will resolve the issues.

Richard238

@mumblebaj

Ok, step one completed and looking much more up-to-date:

pi@magicmirror:~ $ npm -v
8.3.0
pi@magicmirror:~ $ node -v
v17.3.0

Richard238

@richard238

And step two:

pi@magicmirror:~/MagicMirror $ npm uninstall mysql

up to date, audited 758 packages in 10s

66 packages are looking for funding
  run `npm fund` for details

found 0 vulnerabilities

pi@magicmirror:~/MagicMirror $ cd modules/MMM-MysqlQuery
pi@magicmirror:~/MagicMirror/modules/MMM-MysqlQuery $ npm install
npm ERR! code ERESOLVE
npm ERR! ERESOLVE unable to resolve dependency tree
npm ERR! 
npm ERR! While resolving: mmm-mysqlquery@1.0.0
npm ERR! Found: stylelint@8.4.0
npm ERR! node_modules/stylelint
npm ERR!   dev stylelint@"^8.3.0" from the root project
npm ERR! 
npm ERR! Could not resolve dependency:
npm ERR! peer stylelint@"^14.0.0" from grunt-stylelint@0.17.0
npm ERR! node_modules/grunt-stylelint
npm ERR!   dev grunt-stylelint@"latest" from the root project
npm ERR! 
npm ERR! Fix the upstream dependency conflict, or retry
npm ERR! this command with --force, or --legacy-peer-deps
npm ERR! to accept an incorrect (and potentially broken) dependency resolution.
npm ERR! 
npm ERR! See /home/pi/.npm/eresolve-report.txt for a full report.

npm ERR! A complete log of this run can be found in:
npm ERR!     /home/pi/.npm/_logs/2022-01-06T12_51_27_088Z-debug-0.log
pi@magicmirror:~/MagicMirror/modules/MMM-MysqlQuery $

mumblebaj

@richard238 can you check if package-lock.json exist. if it does delete it rm package-lock.json then try again. Also, did you do the uninstall in the MagicMirror folder first?

Richard238

@mumblebaj

did you do the uninstall in the MagicMirror folder first?
Yes, I did.

pi@magicmirror:~ $ sudo rm package-lock.json
pi@magicmirror:~ $ cd ~/MagicMirror
pi@magicmirror:~/MagicMirror $ cd modules/MMM-MysqlQuery
pi@magicmirror:~/MagicMirror/modules/MMM-MysqlQuery $ npm install
npm ERR! code ERESOLVE
npm ERR! ERESOLVE unable to resolve dependency tree
npm ERR! 
npm ERR! While resolving: mmm-mysqlquery@1.0.0
npm ERR! Found: stylelint@8.4.0
npm ERR! node_modules/stylelint
npm ERR!   dev stylelint@"^8.3.0" from the root project
npm ERR! 
npm ERR! Could not resolve dependency:
npm ERR! peer stylelint@"^14.0.0" from grunt-stylelint@0.17.0
npm ERR! node_modules/grunt-stylelint
npm ERR!   dev grunt-stylelint@"latest" from the root project
npm ERR! 
npm ERR! Fix the upstream dependency conflict, or retry
npm ERR! this command with --force, or --legacy-peer-deps
npm ERR! to accept an incorrect (and potentially broken) dependency resolution.
npm ERR! 
npm ERR! See /home/pi/.npm/eresolve-report.txt for a full report.

npm ERR! A complete log of this run can be found in:
npm ERR!     /home/pi/.npm/_logs/2022-01-06T13_37_32_112Z-debug-0.log
pi@magicmirror:~/MagicMirror/modules/MMM-MysqlQuery $

mumblebaj

@richard238 seems like styleint is giving issues, Can you just try and install mysql and see if that resolves your issue?

Richard238

@mumblebaj

Install mysql - how and where?

Apologies for the detail request, but having got this far, I don’t want to break anything else.

Thank you.

mumblebaj

@richard238 In the MMM-MysqlQuery folder, npm i mysql