v2.18.0 update gave black screen, then nothing.

[mumblebaj]

@richard238 Have a look at the below post. It might solve some of your issues.

https://forum.magicmirror.builders/topic/15778/fix-for-black-screen-in-2-16-and-later

[mumblebaj]

@richard238 said in v2.18.0 update gave black screen, then nothing.:

0|MagicMir | [06.01.2022 08:34.09.653] [ERROR] App threw an error during load
0|MagicMir | [06.01.2022 08:34.09.658] [ERROR] Error: Cannot find module ‘mysql’

Your error!

[Richard238]

@mumblebaj

Yes, that’s what I spotted, then I did

pi@magicmirror:~/MagicMirror $ npm install mysql

[mumblebaj]

@richard238 No, You need to do the following:

cd ~.MagicMirror/modules/MMM-MysqlQuery
npm init -y
npm install mysql --save

There may be other missing modules.

[Richard238]

@mumblebaj

pi@magicmirror:~ $ cd ~/MagicMirror/modules/MMM-MysqlQuery
pi@magicmirror:~/MagicMirror/modules/MMM-MysqlQuery $ npm init -y
Wrote to /home/pi/MagicMirror/modules/MMM-MysqlQuery/package.json:

{
  "name": "mmm-mysqlquery",
  "version": "1.0.0",
  "description": "MagicMirror module to display result of MySQL query",
  "license": "MIT",
  "main": "MMM-MysqlQuery.js",
  "scripts": {
    "test": "./node_modules/grunt/bin/grunt"
  },
  "author": "Rich Alberth",
  "repository": {
    "type": "git",
    "url": "git+https://github.com/ralberth/MMM-MysqlQuery.git"
  },
  "keywords": [
    "MagicMirror",
    "module",
    "mysql"
  ],
  "dependencies": {
    "mysql": "latest",
    "npm": "^6.4.1"
  },
  "devDependencies": {
    "grunt": "latest",
    "grunt-eslint": "latest",
    "grunt-jsonlint": "latest",
    "grunt-markdownlint": "^1.0.13",
    "grunt-stylelint": "latest",
    "grunt-yamllint": "^0.3.0",
    "stylelint": "^8.3.0",
    "stylelint-config-standard": "latest",
    "time-grunt": "latest",
    "electron-rebuild": "^1.8.2"
  },
  "bugs": {
    "url": "https://github.com/ralberth/MMM-MysqlQuery/issues"
  },
  "homepage": "https://github.com/ralberth/MMM-MysqlQuery#readme"
}


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

[mumblebaj]

@richard238 I think you installed the latest version in the MagicMirror folder whereas the MysqlQuery wants version 6.4.1. Go to the root of MagicMirror and run npm uninstall mysql. Once that is done then cd modules/MMM-MysqlQuery. Then just run npm install in the folder. It should then install the dependencies that it require.

[Richard238]

@mumblebaj

