0 recipients when sending

rakesh

Connected a list to the email and it says +200 recipients connected.
When I visit the Summary I get a message saying 0 recipients.
Going back to the Recipients Tab the list is no longer connected.

So I'm unable to send my mailing ☹️

rakesh

Can't connect any list to an email, it is not being saved.

jvstratum

Hi,

Can you try to run a database integrity check? You'll find it at the bottom of the page Configuration->Security.

If that does not resolve your issue, please open your console (F12 in Chrome/Firefox) and try to select your list and send your mail again. Please check if the console shows you any errors.

rakesh

Did it and got this responds:

index fk_XXXX_acym_mail1 missing in #acym_mail
[OK]Problem solved: Added index fk_XXXX_acym_mail1 to #acym_mail

It did not solve my problem tho.

rakesh

The problem occurs with trying to save&continue with the Recipients Tab. So attaching the list to the Email/campaign.

Console gives this with the Send Settings Tab:
This page uses the non standard property “zoom”. Consider using calc() in the relevant property values, or using “transform” along with “transform-origin: 0 0”.

rakesh

Tried with newly created emails/campaigns but also there, none of the lists are being saved/added to the email/campaign.

rakesh

_acym_mail_has_list is not being created for some reason.
of that table the list_id is not loading my lists, but the standard value: 1 - Newsletters

Due to this error:
#1062 - Duplicate entry '25-1' for key 'PRIMARY'

rakesh

Deleted the duplicate _acym_list

And at first got this message:
Cannot delete or update a parent row: a foreign key constraint fails (database_db.XXX_acym_mail_has_list, CONSTRAINT fk_XXX_acym_mail_has_list2 FOREIGN KEY (list_id) REFERENCES XXX_acym_list2 (id) ON DELETE NO ACTION ON UPDATE NO ACTION)

But now I need to reconnect the List_id of _acym_mail_has_list to the acym_list

How is this done?
This is new for me.

Check Database Integrity didn't help after this.

rakesh

The acym_mail_has_list with column list_id has now: browse foreign values option

rakesh

Managed to fix the FK by adding it with SQL

ALTER TABLE XXX_acym_mail_has_list
DROP FOREIGN KEY fk_XXX_acym_mail_has_list1,
DROP FOREIGN KEY fk_XXX_acym_mail_has_list2;

then

ALTER TABLE XXX_acym_mail_has_list
ADD CONSTRAINT fk_XXX_acym_mail_has_list1 FOREIGN KEY (mail_id) REFERENCES XXX_acym_mail (id) ON DELETE NO ACTION ON UPDATE NO ACTION,
ADD CONSTRAINT fk_XXX_acym_mail_has_list2 FOREIGN KEY (list_id) REFERENCES XXX_acym_list (id) ON DELETE NO ACTION ON UPDATE NO ACTION;

Wasn't that difficult after all 🙂

rakesh

Would be nice to have this checked with the integrity config button.

rakesh

It now says +200 users in the Summary Tab, but after pressing the button Add to queue, it doesn't send the email there.
I get the message: No user found
In the Queue listing.

jvstratum

Hi,

Please use the contact form (https://www.acymailing.com/contact/) to raise a support ticket for this and include login credentials for your backend and a link to this thread.

mihha

Just to add something here

Did you confirm your subscribers? Please check their details and see if they are confirmed. If they are not confirmed, you won't be able to send emails to them

rakesh

Have Require Confirmation disabled.
With Automation>New Mass Actions I have set every email to confirmed.
But it didn't help the problem.

rakesh

Seems I had a mismatch of the columns: Tracking and Language after the import.
Fixed the FK of the User_id of Queue table.
Then did the Integrity check that fixed added the lang and tracking tables.
Works now.

mihha

Glad to hear that you managed to solve the problem