# emails not sending (500 internal server)

**URL:** <https://forum.mautic.org/t/emails-not-sending-500-internal-server/3203>\
**Category:** Product Support\
**Created:** [January 11, 2016, 4:17pm UTC](https://forum.mautic.org/t/emails-not-sending-500-internal-server/3203 "2016-01-11T16:17:43Z")\
**Posts on this page:** 13\
**Page:** 1

<div class="post-metadata">

**Author:** ![xofnot](https://avatars.discourse-cdn.com/v4/letter/x/35a633/32.png) [@xofnot](https://forum.mautic.org/u/xofnot)\
**Post date:** [January 11, 2016, 4:17pm UTC](https://forum.mautic.org/t/emails-not-sending-500-internal-server/3203/1 "2016-01-11T16:17:43Z")

</div>

when sending newsletter to a mail list (not a campaign) I get mautibot telling me that he broke the system and gives a 500 internal server error.  
  
  
  
sending is set to send immediately but i do get the question when clicking send and selecting a batch volume if I agree to queue this newsletter.  
  
  
  
sending a test mail works  
  
  
  
sending the full mail does not work. (I changed the mailsending to queue and adapted cron jobs but the mail did not go out - then I reverted back to send immediately and it still does not send)  
  
  
  
error logs  
  
  
  
/home1/mydomain/public\_html/mautic/error\_log:  
  
#0 /home1/mydomain/public\_html/mautic/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOConnection.php(40): PDO-\>\_\_construct(‘mysql:host=loca…’, 'username, ‘Pwd’, Array)  
  
#1 /home1/mydomain/public\_html/mautic/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOMySql/Driver.php(41): DoctrineDBALDriverPDOConnection-\>\_\_construct(‘mysql:host=loca…’, 'username, ‘Pwd’, Array)  
  
#2 /home1/mydomain/public\_html/mautic/vendor/doctrine/dbal/lib/Doctrine/DBAL/Connection.php(356): DoctrineDBALDriverPDOMySqlDriver-\>connect(Array, 'username, ‘Pwd’, Array)  
  
#3 /home1/mydomain/public\_html/mautic/app/AppKernel.php(101): DoctrineDBALConnection-\>connect()  
  
#4 /home1/mydomain/public\_html/mautic/index.php(56): AppKernel-\>handle(Object(SymfonyComponentHttpFoundationRequest))  
  
#5 {main}

---

<div class="post-metadata">

**Author:** ![xofnot](https://avatars.discourse-cdn.com/v4/letter/x/35a633/32.png) [@xofnot](https://forum.mautic.org/u/xofnot)\
**Post date:** [January 11, 2016, 4:17pm UTC](https://forum.mautic.org/t/emails-not-sending-500-internal-server/3203/2 "2016-01-11T16:17:43Z")

</div>

when sending newsletter to a mail list (not a campaign) I get mautibot telling me that he broke the system and gives a 500 internal server error.

sending is set to send immediately but i do get the question when clicking send and selecting a batch volume if I agree to queue this newsletter.

sending a test mail works

sending the full mail does not work. (I changed the mailsending to queue and adapted cron jobs but the mail did not go out - then I reverted back to send immediately and it still does not send)

error logs

/home1/mydomain/public\_html/mautic/error\_log:  
#0 /home1/mydomain/public\_html/mautic/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOConnection.php(40): PDO-\>\_\_construct(‘mysql:host=loca…’, 'username, ‘Pwd’, Array)  
#1 /home1/mydomain/public\_html/mautic/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOMySql/Driver.php(41): DoctrineDBALDriverPDOConnection-\>\_\_construct(‘mysql:host=loca…’, 'username, ‘Pwd’, Array)  
#2 /home1/mydomain/public\_html/mautic/vendor/doctrine/dbal/lib/Doctrine/DBAL/Connection.php(356): DoctrineDBALDriverPDOMySqlDriver-\>connect(Array, 'username, ‘Pwd’, Array)  
#3 /home1/mydomain/public\_html/mautic/app/AppKernel.php(101): DoctrineDBALConnection-\>connect()  
#4 /home1/mydomain/public\_html/mautic/index.php(56): AppKernel-\>handle(Object(SymfonyComponentHttpFoundationRequest))  
#5 {main}

---

<div class="post-metadata">

**Author:** ![xofnot](https://avatars.discourse-cdn.com/v4/letter/x/35a633/32.png) [@xofnot](https://forum.mautic.org/u/xofnot)\
**Post date:** [January 11, 2016, 4:26pm UTC](https://forum.mautic.org/t/emails-not-sending-500-internal-server/3203/3 "2016-01-11T16:26:14Z")

</div>

hello to all,

i get the same error whilst trying to look at the details of a lead in the leads/manage leads on the link in the name of the lead.

when i click in the dropdown left of the lead i can choose modify/edit (bewerken: my mautic is in another language - nederlands) and then mautic opens the lead and I can work in it, but not when I click on the lead itself.

do not know if this is linked, but thought to share this anyhow.

tx for helping me out (again) - your support is really much appreciated.

---

<div class="post-metadata">

**Author:** ![gmillard](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.mautic.org/gmillard/32/5_2.png) [@gmillard](https://forum.mautic.org/u/gmillard)\
**Post date:** [January 11, 2016, 4:48pm UTC](https://forum.mautic.org/t/emails-not-sending-500-internal-server/3203/4 "2016-01-11T16:48:26Z")

</div>

Hi,

In your logs, what’s the line above `#0 /home1/mydomain/public_html/mautic/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOConnection.php(40): PDO->__construct('mysql:host=loca...', 'username, 'Pwd', Array)`?

Usually the actual exception is before the # list (which is the backtrace).

Thanks,  
Alan

---

<div class="post-metadata">

**Author:** ![xofnot](https://avatars.discourse-cdn.com/v4/letter/x/35a633/32.png) [@xofnot](https://forum.mautic.org/u/xofnot)\
**Post date:** [January 11, 2016, 7:15pm UTC](https://forum.mautic.org/t/emails-not-sending-500-internal-server/3203/5 "2016-01-11T19:15:10Z")

</div>

this is above the #list

exception ‘PDOException’ with message ‘SQLSTATE[28000] [1045] Access denied for user ‘user’@‘localhost’ (using password: YES)’ in /home1/public\_html/mautic/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOConnection.php:40  
Stack trace:

---

<div class="post-metadata">

**Author:** ![xofnot](https://avatars.discourse-cdn.com/v4/letter/x/35a633/32.png) [@xofnot](https://forum.mautic.org/u/xofnot)\
**Post date:** [January 11, 2016, 9:32pm UTC](https://forum.mautic.org/t/emails-not-sending-500-internal-server/3203/6 "2016-01-11T21:32:50Z")

</div>

Hi,

i have looked into the mautic\_prod erro log and this is the full error message

[2016-01-11 21:27:52] mautic.CRITICAL: Uncaught PHP Exception DoctrineDBALDBALException: “An exception occurred while executing ‘SELECT e0\_.id AS id0, e0\_.date\_created AS date\_created1, e0\_.body AS body2, e0\_.subject AS subject3 FROM email\_copies e0\_ WHERE e0\_.id = ?’ with params [“e5191f8d9736c964659461c0c0e43da6”]: SQLSTATE[42S02]: Base table or view not found: 1146 Table ‘ocialme8\_mautic.email\_copies’ doesn’t exist” at /home1/ocialme8/public\_html/mautic/vendor/doctrine/dbal/lib/Doctrine/DBAL/DBALException.php line 91 {“exception”:"[object] (Doctrine\DBAL\DBALException(code: 0): An exception occurred while executing ‘SELECT e0\_.id AS id0, e0\_.date\_created AS date\_created1, e0\_.body AS body2, e0\_.subject AS subject3 FROM email\_copies e0\_ WHERE e0\_.id = ?’ with params [“e5191f8d9736c964659461c0c0e43da6”]:nnSQLSTATE[42S02]: Base table or view not found: 1146 Table ‘ocialme8\_mautic.email\_copies’ doesn’t exist at /home1/ocialme8/public\_html/mautic/vendor/doctrine/dbal/lib/Doctrine/DBAL/DBALException.php:91, PDOException(code: 42S02): SQLSTATE[42S02]: Base table or view not found: 1146 Table ‘ocialme8\_mautic.email\_copies’ doesn’t exist at /home1/ocialme8/public\_html/mautic/vendor/doctrine/dbal/lib/Doctrine/DBAL/Connection.php:694)"} []

---

<div class="post-metadata">

**Author:** ![xofnot](https://avatars.discourse-cdn.com/v4/letter/x/35a633/32.png) [@xofnot](https://forum.mautic.org/u/xofnot)\
**Post date:** [January 12, 2016, 4:18pm UTC](https://forum.mautic.org/t/emails-not-sending-500-internal-server/3203/7 "2016-01-12T16:18:59Z")

</div>

Hello, this is the error from the production log --\> can you help?

[2016-01-12 09:20:03] mautic.CRITICAL: Uncaught PHP Exception DoctrineDBALDBALException: “An exception occurred while executing ‘SELECT e0\_.id AS id0, e0\_.email\_address AS email\_address1, e0\_.date\_sent AS date\_sent2, e0\_.is\_read AS is\_read3, e0\_.is\_failed AS is\_failed4, e0\_.viewed\_in\_browser AS viewed\_in\_browser5, e0\_.date\_read AS date\_read6, e0\_.tracking\_hash AS tracking\_hash7, e0\_.retry\_count AS retry\_count8, e0\_.source AS source9, e0\_.source\_id AS source\_id10, e0\_.tokens AS tokens11, e0\_.copy AS copy12, e0\_.open\_count AS open\_count13, e0\_.last\_opened AS last\_opened14, e0\_.open\_details AS open\_details15, e0\_.email\_id AS email\_id16, e0\_.lead\_id AS lead\_id17, e0\_.list\_id AS list\_id18, e0\_.ip\_id AS ip\_id19, e0\_.copy\_id AS copy\_id20 FROM email\_stats e0\_ LEFT JOIN leads l1\_ ON e0\_.lead\_id = l1\_.id LEFT JOIN emails e2\_ ON e0\_.email\_id = e2\_.id WHERE e0\_.tracking\_hash = ?’ with params [“5693d4247180d”]: SQLSTATE[42S22]: Column not found: 1054 Unknown column ‘e0\_.copy\_id’ in ‘field list’” at /home1/mydomain/public\_html/mautic/vendor/doctrine/dbal/lib/Doctrine/DBAL/DBALException.php line 91 {“exception”:"[object] (Doctrine\DBAL\DBALException(code: 0): An exception occurred while executing ‘SELECT e0\_.id AS id0, e0\_.email\_address AS email\_address1, e0\_.date\_sent AS date\_sent2, e0\_.is\_read AS is\_read3, e0\_.is\_failed AS is\_failed4, e0\_.viewed\_in\_browser AS viewed\_in\_browser5, e0\_.date\_read AS date\_read6, e0\_.tracking\_hash AS tracking\_hash7, e0\_.retry\_count AS retry\_count8, e0\_.source AS source9, e0\_.source\_id AS source\_id10, e0\_.tokens AS tokens11, e0\_.copy AS copy12, e0\_.open\_count AS open\_count13, e0\_.last\_opened AS last\_opened14, e0\_.open\_details AS open\_details15, e0\_.email\_id AS email\_id16, e0\_.lead\_id AS lead\_id17, e0\_.list\_id AS list\_id18, e0\_.ip\_id AS ip\_id19, e0\_.copy\_id AS copy\_id20 FROM email\_stats e0\_ LEFT JOIN leads l1\_ ON e0\_.lead\_id = l1\_.id LEFT JOIN emails e2\_ ON e0\_.email\_id = e2\_.id WHERE e0\_.tracking\_hash = ?’ with params [“5693d4247180d”]:nnSQLSTATE[42S22]: Column not found: 1054 Unknown column ‘e0\_.copy\_id’ in ‘field list’ at /home1/mydomain/public\_html/mautic/vendor/doctrine/dbal/lib/Doctrine/DBAL/DBALException.php:91, PDOException(code: 42S22): SQLSTATE[42S22]: Column not found: 1054 Unknown column ‘e0\_.copy\_id’ in ‘field list’ at /home1/mydomain/public\_html/mautic/vendor/doctrine/dbal/lib/Doctrine/DBAL/Connection.php:694)"} []

---

<div class="post-metadata">

**Author:** ![xofnot](https://avatars.discourse-cdn.com/v4/letter/x/35a633/32.png) [@xofnot](https://forum.mautic.org/u/xofnot)\
**Post date:** [January 13, 2016, 4:36pm UTC](https://forum.mautic.org/t/emails-not-sending-500-internal-server/3203/8 "2016-01-13T16:36:16Z")

</div>

hi there,

can anyone help me out?

tx

---

<div class="post-metadata">

**Author:** ![rodfernand](https://avatars.discourse-cdn.com/v4/letter/r/9de0a6/32.png) [@rodfernand](https://forum.mautic.org/u/rodfernand)\
**Post date:** [January 13, 2016, 6:28pm UTC](https://forum.mautic.org/t/emails-not-sending-500-internal-server/3203/9 "2016-01-13T18:28:49Z")

</div>

I’m getting the same error and the same symptoms. Strange, but glad I’m not the only one…

Here’s my log:

[2016-01-13 14:44:50] mautic.CRITICAL: Uncaught PHP Exception DoctrineDBALDBALException: “An exception occurred while executing ‘SELECT m0\_.email\_id AS sclr0, m0\_.id AS id1, m0\_.date\_read AS date\_read2, m0\_.date\_sent AS date\_sent3, m1\_.name AS name4, m1\_.subject AS subject5, m0\_.is\_read AS is\_read6, m0\_.is\_failed AS is\_failed7, m0\_.viewed\_in\_browser AS viewed\_in\_browser8, m0\_.retry\_count AS retry\_count9, m0\_.list\_id AS sclr10, m2\_.name AS name11, m0\_.tracking\_hash AS tracking\_hash12, m0\_.open\_details AS open\_details13, m3\_.subject AS subject14 FROM mau\_email\_stats m0\_ LEFT JOIN mau\_emails m1\_ ON (m1\_.id = m0\_.email\_id) LEFT JOIN mau\_lead\_lists m2\_ ON (m2\_.id = m0\_.list\_id) LEFT JOIN mau\_email\_copies m3\_ ON (m3\_.id = m0\_.copy\_id) WHERE m0\_.lead\_id = 5632 AND m0\_.is\_failed = ?’ with params [0]: SQLSTATE[42S02]: Base table or view not found: 1146 Table ‘rodf\_mautic.mau\_email\_copies’ doesn’t exist” at /home/rodf/public\_html/mw/vendor/doctrine/dbal/lib/Doctrine/DBAL/DBALException.php line 91 {“exception”:"[object] (Doctrine\DBAL\DBALException(code: 0): An exception occurred while executing ‘SELECT m0\_.email\_id AS sclr0, m0\_.id AS id1, m0\_.date\_read AS date\_read2, m0\_.date\_sent AS date\_sent3, m1\_.name AS name4, m1\_.subject AS subject5, m0\_.is\_read AS is\_read6, m0\_.is\_failed AS is\_failed7, m0\_.viewed\_in\_browser AS viewed\_in\_browser8, m0\_.retry\_count AS retry\_count9, m0\_.list\_id AS sclr10, m2\_.name AS name11, m0\_.tracking\_hash AS tracking\_hash12, m0\_.open\_details AS open\_details13, m3\_.subject AS subject14 FROM mau\_email\_stats m0\_ LEFT JOIN mau\_emails m1\_ ON (m1\_.id = m0\_.email\_id) LEFT JOIN mau\_lead\_lists m2\_ ON (m2\_.id = m0\_.list\_id) LEFT JOIN mau\_email\_copies m3\_ ON (m3\_.id = m0\_.copy\_id) WHERE m0\_.lead\_id = 5632 AND m0\_.is\_failed = ?’ with params [0]:nnSQLSTATE[42S02]: Base table or view not found: 1146 Table ‘rodf\_mautic.mau\_email\_copies’ doesn’t exist at /home/rodf/public\_html/mw/vendor/doctrine/dbal/lib/Doctrine/DBAL/DBALException.php:91, PDOException(code: 42S02): SQLSTATE[42S02]: Base table or view not found: 1146 Table ‘rodf\_mautic.mau\_email\_copies’ doesn’t exist at /home/rodf/public\_html/mw/vendor/doctrine/dbal/lib/Doctrine/DBAL/Connection.php:694)"} []

---

<div class="post-metadata">

**Author:** ![dbhurley](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.mautic.org/dbhurley/32/2_2.png) [@dbhurley](https://forum.mautic.org/u/dbhurley)\
**Post date:** [January 13, 2016, 7:02pm UTC](https://forum.mautic.org/t/emails-not-sending-500-internal-server/3203/10 "2016-01-13T19:02:43Z")

</div>

`Table 'rodf_mautic.mau_email_copies'` that’s the key. It sounds like you’re missing a table in your DB. Can you verify whether or not that table exists?

---

<div class="post-metadata">

**Author:** ![rodfernand](https://avatars.discourse-cdn.com/v4/letter/r/9de0a6/32.png) [@rodfernand](https://forum.mautic.org/u/rodfernand)\
**Post date:** [January 13, 2016, 7:08pm UTC](https://forum.mautic.org/t/emails-not-sending-500-internal-server/3203/11 "2016-01-13T19:08:47Z")

</div>

Hmm…it’s not there @dbhurley …What can I do? Should I add it manually?

---

<div class="post-metadata">

**Author:** ![rodfernand](https://avatars.discourse-cdn.com/v4/letter/r/9de0a6/32.png) [@rodfernand](https://forum.mautic.org/u/rodfernand)\
**Post date:** [January 13, 2016, 7:42pm UTC](https://forum.mautic.org/t/emails-not-sending-500-internal-server/3203/12 "2016-01-13T19:42:38Z")

</div>

I got it to work…I simply updated the schema. @xofnot , try navigating to this /s/update/schema on your installation to see if it updates the schema on your end. It should work fine after. I got the info from here:

Cheers!

---

<div class="post-metadata">

**Author:** ![xofnot](https://avatars.discourse-cdn.com/v4/letter/x/35a633/32.png) [@xofnot](https://forum.mautic.org/u/xofnot)\
**Post date:** [January 14, 2016, 7:38pm UTC](https://forum.mautic.org/t/emails-not-sending-500-internal-server/3203/13 "2016-01-14T19:38:08Z")

</div>

hello, thank you very much - /s/update/schema did the trick - it works !
