Unable to send Emails

Memberships & subscriptions
1

When trying to send an email at the point of publishing an article. It’s telling me there is an error. i.e

image
image697×458 22.3 KB

on the CLI I’m getting the following from the docker logs of the ghost container…

[2020-10-11 20:14:16] INFO "PUT /ghost/api/v3/admin/posts/5dbc96993c5e7d0001e58961/?send_email_when_published=true" 200 366ms
(node:1) UnhandledPromiseRejectionWarning: InternalServerError: The server has encountered an error.
    at new GhostError (/var/lib/ghost/versions/3.35.4/node_modules/@tryghost/errors/lib/errors.js:10:26)
    at sendEmailJob (/var/lib/ghost/versions/3.35.4/core/server/services/mega/mega.js:249:15)
    at async /var/lib/ghost/versions/3.35.4/node_modules/@tryghost/job-manager/lib/job-manager.js:29:13
    at async JobManager.worker (/var/lib/ghost/versions/3.35.4/node_modules/@tryghost/job-manager/lib/job-manager.js:6:22)

Error: SQLITE_ERROR: too many SQL variables

Any suggestions?

2

@rickdonato it appears you are using sqlite as your database. sqlite is intended for development use rather than production use and has limitations with scale as number of members grows which is what you have run into here.

I’d suggest switching to mysql or alternatively upgrading the version of sqlite you are using as 3.32 increased the number of variables that are allowed in a query.

3

OK thanks.