MySQL


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

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


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

by sunw31

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

CMS相关


1. Once installed, CMS plugins are automatically included. How to disable a plugin?

Set enable: false in Site Configuration or Language Configuration. For example, to disable the plugin cms-plugintrack, you can configure it as follows:

{
  "host": {
    "url": "http://example.com",
    "rootPath": ""
  },
  "language": {
    "default": "zh-cn",
    "items": "zh-cn,en-us"
  },
  "themes": {
    "zh-cn": "cms-themeblog",
    "en-us": "cms-themeblog"
  },
  "plugins": {
    "cms-plugintrack": {
      "enable": false,
      "track": {
        "google": "",
        "baidu": "",
        "qq": ""
      }
    }
  }
}