PlanetScale hating Ghost

If you’re looking for help, please provide information about your environment. If you delete this template and don’t provide any information, your topic will be automatically closed.

If you aren’t running the latest version of Ghost, the first thing we’ll ask you to do is update to the latest version of Ghost.

- What’s your URL? This is the easiest way for others to help you

  • What version of Ghost are you using? 4.47.4 but i am hosting my installation on Railway.app and i tried to update ghost to the latest and it failed to build

And

  • How was Ghost installed and configured? Using a template link to the template
  • What Node version, database, OS & browser are you using? latest
  • What errors or information do you see in the console? $ bin/create-config && node index.js CLOUDINARY_URL found, setting storage to cloudinary [2022-09-04 12:18:23] INFO Ghost is running in production... [2022-09-04 12:18:23] INFO Your site is now available on https://ghost-production-e72a.up.railway.app/ [2022-09-04 12:18:23] INFO Ctrl+C to shut down [2022-09-04 12:18:23] INFO Ghost server started in 0.663s [2022-09-04 12:18:25] WARN Database state requires initialisation. [2022-09-04 12:18:26] ERROR CREATE DATABASE railCHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci; - Can't create database 'rail'; database exists CREATE DATABASErail CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci; - Can't create database 'rail'; database exists Error ID: 500 Error Code: DATABASE_CREATION_FAILED
  • What steps could someone else take to reproduce the issue you’re having?
    1 Spin up this on Railway.app
    2 go to bin/create-config and change the lines from 64 to 68 to a planetscale database
    connection strings
    3 after changing lines 64 to 68. Add a new line and copy and paste this text after line 68
          ssl  : {
    // DO NOT DO THIS
    // set up your ca correctly to trust the connection
    rejectUnauthorized: false,
  },
4 Deploy the app