Mautic Community Forums

500 Internal Server Error

Getting this error While Clicking on " Having Trouble Shoot…" in email. and the Tracking GIF is not working showing 500 internal server error.



[2017-07-28 14:18:49] mautic.WARNING: PHP Warning - PDOStatement::execute(): MySQL server has gone away - in file /var/www/html/mautic/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOStatement.php - at line 91 [] []

[2017-07-28 14:18:49] mautic.WARNING: PHP Warning - PDOStatement::execute(): Error reading result set’s header - in file /var/www/html/mautic/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOStatement.php - at line 91 [] []

[2017-07-28 14:18:49] mautic.CRITICAL: Uncaught PHP Exception DoctrineDBALExceptionDriverException: “An exception occurred while executing ‘SELECT c0_.id AS id_0, c0_.name AS name_1, c0_.description AS description_2, c0_.type AS type_3, c0_.event_type AS event_type_4, c0_.event_order AS event_order_5, c0_.properties AS properties_6, c0_.trigger_date AS trigger_date_7, c0_.trigger_interval AS trigger_interval_8, c0_.trigger_interval_unit AS trigger_interval_unit_9, c0_.trigger_mode AS trigger_mode_10, c0_.decision_path AS decision_path_11, c0_.temp_id AS temp_id_12, c0_.channel AS channel_13, c0_.channel_id AS channel_id_14, c1_.is_published AS is_published_15, c1_.date_added AS date_added_16, c1_.created_by AS created_by_17, c1_.created_by_user AS created_by_user_18, c1_.date_modified AS date_modified_19, c1_.modified_by AS modified_by_20, c1_.modified_by_user AS modified_by_user_21, c1_.checked_out AS checked_out_22, c1_.checked_out_by AS checked_out_by_23, c1_.checked_out_by_user AS checked_out_by_user_24, c1_.id AS id_25, c1_.name AS name_26, c1_.description AS description_27, c1_.publish_up AS publish_up_28, c1_.publish_down AS publish_down_29, c1_.canvas_settings AS canvas_settings_30, c2_.id AS id_31, c2_.name AS name_32, c2_.description AS description_33, c2_.type AS type_34, c2_.event_type AS event_type_35, c2_.event_order AS event_order_36, c2_.properties AS properties_37, c2_.trigger_date AS trigger_date_38, c2_.trigger_interval AS trigger_interval_39, c2_.trigger_interval_unit AS trigger_interval_unit_40, c2_.trigger_mode AS trigger_mode_41, c2_.decision_path AS decision_path_42, c2_.temp_id AS temp_id_43, c2_.channel AS channel_44, c2_.channel_id AS channel_id_45, c3_.id AS id_46, c3_.name AS name_47, c3_.description AS description_48, c3_.type AS type_49, c3_.event_type AS event_type_50, c3_.event_order AS event_order_51, c3_.properties AS properties_52, c3_.trigger_date AS trigger_date_53, c3_.trigger_interval AS trigger_interval_54, c3_.trigger_interval_unit AS trigger_interval_unit_55, c3_.trigger_mode AS trigger_mode_56, c3_.decision_path AS decision_path_57, c3_.temp_id AS temp_id_58, c3_.channel AS channel_59, c3_.channel_id AS channel_id_60, c4_.is_published AS is_published_61, c4_.date_added AS date_added_62, c4_.created_by AS created_by_63, c4_.created_by_user AS created_by_user_64, c4_.date_modified AS date_modified_65, c4_.modified_by AS modified_by_66, c4_.modified_by_user AS modified_by_user_67, c4_.checked_out AS checked_out_68, c4_.checked_out_by AS checked_out_by_69, c4_.checked_out_by_user AS checked_out_by_user_70, c4_.id AS id_71, c4_.name AS name_72, c4_.description AS description_73, c4_.publish_up AS publish_up_74, c4_.publish_down AS publish_down_75, c4_.canvas_settings AS canvas_settings_76 FROM campaign_events c0_ INNER JOIN campaigns c1_ ON c0_.campaign_id = c1_.id LEFT JOIN campaign_events c2_ ON c0_.id = c2_.parent_id LEFT JOIN campaign_events c3_ ON c0_.parent_id = c3_.id LEFT JOIN campaigns c4_ ON c2_.campaign_id = c4_.id WHERE c1_.is_published = ? AND (c1_.publish_down IS NULL OR c1_.publish_down >= ?) AND (c1_.publish_up IS NULL OR c1_.publish_up <= ?) AND c0_.type = ? AND c1_.id IN (?) AND (c0_.id NOT IN (SELECT c5_.id FROM campaign_lead_event_log c6_ LEFT JOIN campaign_events c5_ ON c6_.event_id = c5_.id LEFT JOIN leads l7_ ON c6_.lead_id = l7_.id WHERE c5_.id = c0_.id AND l7_.id = ?)) AND (c0_.decision_path <> ‘no’ OR c0_.decision_path IS NULL) ORDER BY c0_.event_order ASC, c2_.event_order ASC’ with params [1, “2017-07-28 14:18:49”, “2017-07-28 14:18:49”, “email.open”, 1, 9]: SQLSTATE[HY000]: General error: 2006 MySQL server has gone away” at /var/www/html/mautic/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/AbstractMySQLDriver.php line 115 {“exception”:"[object] (Doctrine\DBAL\Exception\DriverException(code: 0): An exception occurred while executing ‘SELECT c0_.id AS id_0, c0_.name AS name_1, c0_.description AS description_2, c0_.type AS type_3, c0_.event_type AS event_type_4, c0_.event_order AS event_order_5, c0_.properties AS properties_6, c0_.trigger_date AS trigger_date_7, c0_.trigger_interval AS trigger_interval_8, c0_.trigger_interval_unit AS trigger_interval_unit_9, c0_.trigger_mode AS trigger_mode_10, c0_.decision_path AS decision_path_11, c0_.temp_id AS temp_id_12, c0_.channel AS channel_13, c0_.channel_id AS channel_id_14, c1_.is_published AS is_published_15, c1_.date_added AS date_added_16, c1_.created_by AS created_by_17, c1_.created_by_user AS created_by_user_18, c1_.date_modified AS date_modified_19, c1_.modified_by AS modified_by_20, c1_.modified_by_user AS modified_by_user_21, c1_.checked_out AS checked_out_22, c1_.checked_out_by AS checked_out_by_23, c1_.checked_out_by_user AS checked_out_by_user_24, c1_.id AS id_25, c1_.name AS name_26, c1_.description AS description_27, c1_.publish_up AS publish_up_28, c1_.publish_down AS publish_down_29, c1_.canvas_settings AS canvas_settings_30, c2_.id AS id_31, c2_.name AS name_32, c2_.description AS description_33, c2_.type AS type_34, c2_.event_type AS event_type_35, c2_.event_order AS event_order_36, c2_.properties AS properties_37, c2_.trigger_date AS trigger_date_38, c2_.trigger_interval AS trigger_interval_39, c2_.trigger_interval_unit AS trigger_interval_unit_40, c2_.trigger_mode AS trigger_mode_41, c2_.decision_path AS decision_path_42, c2_.temp_id AS temp_id_43, c2_.channel AS channel_44, c2_.channel_id AS channel_id_45, c3_.id AS id_46, c3_.name AS name_47, c3_.description AS description_48, c3_.type AS type_49, c3_.event_type AS event_type_50, c3_.event_order AS event_order_51, c3_.properties AS properties_52, c3_.trigger_date AS trigger_date_53, c3_.trigger_interval AS trigger_interval_54, c3_.trigger_interval_unit AS trigger_interval_unit_55, c3_.trigger_mode AS trigger_mode_56, c3_.decision_path AS decision_path_57, c3_.temp_id AS temp_id_58, c3_.channel AS channel_59, c3_.channel_id AS channel_id_60, c4_.is_published AS is_published_61, c4_.date_added AS date_added_62, c4_.created_by AS created_by_63, c4_.created_by_user AS created_by_user_64, c4_.date_modified AS date_modified_65, c4_.modified_by AS modified_by_66, c4_.modified_by_user AS modified_by_user_67, c4_.checked_out AS checked_out_68, c4_.checked_out_by AS checked_out_by_69, c4_.checked_out_by_user AS checked_out_by_user_70, c4_.id AS id_71, c4_.name AS name_72, c4_.description AS description_73, c4_.publish_up AS publish_up_74, c4_.publish_down AS publish_down_75, c4_.canvas_settings AS canvas_settings_76 FROM campaign_events c0_ INNER JOIN campaigns c1_ ON c0_.campaign_id = c1_.id LEFT JOIN campaign_events c2_ ON c0_.id = c2_.parent_id LEFT JOIN campaign_events c3_ ON c0_.parent_id = c3_.id LEFT JOIN campaigns c4_ ON c2_.campaign_id = c4_.id WHERE c1_.is_published = ? AND (c1_.publish_down IS NULL OR c1_.publish_down >= ?) AND (c1_.publish_up IS NULL OR c1_.publish_up <= ?) AND c0_.type = ? AND c1_.id IN (?) AND (c0_.id NOT IN (SELECT c5_.id FROM campaign_lead_event_log c6_ LEFT JOIN campaign_events c5_ ON c6_.event_id = c5_.id LEFT JOIN leads l7_ ON c6_.lead_id = l7_.id WHERE c5_.id = c0_.id AND l7_.id = ?)) AND (c0_.decision_path <> ‘no’ OR c0_.decision_path IS NULL) ORDER BY c0_.event_order ASC, c2_.event_order ASC’ with params [1, “2017-07-28 14:18:49”, “2017-07-28 14:18:49”, “email.open”, 1, 9]:nnSQLSTATE[HY000]: General error: 2006 MySQL server has gone away at /var/www/html/mautic/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/AbstractMySQLDriver.php:115, Doctrine\DBAL\Driver\PDOException(code: HY000): SQLSTATE[HY000]: General error: 2006 MySQL server has gone away at /var/www/html/mautic/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOStatement.php:93, PDOException(code: HY000): SQLSTATE[HY000]: General error: 2006 MySQL server has gone away at /var/www/html/mautic/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOStatement.php:91)"} []

