MagicMirror Forum
    • Recent
    • Tags
    • Unsolved
    • Solved
    • MagicMirror² Repository
    • Documentation
    • 3rd-Party-Modules
    • Donate
    • Discord
    • Register
    • Login
    A New Chapter for MagicMirror: The Community Takes the Lead
    Read the statement by Michael Teeuw here.

    v2.18.0 update gave black screen, then nothing.

    Scheduled Pinned Locked Moved Solved Troubleshooting
    73 Posts 4 Posters 30.9k Views 4 Watching
    Loading More Posts
    • Oldest to Newest
    • Newest to Oldest
    • Most Votes
    Reply
    • Reply as topic
    Log in to reply
    This topic has been deleted. Only users with topic management privileges can see it.
    • R Offline
      Richard238 @mumblebaj
      last edited by

      @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 $
      mumblebajM 1 Reply Last reply Reply Quote 0
      • mumblebajM Offline
        mumblebaj Module Developer @Richard238
        last edited by

        @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.

        Check out my modules at: https://github.com/mumblebaj?tab=repositories
        Check my blog-post: https://mumblebaj.xyz/

        R 1 Reply Last reply Reply Quote -1
        • R Offline
          Richard238 @mumblebaj
          last edited by

          @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 $
          mumblebajM 1 Reply Last reply Reply Quote 0
          • mumblebajM Offline
            mumblebaj Module Developer @Richard238
            last edited by

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

            node -v
npm -v

            Check out my modules at: https://github.com/mumblebaj?tab=repositories
            Check my blog-post: https://mumblebaj.xyz/

            R 1 Reply Last reply Reply Quote 0
            • R Offline
              Richard238 @mumblebaj
              last edited by

              @mumblebaj

               $ node -v     v10.24.1
 $ npm -v      7.24.2
              mumblebajM 1 Reply Last reply Reply Quote 0
              • mumblebajM Offline
                mumblebaj Module Developer @Richard238
                last edited by

                @richard238 You want to update both first.

                Check out my modules at: https://github.com/mumblebaj?tab=repositories
                Check my blog-post: https://mumblebaj.xyz/

                R 1 Reply Last reply Reply Quote 0
                • R Offline
                  Richard238 @mumblebaj
                  last edited by

                  @mumblebaj

                  Great ok, thank you.

                  What’s the best way to do those two updates, please?

                  mumblebajM 1 Reply Last reply Reply Quote 0
                  • mumblebajM Offline
                    mumblebaj Module Developer @Richard238
                    last edited by

                    @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.

                    Check out my modules at: https://github.com/mumblebaj?tab=repositories
                    Check my blog-post: https://mumblebaj.xyz/

                    R 1 Reply Last reply Reply Quote 0
                    • R Offline
                      Richard238 @mumblebaj
                      last edited by

                      @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
                      R 1 Reply Last reply Reply Quote 0
                      • R Offline
                        Richard238 @Richard238
                        last edited by

                        @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 $
                        mumblebajM 1 Reply Last reply Reply Quote 0
                        • 1
                        • 2
                        • 3
                        • 4
                        • 5
                        • 6
                        • 7
                        • 8
                        • 2 / 8
                        • First post
                          Last post
                        Enjoying MagicMirror? Please consider a donation!
                        MagicMirror created by Michael Teeuw.
                        Forum managed by Sam, technical setup by Karsten.
                        This forum is using NodeBB as its core | Contributors
                        Contact | Privacy Policy