pi@magicmirror:~/MagicMirror $ npm uninstall mysql
npm WARN EBADENGINE Unsupported engine { package: 'magicmirror@2.18.0',
npm WARN EBADENGINE   required: { node: '>=12' },
npm WARN EBADENGINE   current: { node: 'v10.24.1', npm: '7.24.2' } }
npm WARN EBADENGINE Unsupported engine { package: '@es-joy/jsdoccomment@0.13.0',
npm WARN EBADENGINE   required: { node: '^12 || ^14 || ^16 || ^17' },
npm WARN EBADENGINE   current: { node: 'v10.24.1', npm: '7.24.2' } }
npm WARN EBADENGINE Unsupported engine { package: '@eslint/eslintrc@1.0.5',
npm WARN EBADENGINE   required: { node: '^12.22.0 || ^14.17.0 || >=16.0.0' },
npm WARN EBADENGINE   current: { node: 'v10.24.1', npm: '7.24.2' } }
npm WARN EBADENGINE Unsupported engine { package: '@typescript-eslint/experimental-utils@5.8.0',
npm WARN EBADENGINE   required: { node: '^12.22.0 || ^14.17.0 || >=16.0.0' },
npm WARN EBADENGINE   current: { node: 'v10.24.1', npm: '7.24.2' } }
npm WARN EBADENGINE Unsupported engine { package: '@typescript-eslint/scope-manager@5.8.0',
npm WARN EBADENGINE   required: { node: '^12.22.0 || ^14.17.0 || >=16.0.0' },
npm WARN EBADENGINE   current: { node: 'v10.24.1', npm: '7.24.2' } }
npm WARN EBADENGINE Unsupported engine { package: '@typescript-eslint/types@5.8.0',
npm WARN EBADENGINE   required: { node: '^12.22.0 || ^14.17.0 || >=16.0.0' },
npm WARN EBADENGINE   current: { node: 'v10.24.1', npm: '7.24.2' } }
npm WARN EBADENGINE Unsupported engine { package: '@typescript-eslint/typescript-estree@5.8.0',
npm WARN EBADENGINE   required: { node: '^12.22.0 || ^14.17.0 || >=16.0.0' },
npm WARN EBADENGINE   current: { node: 'v10.24.1', npm: '7.24.2' } }
npm WARN EBADENGINE Unsupported engine { package: '@typescript-eslint/visitor-keys@5.8.0',
npm WARN EBADENGINE   required: { node: '^12.22.0 || ^14.17.0 || >=16.0.0' },
npm WARN EBADENGINE   current: { node: 'v10.24.1', npm: '7.24.2' } }
npm WARN EBADENGINE Unsupported engine { package: 'commander@8.3.0',
npm WARN EBADENGINE   required: { node: '>= 12' },
npm WARN EBADENGINE   current: { node: 'v10.24.1', npm: '7.24.2' } }
npm WARN EBADENGINE Unsupported engine { package: 'comment-parser@1.3.0',
npm WARN EBADENGINE   required: { node: '>= 12.0.0' },
npm WARN EBADENGINE   current: { node: 'v10.24.1', npm: '7.24.2' } }
npm WARN EBADENGINE Unsupported engine { package: 'data-urls@3.0.1',
npm WARN EBADENGINE   required: { node: '>=12' },
npm WARN EBADENGINE   current: { node: 'v10.24.1', npm: '7.24.2' } }
npm WARN EBADENGINE Unsupported engine { package: 'domexception@4.0.0',
npm WARN EBADENGINE   required: { node: '>=12' },
npm WARN EBADENGINE   current: { node: 'v10.24.1', npm: '7.24.2' } }
npm WARN EBADENGINE Unsupported engine { package: 'eslint@8.5.0',
npm WARN EBADENGINE   required: { node: '^12.22.0 || ^14.17.0 || >=16.0.0' },
npm WARN EBADENGINE   current: { node: 'v10.24.1', npm: '7.24.2' } }
npm WARN EBADENGINE Unsupported engine { package: 'eslint-plugin-jest@25.3.0',
npm WARN EBADENGINE   required: { node: '^12.13.0 || ^14.15.0 || >=16.0.0' },
npm WARN EBADENGINE   current: { node: 'v10.24.1', npm: '7.24.2' } }
npm WARN EBADENGINE Unsupported engine { package: 'eslint-plugin-jsdoc@37.4.0',
npm WARN EBADENGINE   required: { node: '^12 || ^14 || ^16 || ^17' },
npm WARN EBADENGINE   current: { node: 'v10.24.1', npm: '7.24.2' } }
npm WARN EBADENGINE Unsupported engine { package: 'eslint-scope@7.1.0',
npm WARN EBADENGINE   required: { node: '^12.22.0 || ^14.17.0 || >=16.0.0' },
npm WARN EBADENGINE   current: { node: 'v10.24.1', npm: '7.24.2' } }
npm WARN EBADENGINE Unsupported engine { package: 'eslint-visitor-keys@3.1.0',
npm WARN EBADENGINE   required: { node: '^12.22.0 || ^14.17.0 || >=16.0.0' },
npm WARN EBADENGINE   current: { node: 'v10.24.1', npm: '7.24.2' } }
npm WARN EBADENGINE Unsupported engine { package: 'espree@9.2.0',
npm WARN EBADENGINE   required: { node: '^12.22.0 || ^14.17.0 || >=16.0.0' },
npm WARN EBADENGINE   current: { node: 'v10.24.1', npm: '7.24.2' } }
npm WARN EBADENGINE Unsupported engine { package: 'html-encoding-sniffer@3.0.0',
npm WARN EBADENGINE   required: { node: '>=12' },
npm WARN EBADENGINE   current: { node: 'v10.24.1', npm: '7.24.2' } }
npm WARN EBADENGINE Unsupported engine { package: 'husky@7.0.4',
npm WARN EBADENGINE   required: { node: '>=12' },
npm WARN EBADENGINE   current: { node: 'v10.24.1', npm: '7.24.2' } }
npm WARN EBADENGINE Unsupported engine { package: 'jsdoc-type-pratt-parser@2.0.0',
npm WARN EBADENGINE   required: { node: '>=12.0.0' },
npm WARN EBADENGINE   current: { node: 'v10.24.1', npm: '7.24.2' } }
npm WARN EBADENGINE Unsupported engine { package: 'jsdom@19.0.0',
npm WARN EBADENGINE   required: { node: '>=12' },
npm WARN EBADENGINE   current: { node: 'v10.24.1', npm: '7.24.2' } }
npm WARN EBADENGINE Unsupported engine { package: 'playwright@1.17.1',
npm WARN EBADENGINE   required: { node: '>=12' },
npm WARN EBADENGINE   current: { node: 'v10.24.1', npm: '7.24.2' } }
npm WARN EBADENGINE Unsupported engine { package: 'playwright-core@1.17.1',
npm WARN EBADENGINE   required: { node: '>=12' },
npm WARN EBADENGINE   current: { node: 'v10.24.1', npm: '7.24.2' } }
npm WARN EBADENGINE Unsupported engine { package: 'postcss-safe-parser@6.0.0',
npm WARN EBADENGINE   required: { node: '>=12.0' },
npm WARN EBADENGINE   current: { node: 'v10.24.1', npm: '7.24.2' } }
npm WARN EBADENGINE Unsupported engine { package: 'stylelint@14.2.0',
npm WARN EBADENGINE   required: { node: '^12.20.0 || ^14.13.1 || >=16.0.0' },
npm WARN EBADENGINE   current: { node: 'v10.24.1', npm: '7.24.2' } }
npm WARN EBADENGINE Unsupported engine { package: 'stylelint-config-prettier@9.0.3',
npm WARN EBADENGINE   required: { node: '>= 12' },
npm WARN EBADENGINE   current: { node: 'v10.24.1', npm: '7.24.2' } }
npm WARN EBADENGINE Unsupported engine { package: 'stylelint-prettier@2.0.0',
npm WARN EBADENGINE   required: { node: '^12.22.0 || ^14.17.0 || >=16.0.0' },
npm WARN EBADENGINE   current: { node: 'v10.24.1', npm: '7.24.2' } }
npm WARN EBADENGINE Unsupported engine { package: 'tr46@3.0.0',
npm WARN EBADENGINE   required: { node: '>=12' },
npm WARN EBADENGINE   current: { node: 'v10.24.1', npm: '7.24.2' } }
npm WARN EBADENGINE Unsupported engine { package: 'w3c-xmlserializer@3.0.0',
npm WARN EBADENGINE   required: { node: '>=12' },
npm WARN EBADENGINE   current: { node: 'v10.24.1', npm: '7.24.2' } }
npm WARN EBADENGINE Unsupported engine { package: 'webidl-conversions@7.0.0',
npm WARN EBADENGINE   required: { node: '>=12' },
npm WARN EBADENGINE   current: { node: 'v10.24.1', npm: '7.24.2' } }
npm WARN EBADENGINE Unsupported engine { package: 'whatwg-encoding@2.0.0',
npm WARN EBADENGINE   required: { node: '>=12' },
npm WARN EBADENGINE   current: { node: 'v10.24.1', npm: '7.24.2' } }
npm WARN EBADENGINE Unsupported engine { package: 'whatwg-mimetype@3.0.0',
npm WARN EBADENGINE   required: { node: '>=12' },
npm WARN EBADENGINE   current: { node: 'v10.24.1', npm: '7.24.2' } }
npm WARN EBADENGINE Unsupported engine { package: 'whatwg-url@10.0.0',
npm WARN EBADENGINE   required: { node: '>=12' },
npm WARN EBADENGINE   current: { node: 'v10.24.1', npm: '7.24.2' } }
npm WARN EBADENGINE Unsupported engine { package: 'xml-name-validator@4.0.0',
npm WARN EBADENGINE   required: { node: '>=12' },
npm WARN EBADENGINE   current: { node: 'v10.24.1', npm: '7.24.2' } }

removed 4 packages, and audited 758 packages in 14s

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_07_55_731Z-debug.log
pi@magicmirror:~/MagicMirror/modules/MMM-MysqlQuery $ 

[mumblebaj]

@richard238 It seems your versions of npm and node might be older than the required versions. run the following

node -v
npm -v

[Richard238]

@mumblebaj

 $ node -v     v10.24.1
 $ npm -v      7.24.2

[mumblebaj]

@richard238 You want to update both first.