In v2.14.0 Nothing Happens When I Click On Emails

Product Support
1

Hi,

I have just upgraded to v2.14.0 successfully (from v2.13) and when I click on ‘email’ (in Channels) nothing happens.

Checked log and I get this but I don’t know what it means. I would really appreciate any help, thanks

Log error message:

[2018-07-27 14:41:12] mautic.CRITICAL: Uncaught PHP Exception Doctrine\DBAL\Exception\InvalidFieldNameException: “An exception occurred while executing ‘SELECT COUNT() AS dctrn_count FROM (SELECT DISTINCT id_10 FROM (SELECT m0_.is_published AS is_published_0, m0_.date_added AS date_added_1, m0_.created_by AS created_by_2, m0_.created_by_user AS created_by_user_3, m0_.date_modified AS date_modified_4, m0_.modified_by AS modified_by_5, m0_.modified_by_user AS modified_by_user_6, m0_.checked_out AS checked_out_7, m0_.checked_out_by AS checked_out_by_8, m0_.checked_out_by_user AS checked_out_by_user_9, m0_.id AS id_10, m0_.name AS name_11, m0_.description AS description_12, m0_.subject AS subject_13, m0_.from_address AS from_address_14, m0_.from_name AS from_name_15, m0_.reply_to_address AS reply_to_address_16, m0_.bcc_address AS bcc_address_17, m0_.template AS template_18, m0_.content AS content_19, m0_.utm_tags AS utm_tags_20, m0_.plain_text AS plain_text_21, m0_.custom_html AS custom_html_22, m0_.email_type AS email_type_23, m0_.publish_up AS publish_up_24, m0_.publish_down AS publish_down_25, m0_.read_count AS read_count_26, m0_.sent_count AS sent_count_27, m0_.variant_sent_count AS variant_sent_count_28, m0_.variant_read_count AS variant_read_count_29, m0_.revision AS revision_30, m0_.lang AS lang_31, m0_.variant_settings AS variant_settings_32, m0_.variant_start_date AS variant_start_date_33, m0_.dynamic_content AS dynamic_content_34, m0_.headers AS headers_35 FROM mauxj_emails m0_ LEFT JOIN mauxj_categories m1_ ON m0_.category_id = m1_.id WHERE m0_.variant_parent_id IS NULL AND m0_.translation_parent_id IS NULL ORDER BY m0_.subject DESC) dctrn_result) dctrn_table’: Unknown column ‘m0_.headers’ in ‘field list’" at /home/mailzers/public_html/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/AbstractMySQLDriver.php line 71 {“exception”:"[object] (Doctrine\DBAL\Exception\InvalidFieldNameException(code: 0): An exception occurred while executing 'SELECT COUNT() AS dctrn_count FROM (SELECT DISTINCT id_10 FROM (SELECT m0_.is_published AS is_published_0, m0_.date_added AS date_added_1, m0_.created_by AS created_by_2, m0_.created_by_user AS created_by_user_3, m0_.date_modified AS date_modified_4, m0_.modified_by AS modified_by_5, m0_.modified_by_user AS modified_by_user_6, m0_.checked_out AS checked_out_7, m0_.checked_out_by AS checked_out_by_8, m0_.checked_out_by_user AS checked_out_by_user_9, m0_.id AS id_10, m0_.name AS name_11, m0_.description AS description_12, m0_.subject AS subject_13, m0_.from_address AS from_address_14, m0_.from_name AS from_name_15, m0_.reply_to_address AS reply_to_address_16, m0_.bcc_address AS bcc_address_17, m0_.template AS template_18, m0_.content AS content_19, m0_.utm_tags AS utm_tags_20, m0_.plain_text AS plain_text_21, m0_.custom_html AS custom_html_22, m0_.email_type AS email_type_23, m0_.publish_up AS publish_up_24, m0_.publish_down AS publish_down_25, m0_.read_count AS read_count_26, m0_.sent_count AS sent_count_27, m0_.variant_sent_count AS variant_sent_count_28, m0_.variant_read_count AS variant_read_count_29, m0_.revision AS revision_30, m0_.lang AS lang_31, m0_.variant_settings AS variant_settings_32, m0_.variant_start_date AS variant_start_date_33, m0_.dynamic_content AS dynamic_content_34, m0_.headers AS headers_35 FROM mauxj_emails m0_ LEFT JOIN mauxj_categories m1_ ON m0_.category_id = m1_.id WHERE m0_.variant_parent_id IS NULL AND m0_.translation_parent_id IS NULL ORDER BY m0_.subject DESC) dctrn_result) dctrn_table’:\n\nUnknown column ‘m0_.headers’ in ‘field list’ at /home/mailzers/public_html/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/AbstractMySQLDriver.php:71, Doctrine\DBAL\Driver\Mysqli\MysqliException(code: 0): Unknown column ‘m0_.headers’ in ‘field list’ at /home/mailzers/public_html/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/Mysqli/MysqliStatement.php:101)”} []

2

I’m having the same issue… When I try to log in directly to /s/emails I get the “Uh oh! I think I broke it.”

Can someone help?

Thanks!

3

Dear Richard,

I followed these instructions and after database migrations it worked!

https://johnlinhart.com/blog/uh-oh-mautic-upgrade-was-not-successful

See if you can do it.

Regards,
Paulo.

4

Hi Paulo,

Thanks for your help, but that did not work for me. I also get an 500 Internal Server Error when I try to login directly to emails and campaigns.

Any more help from anyone would be highly appreciative.

Thanks
Richard

5

@richardmerry @Paulo Neto delete cache and warm up it again //

6

@bizcrony thanks for your suggestion, but I’ve deleted cache (in cpanel file manager in ‘app’ then deleted the ‘Cache’ folder) as I know the cache is normally the cause of a lot of issues, but that did not resolve the issue.

I appreciate any other suggestions

7

Better you delete cahce by ssh command.

8

Sorry can you guide me to delete cache with ssh

9

@Dixie Use always like this https://johnlinhart.com/blog/uh-oh-mautic-upgrade-was-not-successful

10

I am also having this same problem and have tried the steps listed above with no resolution. @richardmerry, please let me know if you ever solved this problem

11

@YdocZ - sorry for late reply. No, I did not find a solution. I had to go back to version 2.13 from my backup.