emails not sending (500 internal server)

Product Support
1

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}


2

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}

3

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.

4

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

5

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:

6

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)"} []

7

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)"} []

8

hi there,

can anyone help me out?

tx

9

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)"} []

10

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?

11

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

12

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!

13

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