# Emails send out - but the campaigns are stuck in pending

**URL:** <https://forum.mautic.org/t/emails-send-out-but-the-campaigns-are-stuck-in-pending/25049>\
**Category:** Product Support\
**Created:** [August 14, 2022, 7:28pm UTC](https://forum.mautic.org/t/emails-send-out-but-the-campaigns-are-stuck-in-pending/25049 "2022-08-14T19:28:07Z")\
**Posts on this page:** 8\
**Page:** 1

<div class="post-metadata">

**Author:** ![rndom301](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.mautic.org/rndom301/32/7873_2.png) [@rndom301](https://forum.mautic.org/u/rndom301)\
**Post date:** [August 14, 2022, 7:28pm UTC](https://forum.mautic.org/t/emails-send-out-but-the-campaigns-are-stuck-in-pending/25049/1 "2022-08-14T19:28:07Z")

</div>

i have a campaign that sends out emails successfully.

when i look at the channels section, i can see that the emails were all sent. when i look at the spool, it’s empty. most importantly, i can see the emails sent in postal.

unfortunately, when i go to the campaign itself, and try to get an idea of why events aren’t being triggered - i see that it doesn’t not register as the emails being completely sent:

 ![image](https://us1.discourse-cdn.com/flex020/uploads/mautic/original/2X/9/96163ecb67794aa872f1509e1317713884369d41.png)

they are all showing as pending - even though they’ve been sent.

this is an issue, because my events don’t fire (for example, open email event.)

 ![image](https://us1.discourse-cdn.com/flex020/uploads/mautic/original/2X/d/d7aa503f651fd7f65061bfe8d55c149af20391b6.png)

here is the send email setting:

![image](https://us1.discourse-cdn.com/flex020/uploads/mautic/original/2X/c/c7da90ae652c94b24a56e078e17353ac4603edd9.png)

it’s pretty basic. i had tried using marketing, same issues.

my cronjobs:

 ![image](https://us1.discourse-cdn.com/flex020/uploads/mautic/original/2X/4/481dc837a4ace2e5ea42ea18ca618bbd276a3eff.png)

---

<div class="post-metadata">

**Author:** ![rndom301](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.mautic.org/rndom301/32/7873_2.png) [@rndom301](https://forum.mautic.org/u/rndom301)\
**Post date:** [August 17, 2022, 12:11am UTC](https://forum.mautic.org/t/emails-send-out-but-the-campaigns-are-stuck-in-pending/25049/2 "2022-08-17T00:11:24Z")

</div>

anyone have a clue?

---

<div class="post-metadata">

**Author:** ![joeyk](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.mautic.org/joeyk/32/11164_2.png) [@joeyk](https://forum.mautic.org/u/joeyk)\
**Post date:** [August 17, 2022, 4:07pm UTC](https://forum.mautic.org/t/emails-send-out-but-the-campaigns-are-stuck-in-pending/25049/3 "2022-08-17T16:07:06Z")

</div>

Shot in the dark:  
Did you set the timeframe in your reporting properly? If you filter for a day, when there was no send, then you won’t see anything.

---

<div class="post-metadata">

**Author:** ![steverobinson](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.mautic.org/steverobinson/32/174_2.png) [@steverobinson](https://forum.mautic.org/u/steverobinson)\
**Post date:** [August 17, 2022, 11:35pm UTC](https://forum.mautic.org/t/emails-send-out-but-the-campaigns-are-stuck-in-pending/25049/4 "2022-08-17T23:35:02Z")

</div>

Chiming in here - I’ve found that time zone settings on the server and/or in the user profile can mess up reporting right after the send.

In the email itself, I’ll often set the timeframe to include the next day (tomorrow) to get the data to show.

However, when looking at campaigns, the date range only impacts the graphs, not the counts in the actions tab. Those seem to be all-time.

---

<div class="post-metadata">

**Author:** ![rndom301](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.mautic.org/rndom301/32/7873_2.png) [@rndom301](https://forum.mautic.org/u/rndom301)\
**Post date:** [August 18, 2022, 12:58am UTC](https://forum.mautic.org/t/emails-send-out-but-the-campaigns-are-stuck-in-pending/25049/5 "2022-08-18T00:58:51Z")

</div>

what do you mean by reporting? im really just having an issue with events triggering in the campaign.

i know people are opening because i can see in postal - and ive even gotten a couple of unsubscribes and clicks on the links.

---

<div class="post-metadata">

**Author:** ![rndom301](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.mautic.org/rndom301/32/7873_2.png) [@rndom301](https://forum.mautic.org/u/rndom301)\
**Post date:** [August 18, 2022, 1:02am UTC](https://forum.mautic.org/t/emails-send-out-but-the-campaigns-are-stuck-in-pending/25049/6 "2022-08-18T01:02:54Z")

</div>

> [@steverobinson](#):
>
> wever, when looking at campaigns, the date range only impacts the graphs, not the counts in the actions tab. Those seem to be all-time.

can you go into more detail about this? i am running a campaign - and the way i fire it is by inserting new rows into the mautic database table for lead lists. so its really a cron job thats executing a sql file - not sure how i could adjust the timeframe on a specific email

---

<div class="post-metadata">

**Author:** ![joeyk](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.mautic.org/joeyk/32/11164_2.png) [@joeyk](https://forum.mautic.org/u/joeyk)\
**Post date:** [August 18, 2022, 11:22am UTC](https://forum.mautic.org/t/emails-send-out-but-the-campaigns-are-stuck-in-pending/25049/7 "2022-08-18T11:22:35Z")

</div>

I’m not sure, that insterting rows in the DB will have the proper effect on your campaigns. Why not adding them via API?

---

<div class="post-metadata">

**Author:** ![rndom301](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.mautic.org/rndom301/32/7873_2.png) [@rndom301](https://forum.mautic.org/u/rndom301)\
**Post date:** [August 18, 2022, 11:59am UTC](https://forum.mautic.org/t/emails-send-out-but-the-campaigns-are-stuck-in-pending/25049/8 "2022-08-18T11:59:18Z")

</div>

```auto
SELECT
	3 AS leadlist_id -- the segment you want
	,lead_id
	,NOW() AS date_added
	,0 AS manually_removed
	,1 AS manually_added
FROM final

```

i am just adding the contacts into segments. was not aware of a way to do this on api 😕

also i have noticed that my system setting keeps changing the timezone to UTC

 ![image](https://us1.discourse-cdn.com/flex020/uploads/mautic/original/2X/6/6622ce5d0ffc6c634cbfc23057de00e450bb31e1.png)

is there a way to make my choice persist? maybe thats a bug i have