Getting this error While Clicking on " Having Trouble Shoot…" in email. and the Tracking GIF is not working showing 500 internal server error.

[2017-07-28 14:18:49] mautic.WARNING: PHP Warning - PDOStatement::execute(): MySQL server has gone away - in file /var/www/html/mautic/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOStatement.php - at line 91 [] []
[2017-07-28 14:18:49] mautic.WARNING: PHP Warning - PDOStatement::execute(): Error reading result set’s header - in file /var/www/html/mautic/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOStatement.php - at line 91 [] []
[2017-07-28 14:18:49] mautic.CRITICAL: Uncaught PHP Exception DoctrineDBALExceptionDriverException: “An exception occurred while executing ‘SELECT c0_.id AS id_0, c0_.name AS name_1, c0_.description AS description_2, c0_.type AS type_3, c0_.event_type AS event_type_4, c0_.event_order AS event_order_5, c0_.properties AS properties_6, c0_.trigger_date AS trigger_date_7, c0_.trigger_interval AS trigger_interval_8, c0_.trigger_interval_unit AS trigger_interval_unit_9, c0_.trigger_mode AS trigger_mode_10, c0_.decision_path AS decision_path_11, c0_.temp_id AS temp_id_12, c0_.channel AS channel_13, c0_.channel_id AS channel_id_14, c1_.is_published AS is_published_15, c1_.date_added AS date_added_16, c1_.created_by AS created_by_17, c1_.created_by_user AS created_by_user_18, c1_.date_modified AS date_modified_19, c1_.modified_by AS modified_by_20, c1_.modified_by_user AS modified_by_user_21, c1_.checked_out AS checked_out_22, c1_.checked_out_by AS checked_out_by_23, c1_.checked_out_by_user AS checked_out_by_user_24, c1_.id AS id_25, c1_.name AS name_26, c1_.description AS description_27, c1_.publish_up AS publish_up_28, c1_.publish_down AS publish_down_29, c1_.canvas_settings AS canvas_settings_30, c2_.id AS id_31, c2_.name AS name_32, c2_.description AS description_33, c2_.type AS type_34, c2_.event_type AS event_type_35, c2_.event_order AS event_order_36, c2_.properties AS properties_37, c2_.trigger_date AS trigger_date_38, c2_.trigger_interval AS trigger_interval_39, c2_.trigger_interval_unit AS trigger_interval_unit_40, c2_.trigger_mode AS trigger_mode_41, c2_.decision_path AS decision_path_42, c2_.temp_id AS temp_id_43, c2_.channel AS channel_44, c2_.channel_id AS channel_id_45, c3_.id AS id_46, c3_.name AS name_47, c3_.description AS description_48, c3_.type AS type_49, c3_.event_type AS event_type_50, c3_.event_order AS event_order_51, c3_.properties AS properties_52, c3_.trigger_date AS trigger_date_53, c3_.trigger_interval AS trigger_interval_54, c3_.trigger_interval_unit AS trigger_interval_unit_55, c3_.trigger_mode AS trigger_mode_56, c3_.decision_path AS decision_path_57, c3_.temp_id AS temp_id_58, c3_.channel AS channel_59, c3_.channel_id AS channel_id_60, c4_.is_published AS is_published_61, c4_.date_added AS date_added_62, c4_.created_by AS created_by_63, c4_.created_by_user AS created_by_user_64, c4_.date_modified AS date_modified_65, c4_.modified_by AS modified_by_66, c4_.modified_by_user AS modified_by_user_67, c4_.checked_out AS checked_out_68, c4_.checked_out_by AS checked_out_by_69, c4_.checked_out_by_user AS checked_out_by_user_70, c4_.id AS id_71, c4_.name AS name_72, c4_.description AS description_73, c4_.publish_up AS publish_up_74, c4_.publish_down AS publish_down_75, c4_.canvas_settings AS canvas_settings_76 FROM campaign_events c0_ INNER JOIN campaigns c1_ ON c0_.campaign_id = c1_.id LEFT JOIN campaign_events c2_ ON c0_.id = c2_.parent_id LEFT JOIN campaign_events c3_ ON c0_.parent_id = c3_.id LEFT JOIN campaigns c4_ ON c2_.campaign_id = c4_.id WHERE c1_.is_published = ? AND (c1_.publish_down IS NULL OR c1_.publish_down >= ?) AND (c1_.publish_up IS NULL OR c1_.publish_up <= ?) AND c0_.type = ? AND c1_.id IN (?) AND (c0_.id NOT IN (SELECT c5_.id FROM campaign_lead_event_log c6_ LEFT JOIN campaign_events c5_ ON c6_.event_id = c5_.id LEFT JOIN leads l7_ ON c6_.lead_id = l7_.id WHERE c5_.id = c0_.id AND l7_.id = ?)) AND (c0_.decision_path <> ‘no’ OR c0_.decision_path IS NULL) ORDER BY c0_.event_order ASC, c2_.event_order ASC’ with params [1, “2017-07-28 14:18:49”, “2017-07-28 14:18:49”, “email.open”, 1, 9]: SQLSTATE[HY000]: General error: 2006 MySQL server has gone away” at /var/www/html/mautic/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/AbstractMySQLDriver.php line 115 {“exception”:"[object] (Doctrine\DBAL\Exception\DriverException(code: 0): An exception occurred while executing ‘SELECT c0_.id AS id_0, c0_.name AS name_1, c0_.description AS description_2, c0_.type AS type_3, c0_.event_type AS event_type_4, c0_.event_order AS event_order_5, c0_.properties AS properties_6, c0_.trigger_date AS trigger_date_7, c0_.trigger_interval AS trigger_interval_8, c0_.trigger_interval_unit AS trigger_interval_unit_9, c0_.trigger_mode AS trigger_mode_10, c0_.decision_path AS decision_path_11, c0_.temp_id AS temp_id_12, c0_.channel AS channel_13, c0_.channel_id AS channel_id_14, c1_.is_published AS is_published_15, c1_.date_added AS date_added_16, c1_.created_by AS created_by_17, c1_.created_by_user AS created_by_user_18, c1_.date_modified AS date_modified_19, c1_.modified_by AS modified_by_20, c1_.modified_by_user AS modified_by_user_21, c1_.checked_out AS checked_out_22, c1_.checked_out_by AS checked_out_by_23, c1_.checked_out_by_user AS checked_out_by_user_24, c1_.id AS id_25, c1_.name AS name_26, c1_.description AS description_27, c1_.publish_up AS publish_up_28, c1_.publish_down AS publish_down_29, c1_.canvas_settings AS canvas_settings_30, c2_.id AS id_31, c2_.name AS name_32, c2_.description AS description_33, c2_.type AS type_34, c2_.event_type AS event_type_35, c2_.event_order AS event_order_36, c2_.properties AS properties_37, c2_.trigger_date AS trigger_date_38, c2_.trigger_interval AS trigger_interval_39, c2_.trigger_interval_unit AS trigger_interval_unit_40, c2_.trigger_mode AS trigger_mode_41, c2_.decision_path AS decision_path_42, c2_.temp_id AS temp_id_43, c2_.channel AS channel_44, c2_.channel_id AS channel_id_45, c3_.id AS id_46, c3_.name AS name_47, c3_.description AS description_48, c3_.type AS type_49, c3_.event_type AS event_type_50, c3_.event_order AS event_order_51, c3_.properties AS properties_52, c3_.trigger_date AS trigger_date_53, c3_.trigger_interval AS trigger_interval_54, c3_.trigger_interval_unit AS trigger_interval_unit_55, c3_.trigger_mode AS trigger_mode_56, c3_.decision_path AS decision_path_57, c3_.temp_id AS temp_id_58, c3_.channel AS channel_59, c3_.channel_id AS channel_id_60, c4_.is_published AS is_published_61, c4_.date_added AS date_added_62, c4_.created_by AS created_by_63, c4_.created_by_user AS created_by_user_64, c4_.date_modified AS date_modified_65, c4_.modified_by AS modified_by_66, c4_.modified_by_user AS modified_by_user_67, c4_.checked_out AS checked_out_68, c4_.checked_out_by AS checked_out_by_69, c4_.checked_out_by_user AS checked_out_by_user_70, c4_.id AS id_71, c4_.name AS name_72, c4_.description AS description_73, c4_.publish_up AS publish_up_74, c4_.publish_down AS publish_down_75, c4_.canvas_settings AS canvas_settings_76 FROM campaign_events c0_ INNER JOIN campaigns c1_ ON c0_.campaign_id = c1_.id LEFT JOIN campaign_events c2_ ON c0_.id = c2_.parent_id LEFT JOIN campaign_events c3_ ON c0_.parent_id = c3_.id LEFT JOIN campaigns c4_ ON c2_.campaign_id = c4_.id WHERE c1_.is_published = ? AND (c1_.publish_down IS NULL OR c1_.publish_down >= ?) AND (c1_.publish_up IS NULL OR c1_.publish_up <= ?) AND c0_.type = ? AND c1_.id IN (?) AND (c0_.id NOT IN (SELECT c5_.id FROM campaign_lead_event_log c6_ LEFT JOIN campaign_events c5_ ON c6_.event_id = c5_.id LEFT JOIN leads l7_ ON c6_.lead_id = l7_.id WHERE c5_.id = c0_.id AND l7_.id = ?)) AND (c0_.decision_path <> ‘no’ OR c0_.decision_path IS NULL) ORDER BY c0_.event_order ASC, c2_.event_order ASC’ with params [1, “2017-07-28 14:18:49”, “2017-07-28 14:18:49”, “email.open”, 1, 9]:nnSQLSTATE[HY000]: General error: 2006 MySQL server has gone away at /var/www/html/mautic/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/AbstractMySQLDriver.php:115, Doctrine\DBAL\Driver\PDOException(code: HY000): SQLSTATE[HY000]: General error: 2006 MySQL server has gone away at /var/www/html/mautic/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOStatement.php:93, PDOException(code: HY000): SQLSTATE[HY000]: General error: 2006 MySQL server has gone away at /var/www/html/mautic/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOStatement.php:91)"} []