A New Chapter for MagicMirror: The Community Takes the Lead
Read the statement by Michael Teeuw here.
Read the statement by Michael Teeuw here.
v2.18.0 update gave black screen, then nothing.
-
@richard238 No, You need to do the following:
cd ~.MagicMirror/modules/MMM-MysqlQuery npm init -y npm install mysql --saveThere may be other missing modules.
-
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 $ -
@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 thencd modules/MMM-MysqlQuery. Then just run npm install in the folder. It should then install the dependencies that it require. -
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 $ -
@richard238 It seems your versions of npm and node might be older than the required versions. run the following
node -v npm -v -
$ node -v v10.24.1 $ npm -v 7.24.2 -
@richard238 You want to update both first.
-
-
@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.
-
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
