Read the statement by Michael Teeuw here.
v2.18.0 update gave black screen, then nothing.
-
@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 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 -
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 vulnerabilitiespi@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 $ -
@richard238 can you check if package-lock.json exist. if it does delete it
rm package-lock.jsonthen try again. Also, did you do the uninstall in the MagicMirror folder first? -
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 $ -
@richard238 seems like styleint is giving issues, Can you just try and install mysql and see if that resolves your issue?
-
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.
-
@richard238 In the MMM-MysqlQuery folder,
npm i mysql -
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 $ -
@richard238 run
npm i mysql --forceThe stylint is a dev dependency.
Hello! It looks like you're interested in this conversation, but you don't have an account yet.
Getting fed up of having to scroll through the same posts each visit? When you register for an account, you'll always come back to exactly where you were before, and choose to be notified of new replies (either via email, or push notification). You'll also be able to save bookmarks and upvote posts to show your appreciation to other community members.
With your input, this post could be even better 💗
Register Login