Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

Sign up for GitHub

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Jump to bottom

Can't change Support Mail Address #19130

Open
1 task done
s3tupw1zard opened this issue Nov 25, 2023 · 6 comments
Open
1 task done

Can't change Support Mail Address #19130

s3tupw1zard opened this issue Nov 25, 2023 · 6 comments
Labels
bug [triage] something behaving unexpectedly

Comments

@s3tupw1zard
Copy link

s3tupw1zard commented Nov 25, 2023 •
edited

Issue Summary

Hello,
I'm getting an error when I want to change the support email on my blogs portal settings.

I installed my blog using docker compose. A few days later I moved the folder with both folders for ghost and mysql to another server.

Here's my docker compose file:

  ghost:
    image: ghost:latest
    container_name: ghost-cms
    restart: always
    depends_on:
      - ghost_db
    environment:
      NODE_ENV: production
      url: https://example.com
      database__client: mysql
      database__connection__host: ghost_db
      database__connection__user: ghost
      database__connection__password: reallysecurepassword
      database__connection__database: ghostdb
      mail__transport: SMTP
      mail__options__host: smtp.example.com
      mail__options__port: 587
      mail__options__auth__user: out@example.com
      mail__options__auth__pass: reallysecuremailpassword
      mail__from: Example.com <my-mail@example.com>
    networks:
      - ghost_net
    volumes:
      - ./ghost/blog/content:/var/lib/ghost/content
    labels:
      - "traefik.enable=true"
      - "traefik.docker.network=traefik_public"
      - "traefik.http.routers.ghost.entrypoints=websecure"
      - "traefik.http.routers.ghost.rule=Host(`domain.de`)"
      - "traefik.http.routers.ghost.service=ghost"
      - "traefik.http.services.ghost.loadbalancer.server.port=2368"
      - "traefik.http.routers.ghost.tls.certresolver=cfresolver"

  ghost_db:
    image: mysql:latest
    container_name: ghost-db
    restart: always
    command: --pid-file /var/lib/mysql/mysqld.pid
    environment:
      MYSQL_ROOT_PASSWORD: 'reallysecurerootpassword'
      MYSQL_USER: 'ghost'
      MYSQL_PASSWORD: 'reallysecurepassword'
      MYSQL_DATABASE: 'ghostdb'
    networks:
      - ghost_net
    volumes:
      - ./ghost/mysql:/var/lib/mysql

I omitted the traefik Proxy part, because that part works without problems with my domain.
I already tried to reset my instance but the result is the same.

Is there a way to fix this?

Thank you for help

Steps to Reproduce

  1. Configure Traefik
  2. Add Ghost and DB to docker-compose.yml as above
  3. Start using docker compose up -d
  4. Go to Ghost web address under portal change noreply@domain.tld to something else
  5. Click the link inside the mail that arrived
  6. See an error in Ghost CMS and its logs

Ghost Version

5.74.0

Node.js Version

The version in the docker image

How did you install Ghost?

docker compose

Database type

MySQL 8

Browser & OS version

No response

Relevant log / error output

ghost     | [2023-11-22 19:10:02] ERROR "PUT /ghost/api/admin/newsletters/verifications/?include=count.active_members%2Ccount.posts" 500 44ms
ghost     | 
ghost     | An unexpected error occurred, please try again.
ghost     | 
ghost     | "Undefined binding(s) detected when compiling SELECT. Undefined column(s): [newsletters.id] query: select `newsletters`.* from `newsletters` where `newsletters`.`id` = ? limit ?"
ghost     | 
ghost     | Error ID:
ghost     |     bcb4faa0-896a-11ee-a8a7-a3e750495518
ghost     | 
ghost     | Error Code: 
ghost     |     UNEXPECTED_ERROR
ghost     | 
ghost     | ----------------------------------------
ghost     | 
ghost     | Error: Undefined binding(s) detected when compiling SELECT. Undefined column(s): [newsletters.id] query: select `newsletters`.* from `newsletters` where `newsletters`.`id` = ? limit ?
ghost     |     at module.exports.prepareError (/var/lib/ghost/versions/5.74.0/node_modules/@tryghost/mw-error-handler/lib/mw-error-handler.js:102:19)
ghost     |     at QueryCompiler_MySQL.toSQL (/var/lib/ghost/versions/5.74.0/node_modules/knex/lib/query/querycompiler.js:110:13)
ghost     |     at Builder.toSQL (/var/lib/ghost/versions/5.74.0/node_modules/knex/lib/query/querybuilder.js:83:44)
ghost     |     at ensureConnectionCallback (/var/lib/ghost/versions/5.74.0/node_modules/knex/lib/execution/internal/ensure-connection-callback.js:4:30)
ghost     |     at Runner.ensureConnection (/var/lib/ghost/versions/5.74.0/node_modules/knex/lib/execution/runner.js:300:20)
ghost     |     at async Runner.run (/var/lib/ghost/versions/5.74.0/node_modules/knex/lib/execution/runner.js:30:19)

Code of Conduct

  • I agree to be friendly and polite to people in this repository
@github-actions github-actions bot added the needs:triage [triage] this needs to be triaged by the Ghost team label Nov 25, 2023
@s3tupw1zard s3tupw1zard changed the title Can't change Support Mai Address Can't change Support Mail Address Nov 25, 2023
@s3tupw1zard
Copy link
Author

s3tupw1zard commented Nov 25, 2023 •
edited

I tested another version of the image and it appears that the error doesn't occur, or to put it in other words, it doesn't prevent it to change the support mail address.
In the console I'm getting the same error, but this time the change was successful.

The image I tested was ghost:5.73.2-alpine (here it kinda works like expected)

With versions ghost:5.74.0-alpine, ghost:5 and ghost:5.74 including ghost:latest the described error is present.

@daniellockyer daniellockyer added the bug [triage] something behaving unexpectedly label Nov 28, 2023
@github-actions github-actions bot removed the needs:triage [triage] this needs to be triaged by the Ghost team label Nov 28, 2023
@nick2432
Copy link

can i work on this?

@markstos
Copy link
Contributor

mysql:latest is not supported.

MySQL 8 is supported.

@markstos
Copy link
Contributor

@royalfig It would be helpful if mentions of "MySQL 8" in docs clarified whether that means

8.0, 8.1, 8.2

or all three.

The issue here seems like it might be due to running a MySQL version that qualifies as MySQL 8, but is newer than intended or tested.

@royalfig
Copy link
Contributor

@markstos Thanks! I'll confirm this.

@royalfig
Copy link
Contributor

@s3tupw1zard Our recent release updates how email addresses work in Ghost. Are you able to upgrade and see if you still encounter this bug?

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees
No one assigned
Labels
bug [triage] something behaving unexpectedly
Projects
None yet
Milestone
No milestone
Development

No branches or pull requests
5 participants
@markstos @daniellockyer @royalfig @s3tupw1zard @nick2432