MySQL

Error: ER_INVALID_DEFAULT: Invalid default value for ‘expired’

This is an error caused by MySQL 5.7.27. You need to set explicit_defaults_for_timestamp=true in the file my.cnf

by REN

Error: ER_NOT_SUPPORTED_AUTH_MODE: Client does not support authentication protocol requested by server; consider upgrading MySQL client

This is an error caused by MySQL 8.0. Because MySQL 8.0 provides a new authentication plugin caching_sha2_password, however, the latest MySQL NodeJS module does not fully support the caching_sha2_password, resulting in the authentication error when connecting to the databse

For details and solution, see also: https://community.cabloy.com/articles/bc5a50636cd84ac79a49a057db53d659.html

by xujian-jh

Configuration

Error ENOSPC occured when run npm run dev:backend on Ubuntu

by sunw31

nodejs.Error: Could not execute GraphicsMagick/ImageMagick

the core module a-file provides file upload and download with the module gm. While the module gm depend on graphicsmagick or imagemagick

See Also: https://github.com/aheckmann/gm