v2.18.0 update gave black screen, then nothing.

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.

Richard238

@mumblebaj

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?