v2.18.0 update gave black screen, then nothing.

mumblebaj

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

Richard238

pi@magicmirror:~/MagicMirror/modules/MMM-MysqlQuery $ npm i mysql
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-06T14_02_53_804Z-debug-0.log
pi@magicmirror:~/MagicMirror/modules/MMM-MysqlQuery $

mumblebaj

@richard238 run npm i mysql --force The stylint is a dev dependency.

Richard238

@mumblebaj

Looking better…

pi@magicmirror:~/MagicMirror/modules/MMM-MysqlQuery $ npm i mysql --force
npm WARN using --force Recommended protections disabled.
npm WARN ERESOLVE overriding peer dependency
npm WARN While resolving: grunt-stylelint@0.17.0
npm WARN Found: stylelint@8.4.0
npm WARN node_modules/stylelint
npm WARN   dev stylelint@"^8.3.0" from the root project
npm WARN 
npm WARN Could not resolve dependency:
npm WARN peer stylelint@"^14.0.0" from grunt-stylelint@0.17.0
npm WARN node_modules/grunt-stylelint
npm WARN   dev grunt-stylelint@"latest" from the root project
npm WARN 
npm WARN Conflicting peer dependency: stylelint@14.2.0
npm WARN node_modules/stylelint
npm WARN   peer stylelint@"^14.0.0" from grunt-stylelint@0.17.0
npm WARN   node_modules/grunt-stylelint
npm WARN     dev grunt-stylelint@"latest" from the root project
npm WARN ERESOLVE overriding peer dependency
npm WARN While resolving: stylelint-config-standard@24.0.0
npm WARN Found: stylelint@8.4.0
npm WARN node_modules/stylelint
npm WARN   dev stylelint@"^8.3.0" from the root project
npm WARN 
npm WARN Could not resolve dependency:
npm WARN peer stylelint@"^14.0.0" from stylelint-config-standard@24.0.0
npm WARN node_modules/stylelint-config-standard
npm WARN   dev stylelint-config-standard@"latest" from the root project
npm WARN 
npm WARN Conflicting peer dependency: stylelint@14.2.0
npm WARN node_modules/stylelint
npm WARN   peer stylelint@"^14.0.0" from stylelint-config-standard@24.0.0
npm WARN   node_modules/stylelint-config-standard
npm WARN     dev stylelint-config-standard@"latest" from the root project
npm WARN ERESOLVE overriding peer dependency
npm WARN deprecated time-grunt@2.0.0: Deprecated because Grunt is practically unmaintained. Move on to something better. This package will continue to work with Grunt v1, but it will not receive any updates.
npm WARN deprecated har-validator@5.1.5: this library is no longer supported
npm WARN deprecated browserslist@2.11.3: Browserslist 2 could fail on reading Browserslist >3.0 config used in other tools.
npm WARN deprecated circular-json@0.3.3: CircularJSON is in maintenance only, flatted is its successor.
npm WARN deprecated uuid@3.4.0: Please upgrade  to version 7 or higher.  Older versions may use Math.random() in certain circumstances, which is known to be problematic.  See https://v8.dev/blog/math-random for details.
npm WARN deprecated request@2.88.2: request has been deprecated, see https://github.com/request/request/issues/3142

added 606 packages, and audited 1043 packages in 3m

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

29 vulnerabilities (1 low, 17 moderate, 11 high)

To address issues that do not require attention, run:
  npm audit fix

To address all issues (including breaking changes), run:
  npm audit fix --force

Run `npm audit` for details.
pi@magicmirror:~/MagicMirror/modules/MMM-MysqlQuery $

sdetweil

@mumblebaj why my install script does npm install --only=prod
to remove the dev dependencies

mumblebaj

@sdetweil :thumbs_up:

Richard238

What are “dev dependencies” to the uninitiated?

sdetweil

@richard238 there are dependencies

things needed to RUN

and dev dependencies,

things needed to DEVELOP for existing or new function

things like syntax checkers, format checkers, test cases, … 99% of users don’t need that stuff on their disc

in the package.json are two lists of dependencies
“devDependencies”: {
“dependencies”: {

unless u specify only runtime (production) , you get both …

Richard238

Still no MM though. Status says online, but it’s not launching MM.
I’ll reboot, because, why not…

pi@magicmirror:~/MagicMirror $ pm2 start MagicMirror
[PM2] Applying action restartProcessId on app [MagicMirror](ids: [ 0 ])
[PM2] [MagicMirror](0) ✓
[PM2] Process successfully started
┌────┬────────────────────┬──────────┬──────┬───────────┬──────────┬──────────┐
│ id │ name               │ mode     │ ↺    │ status    │ cpu      │ memory   │
├────┼────────────────────┼──────────┼──────┼───────────┼──────────┼──────────┤
│ 0  │ MagicMirror        │ fork     │ 0    │ online    │ 0%       │ 2.6mb    │
└────┴────────────────────┴──────────┴──────┴───────────┴──────────┴──────────┘
pi@magicmirror:~/MagicMirror $

sdetweil

@richard238 no reboot…

just pm2 stop 0
pm2 flush
pm2 start 0

then pm2 logs --line=50