Symfony Error on 2.0

Product Support
1

I’m having issues with a Mautic 2.0. Installation. Here is some documentation: https://developer.mautic.org/#symfony



The installation was working fine- I setup all my plugins- the configuration stuff- everything was working fine. . I was troubleshooting the Bounce email setting and selected SSL email and ever since then, it’s been hanging on the configuration screen. I think it actually crashes the system because I have to login again afterwards.



After making those changes, now the configuration screen just hangs for a few minutes and then stops loading. The logs say symphony is out of date and I was trying to upgrade it All the other pages- even in settings work fine. Just that one page that I can’t click to.



Here’s the entire log file:

Code:
[2016-08-01 06:13:13] mautic.ERROR: Deprecation: Accessing type "text" by its string name is deprecated since version 2.8 and will be removed in 3.0. Use the fully-qualified type class name "SymfonyComponentFormExtensionCoreTypeTextType" instead. - in file /home/m2wire/public_html/matic/vendor/symfony/form/FormRegistry.php - at line 100 [] [] [2016-08-01 06:13:13] mautic.CRITICAL: Uncaught PHP Exception DoctrineDBALExceptionDriverException: "An exception occurred while executing 'SELECT u0_.is_published AS is_published_0, u0_.date_added AS date_added_1, u0_.created_by AS created_by_2, u0_.created_by_user AS created_by_user_3, u0_.date_modified AS date_modified_4, u0_.modified_by AS modified_by_5, u0_.modified_by_user AS modified_by_user_6, u0_.checked_out AS checked_out_7, u0_.checked_out_by AS checked_out_by_8, u0_.checked_out_by_user AS checked_out_by_user_9, u0_.id AS id_10, u0_.username AS username_11, u0_.password AS password_12, u0_.first_name AS first_name_13, u0_.last_name AS last_name_14, u0_.email AS email_15, u0_.position AS position_16, u0_.timezone AS timezone_17, u0_.locale AS locale_18, u0_.last_login AS last_login_19, u0_.last_active AS last_active_20, u0_.online_status AS online_status_21, u0_.preferences AS preferences_22, u0_.signature AS signature_23, r1_.is_published AS is_published_24, r1_.date_added AS date_added_25, r1_.created_by AS created_by_26, r1_.created_by_user AS created_by_user_27, r1_.date_modified AS date_modified_28, r1_.modified_by AS modified_by_29, r1_.modified_by_user AS modified_by_user_30, r1_.checked_out AS checked_out_31, r1_.checked_out_by AS checked_out_by_32, r1_.checked_out_by_user AS checked_out_by_user_33, r1_.id AS id_34, r1_.name AS name_35, r1_.description AS description_36, r1_.is_admin AS is_admin_37, r1_.readable_permissions AS readable_permissions_38, u0_.role_id AS role_id_39 FROM users u0_ LEFT JOIN roles r1_ ON u0_.role_id = r1_.id WHERE u0_.username = ? OR u0_.email = ?' with params ["jbenjamin", "jbenjamin"]: SQLSTATE[HY000]: General error: 2006 MySQL server has gone away" at /home/m2wire/public_html/matic/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 u0_.is_published AS is_published_0, u0_.date_added AS date_added_1, u0_.created_by AS created_by_2, u0_.created_by_user AS created_by_user_3, u0_.date_modified AS date_modified_4, u0_.modified_by AS modified_by_5, u0_.modified_by_user AS modified_by_user_6, u0_.checked_out AS checked_out_7, u0_.checked_out_by AS checked_out_by_8, u0_.checked_out_by_user AS checked_out_by_user_9, u0_.id AS id_10, u0_.username AS username_11, u0_.password AS password_12, u0_.first_name AS first_name_13, u0_.last_name AS last_name_14, u0_.email AS email_15, u0_.position AS position_16, u0_.timezone AS timezone_17, u0_.locale AS locale_18, u0_.last_login AS last_login_19, u0_.last_active AS last_active_20, u0_.online_status AS online_status_21, u0_.preferences AS preferences_22, u0_.signature AS signature_23, r1_.is_published AS is_published_24, r1_.date_added AS date_added_25, r1_.created_by AS created_by_26, r1_.created_by_user AS created_by_user_27, r1_.date_modified AS date_modified_28, r1_.modified_by AS modified_by_29, r1_.modified_by_user AS modified_by_user_30, r1_.checked_out AS checked_out_31, r1_.checked_out_by AS checked_out_by_32, r1_.checked_out_by_user AS checked_out_by_user_33, r1_.id AS id_34, r1_.name AS name_35, r1_.description AS description_36, r1_.is_admin AS is_admin_37, r1_.readable_permissions AS readable_permissions_38, u0_.role_id AS role_id_39 FROM users u0_ LEFT JOIN roles r1_ ON u0_.role_id = r1_.id WHERE u0_.username = ? OR u0_.email = ?' with params ["jbenjamin", "jbenjamin"]:nnSQLSTATE[HY000]: General error: 2006 MySQL server has gone away at /home/m2wire/public_html/matic/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 /home/m2wire/public_html/matic/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOStatement.php:93, PDOException(code: HY000): SQLSTATE[HY000]: General error: 2006 MySQL server has gone away at /home/m2wire/public_html/matic/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOStatement.php:91)"} [] [2016-08-01 06:13:13] mautic.ERROR: Deprecation: The SymfonyComponentSecurityCoreSecurityContext class is deprecated since version 2.6 and will be removed in 3.0. Use SymfonyComponentSecurityCoreAuthenticationTokenStorageTokenStorage or SymfonyComponentSecurityCoreAuthorizationAuthorizationChecker instead. - in file /home/m2wire/public_html/matic/vendor/symfony/security/Core/SecurityContext.php - at line 14 [] [] [2016-08-01 06:13:14] mautic.ERROR: Deprecation: The SymfonyComponentSecurityCoreSecurityContext class is deprecated since version 2.6 and will be removed in 3.0. Use SymfonyComponentSecurityCoreAuthenticationTokenStorageTokenStorage or SymfonyComponentSecurityCoreAuthorizationAuthorizationChecker instead. - in file /home/m2wire/public_html/matic/vendor/symfony/security/Core/SecurityContext.php - at line 14 [] [] [2016-08-01 06:15:04] mautic.NOTICE: SymfonyComponentConsoleExceptionRuntimeException: Too many arguments. (uncaught exception) at /home/m2wire/public_html/matic/vendor/symfony/console/Input/ArgvInput.php line 179 while running console command `mautic:segments:update` [] [] [2016-08-01 06:15:34] mautic.NOTICE: Swift_TransportException: Connection to ssl://m2wire.com:993 Timed Out (uncaught exception) at /home/m2wire/public_html/matic/vendor/swiftmailer/swiftmailer/lib/classes/Swift/Transport/AbstractSmtpTransport.php line 404 while running console command `mautic:emails:send` [] [] [2016-08-01 06:17:53] mautic.ERROR: Deprecation: The SymfonyComponentSecurityCoreSecurityContext class is deprecated since version 2.6 and will be removed in 3.0. Use SymfonyComponentSecurityCoreAuthenticationTokenStorageTokenStorage or SymfonyComponentSecurityCoreAuthorizationAuthorizationChecker instead. - in file /home/m2wire/public_html/matic/vendor/symfony/security/Core/SecurityContext.php - at line 14 [] [] [2016-08-01 06:18:01] mautic.ERROR: Deprecation: The SymfonyComponentSecurityCoreSecurityContext class is deprecated since version 2.6 and will be removed in 3.0. Use SymfonyComponentSecurityCoreAuthenticationTokenStorageTokenStorage or SymfonyComponentSecurityCoreAuthorizationAuthorizationChecker instead. - in file /home/m2wire/public_html/matic/vendor/symfony/security/Core/SecurityContext.php - at line 14 [] [] [2016-08-01 06:18:03] mautic.ERROR: Deprecation: The SymfonyComponentSecurityCoreSecurityContext class is deprecated since version 2.6 and will be removed in 3.0. Use SymfonyComponentSecurityCoreAuthenticationTokenStorageTokenStorage or SymfonyComponentSecurityCoreAuthorizationAuthorizationChecker instead. - in file /home/m2wire/public_html/matic/vendor/symfony/security/Core/SecurityContext.php - at line 14 [] [] [2016-08-01 06:18:04] mautic.ERROR: Deprecation: Accessing type "submit" by its string name is deprecated since version 2.8 and will be removed in 3.0. Use the fully-qualified type class name "SymfonyComponentFormExtensionCoreTypeSubmitType" instead. - in file /home/m2wire/public_html/matic/vendor/symfony/form/FormRegistry.php - at line 100 [] []
2

I’m having issues with a Mautic 2.0. Installation. Here is some documentation: https://developer.mautic.org/#symfony

The installation was working fine- I setup all my plugins- the configuration stuff- everything was working fine. . I was troubleshooting the Bounce email setting and selected SSL email and ever since then, it’s been hanging on the configuration screen. I think it actually crashes the system because I have to login again afterwards.

After making those changes, now the configuration screen just hangs for a few minutes and then stops loading. The logs say symphony is out of date and I was trying to upgrade it All the other pages- even in settings work fine. Just that one page that I can’t click to.

Here’s the entire log file:

[2016-08-01 06:13:13] mautic.ERROR: Deprecation: Accessing type "text" by its string name is deprecated since version 2.8 and will be removed in 3.0. Use the fully-qualified type class name "SymfonyComponentFormExtensionCoreTypeTextType" instead. - in file /home/m2wire/public_html/matic/vendor/symfony/form/FormRegistry.php - at line 100 [] [] [2016-08-01 06:13:13] mautic.CRITICAL: Uncaught PHP Exception DoctrineDBALExceptionDriverException: "An exception occurred while executing 'SELECT u0_.is_published AS is_published_0, u0_.date_added AS date_added_1, u0_.created_by AS created_by_2, u0_.created_by_user AS created_by_user_3, u0_.date_modified AS date_modified_4, u0_.modified_by AS modified_by_5, u0_.modified_by_user AS modified_by_user_6, u0_.checked_out AS checked_out_7, u0_.checked_out_by AS checked_out_by_8, u0_.checked_out_by_user AS checked_out_by_user_9, u0_.id AS id_10, u0_.username AS username_11, u0_.password AS password_12, u0_.first_name AS first_name_13, u0_.last_name AS last_name_14, u0_.email AS email_15, u0_.position AS position_16, u0_.timezone AS timezone_17, u0_.locale AS locale_18, u0_.last_login AS last_login_19, u0_.last_active AS last_active_20, u0_.online_status AS online_status_21, u0_.preferences AS preferences_22, u0_.signature AS signature_23, r1_.is_published AS is_published_24, r1_.date_added AS date_added_25, r1_.created_by AS created_by_26, r1_.created_by_user AS created_by_user_27, r1_.date_modified AS date_modified_28, r1_.modified_by AS modified_by_29, r1_.modified_by_user AS modified_by_user_30, r1_.checked_out AS checked_out_31, r1_.checked_out_by AS checked_out_by_32, r1_.checked_out_by_user AS checked_out_by_user_33, r1_.id AS id_34, r1_.name AS name_35, r1_.description AS description_36, r1_.is_admin AS is_admin_37, r1_.readable_permissions AS readable_permissions_38, u0_.role_id AS role_id_39 FROM users u0_ LEFT JOIN roles r1_ ON u0_.role_id = r1_.id WHERE u0_.username = ? OR u0_.email = ?' with params ["jbenjamin", "jbenjamin"]: SQLSTATE[HY000]: General error: 2006 MySQL server has gone away" at /home/m2wire/public_html/matic/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 u0_.is_published AS is_published_0, u0_.date_added AS date_added_1, u0_.created_by AS created_by_2, u0_.created_by_user AS created_by_user_3, u0_.date_modified AS date_modified_4, u0_.modified_by AS modified_by_5, u0_.modified_by_user AS modified_by_user_6, u0_.checked_out AS checked_out_7, u0_.checked_out_by AS checked_out_by_8, u0_.checked_out_by_user AS checked_out_by_user_9, u0_.id AS id_10, u0_.username AS username_11, u0_.password AS password_12, u0_.first_name AS first_name_13, u0_.last_name AS last_name_14, u0_.email AS email_15, u0_.position AS position_16, u0_.timezone AS timezone_17, u0_.locale AS locale_18, u0_.last_login AS last_login_19, u0_.last_active AS last_active_20, u0_.online_status AS online_status_21, u0_.preferences AS preferences_22, u0_.signature AS signature_23, r1_.is_published AS is_published_24, r1_.date_added AS date_added_25, r1_.created_by AS created_by_26, r1_.created_by_user AS created_by_user_27, r1_.date_modified AS date_modified_28, r1_.modified_by AS modified_by_29, r1_.modified_by_user AS modified_by_user_30, r1_.checked_out AS checked_out_31, r1_.checked_out_by AS checked_out_by_32, r1_.checked_out_by_user AS checked_out_by_user_33, r1_.id AS id_34, r1_.name AS name_35, r1_.description AS description_36, r1_.is_admin AS is_admin_37, r1_.readable_permissions AS readable_permissions_38, u0_.role_id AS role_id_39 FROM users u0_ LEFT JOIN roles r1_ ON u0_.role_id = r1_.id WHERE u0_.username = ? OR u0_.email = ?' with params ["jbenjamin", "jbenjamin"]:nnSQLSTATE[HY000]: General error: 2006 MySQL server has gone away at /home/m2wire/public_html/matic/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 /home/m2wire/public_html/matic/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOStatement.php:93, PDOException(code: HY000): SQLSTATE[HY000]: General error: 2006 MySQL server has gone away at /home/m2wire/public_html/matic/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOStatement.php:91)"} [] [2016-08-01 06:13:13] mautic.ERROR: Deprecation: The SymfonyComponentSecurityCoreSecurityContext class is deprecated since version 2.6 and will be removed in 3.0. Use SymfonyComponentSecurityCoreAuthenticationTokenStorageTokenStorage or SymfonyComponentSecurityCoreAuthorizationAuthorizationChecker instead. - in file /home/m2wire/public_html/matic/vendor/symfony/security/Core/SecurityContext.php - at line 14 [] [] [2016-08-01 06:13:14] mautic.ERROR: Deprecation: The SymfonyComponentSecurityCoreSecurityContext class is deprecated since version 2.6 and will be removed in 3.0. Use SymfonyComponentSecurityCoreAuthenticationTokenStorageTokenStorage or SymfonyComponentSecurityCoreAuthorizationAuthorizationChecker instead. - in file /home/m2wire/public_html/matic/vendor/symfony/security/Core/SecurityContext.php - at line 14 [] [] [2016-08-01 06:15:04] mautic.NOTICE: SymfonyComponentConsoleExceptionRuntimeException: Too many arguments. (uncaught exception) at /home/m2wire/public_html/matic/vendor/symfony/console/Input/ArgvInput.php line 179 while running console command `mautic:segments:update` [] [] [2016-08-01 06:15:34] mautic.NOTICE: Swift_TransportException: Connection to ssl://m2wire.com:993 Timed Out (uncaught exception) at /home/m2wire/public_html/matic/vendor/swiftmailer/swiftmailer/lib/classes/Swift/Transport/AbstractSmtpTransport.php line 404 while running console command `mautic:emails:send` [] [] [2016-08-01 06:17:53] mautic.ERROR: Deprecation: The SymfonyComponentSecurityCoreSecurityContext class is deprecated since version 2.6 and will be removed in 3.0. Use SymfonyComponentSecurityCoreAuthenticationTokenStorageTokenStorage or SymfonyComponentSecurityCoreAuthorizationAuthorizationChecker instead. - in file /home/m2wire/public_html/matic/vendor/symfony/security/Core/SecurityContext.php - at line 14 [] [] [2016-08-01 06:18:01] mautic.ERROR: Deprecation: The SymfonyComponentSecurityCoreSecurityContext class is deprecated since version 2.6 and will be removed in 3.0. Use SymfonyComponentSecurityCoreAuthenticationTokenStorageTokenStorage or SymfonyComponentSecurityCoreAuthorizationAuthorizationChecker instead. - in file /home/m2wire/public_html/matic/vendor/symfony/security/Core/SecurityContext.php - at line 14 [] [] [2016-08-01 06:18:03] mautic.ERROR: Deprecation: The SymfonyComponentSecurityCoreSecurityContext class is deprecated since version 2.6 and will be removed in 3.0. Use SymfonyComponentSecurityCoreAuthenticationTokenStorageTokenStorage or SymfonyComponentSecurityCoreAuthorizationAuthorizationChecker instead. - in file /home/m2wire/public_html/matic/vendor/symfony/security/Core/SecurityContext.php - at line 14 [] [] [2016-08-01 06:18:04] mautic.ERROR: Deprecation: Accessing type "submit" by its string name is deprecated since version 2.8 and will be removed in 3.0. Use the fully-qualified type class name "SymfonyComponentFormExtensionCoreTypeSubmitType" instead. - in file /home/m2wire/public_html/matic/vendor/symfony/form/FormRegistry.php - at line 100 [] []

3

Actually, the deprecation errors are just reminders for developers to update those parts before upgrading to Symfony 3.0. It should not break anything. The only real problem I see in the log is

Your MySql server died before it was able to finish the query. It happened to be because of too small memory limit. Consult it with your server provider.

But it shouldn’t be related to configuration saving. The configuration is saved to a file. That being said, consult with your provider also the file permissions and ownership.

4

Knownhost, my vps company said that they didn’t see any errors in SQL. He opened port 993 outgoing firewall and told me to try it again. same errors.

5

[2016-08-02 16:18:32] mautic.ERROR: Deprecation: The SymfonyComponentSecurityCoreSecurityContext class is deprecated since version 2.6 and will be removed in 3.0. Use SymfonyComponentSecurityCoreAuthenticationTokenStorageTokenStorage or SymfonyComponentSecurityCoreAuthorizationAuthorizationChecker instead. - in file /home/m2wire/public_html/matic/vendor/symfony/security/Core/SecurityContext.php - at line 14 [] [] [2016-08-02 16:18:32] mautic.ERROR: Deprecation: Accessing type "submit" by its string name is deprecated since version 2.8 and will be removed in 3.0. Use the fully-qualified type class name "SymfonyComponentFormExtensionCoreTypeSubmitType" instead. - in file /home/m2wire/public_html/matic/vendor/symfony/form/FormRegistry.php - at line 100 [] [] [2016-08-02 16:19:13] mautic.ERROR: Deprecation: The SymfonyComponentSecurityCoreSecurityContext class is deprecated since version 2.6 and will be removed in 3.0. Use SymfonyComponentSecurityCoreAuthenticationTokenStorageTokenStorage or SymfonyComponentSecurityCoreAuthorizationAuthorizationChecker instead. - in file /home/m2wire/public_html/matic/vendor/symfony/security/Core/SecurityContext.php - at line 14 [] [] [2016-08-02 16:20:01] mautic.NOTICE: SymfonyComponentConsoleExceptionRuntimeException: Too many arguments. (uncaught exception) at /home/m2wire/public_html/matic/vendor/symfony/console/Input/ArgvInput.php line 179 while running console command `mautic:segments:update` [] [] [2016-08-02 16:20:32] mautic.NOTICE: Swift_TransportException: Connection to ssl://m2wire.com:993 Timed Out (uncaught exception) at /home/m2wire/public_html/matic/vendor/swiftmailer/swiftmailer/lib/classes/Swift/Transport/AbstractSmtpTransport.php line 404 while running console command `mautic:emails:send` [] [] [2016-08-02 16:21:40] mautic.CRITICAL: Uncaught PHP Exception DoctrineDBALExceptionDriverException: "An exception occurred while executing 'SELECT n0_.id AS id_0, n0_.type AS type_1, n0_.header AS header_2, n0_.message AS message_3, n0_.date_added AS date_added_4, n0_.icon_class AS icon_class_5, n0_.is_read AS is_read_6 FROM notifications n0_ WHERE n0_.user_id = ? AND n0_.id > ? ORDER BY n0_.date_added DESC' with params [1, 13]: SQLSTATE[HY000]: General error: 2006 MySQL server has gone away" at /home/m2wire/public_html/matic/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 n0_.id AS id_0, n0_.type AS type_1, n0_.header AS header_2, n0_.message AS message_3, n0_.date_added AS date_added_4, n0_.icon_class AS icon_class_5, n0_.is_read AS is_read_6 FROM notifications n0_ WHERE n0_.user_id = ? AND n0_.id > ? ORDER BY n0_.date_added DESC' with params [1, 13]:nnSQLSTATE[HY000]: General error: 2006 MySQL server has gone away at /home/m2wire/public_html/matic/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 /home/m2wire/public_html/matic/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOStatement.php:93, PDOException(code: HY000): SQLSTATE[HY000]: General error: 2006 MySQL server has gone away at /home/m2wire/public_html/matic/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOStatement.php:91)"} [] [2016-08-02 16:21:40] mautic.CRITICAL: Exception thrown when handling an exception (DoctrineDBALExceptionDriverException: An exception occurred while executing 'SELECT n0_.id AS id_0, n0_.type AS type_1, n0_.header AS header_2, n0_.message AS message_3, n0_.date_added AS date_added_4, n0_.icon_class AS icon_class_5, n0_.is_read AS is_read_6 FROM notifications n0_ WHERE n0_.user_id = ? AND n0_.id > ? ORDER BY n0_.date_added DESC' with params [1, 13]: SQLSTATE[HY000]: General error: 2006 MySQL server has gone away at /home/m2wire/public_html/matic/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 n0_.id AS id_0, n0_.type AS type_1, n0_.header AS header_2, n0_.message AS message_3, n0_.date_added AS date_added_4, n0_.icon_class AS icon_class_5, n0_.is_read AS is_read_6 FROM notifications n0_ WHERE n0_.user_id = ? AND n0_.id > ? ORDER BY n0_.date_added DESC' with params [1, 13]:nnSQLSTATE[HY000]: General error: 2006 MySQL server has gone away at /home/m2wire/public_html/matic/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 /home/m2wire/public_html/matic/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOStatement.php:93, PDOException(code: HY000): SQLSTATE[HY000]: General error: 2006 MySQL server has gone away at /home/m2wire/public_html/matic/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOStatement.php:91)"} [] [2016-08-02 16:21:40] mautic.ERROR: Deprecation: Accessing type "text" by its string name is deprecated since version 2.8 and will be removed in 3.0. Use the fully-qualified type class name "SymfonyComponentFormExtensionCoreTypeTextType" instead. - in file /home/m2wire/public_html/matic/vendor/symfony/form/FormRegistry.php - at line 100 [] [] [2016-08-02 16:21:41] mautic.CRITICAL: Uncaught PHP Exception DoctrineDBALExceptionDriverException: "An exception occurred while executing 'SELECT u0_.is_published AS is_published_0, u0_.date_added AS date_added_1, u0_.created_by AS created_by_2, u0_.created_by_user AS created_by_user_3, u0_.date_modified AS date_modified_4, u0_.modified_by AS modified_by_5, u0_.modified_by_user AS modified_by_user_6, u0_.checked_out AS checked_out_7, u0_.checked_out_by AS checked_out_by_8, u0_.checked_out_by_user AS checked_out_by_user_9, u0_.id AS id_10, u0_.username AS username_11, u0_.password AS password_12, u0_.first_name AS first_name_13, u0_.last_name AS last_name_14, u0_.email AS email_15, u0_.position AS position_16, u0_.timezone AS timezone_17, u0_.locale AS locale_18, u0_.last_login AS last_login_19, u0_.last_active AS last_active_20, u0_.online_status AS online_status_21, u0_.preferences AS preferences_22, u0_.signature AS signature_23, r1_.is_published AS is_published_24, r1_.date_added AS date_added_25, r1_.created_by AS created_by_26, r1_.created_by_user AS created_by_user_27, r1_.date_modified AS date_modified_28, r1_.modified_by AS modified_by_29, r1_.modified_by_user AS modified_by_user_30, r1_.checked_out AS checked_out_31, r1_.checked_out_by AS checked_out_by_32, r1_.checked_out_by_user AS checked_out_by_user_33, r1_.id AS id_34, r1_.name AS name_35, r1_.description AS description_36, r1_.is_admin AS is_admin_37, r1_.readable_permissions AS readable_permissions_38, u0_.role_id AS role_id_39 FROM users u0_ LEFT JOIN roles r1_ ON u0_.role_id = r1_.id WHERE u0_.username = ? OR u0_.email = ?' with params ["jbenjamin", "jbenjamin"]: SQLSTATE[HY000]: General error: 2006 MySQL server has gone away" at /home/m2wire/public_html/matic/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 u0_.is_published AS is_published_0, u0_.date_added AS date_added_1, u0_.created_by AS created_by_2, u0_.created_by_user AS created_by_user_3, u0_.date_modified AS date_modified_4, u0_.modified_by AS modified_by_5, u0_.modified_by_user AS modified_by_user_6, u0_.checked_out AS checked_out_7, u0_.checked_out_by AS checked_out_by_8, u0_.checked_out_by_user AS checked_out_by_user_9, u0_.id AS id_10, u0_.username AS username_11, u0_.password AS password_12, u0_.first_name AS first_name_13, u0_.last_name AS last_name_14, u0_.email AS email_15, u0_.position AS position_16, u0_.timezone AS timezone_17, u0_.locale AS locale_18, u0_.last_login AS last_login_19, u0_.last_active AS last_active_20, u0_.online_status AS online_status_21, u0_.preferences AS preferences_22, u0_.signature AS signature_23, r1_.is_published AS is_published_24, r1_.date_added AS date_added_25, r1_.created_by AS created_by_26, r1_.created_by_user AS created_by_user_27, r1_.date_modified AS date_modified_28, r1_.modified_by AS modified_by_29, r1_.modified_by_user AS modified_by_user_30, r1_.checked_out AS checked_out_31, r1_.checked_out_by AS checked_out_by_32, r1_.checked_out_by_user AS checked_out_by_user_33, r1_.id AS id_34, r1_.name AS name_35, r1_.description AS description_36, r1_.is_admin AS is_admin_37, r1_.readable_permissions AS readable_permissions_38, u0_.role_id AS role_id_39 FROM users u0_ LEFT JOIN roles r1_ ON u0_.role_id = r1_.id WHERE u0_.username = ? OR u0_.email = ?' with params ["jbenjamin", "jbenjamin"]:nnSQLSTATE[HY000]: General error: 2006 MySQL server has gone away at /home/m2wire/public_html/matic/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 /home/m2wire/public_html/matic/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOStatement.php:93, PDOException(code: HY000): SQLSTATE[HY000]: General error: 2006 MySQL server has gone away at /home/m2wire/public_html/matic/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOStatement.php:91)"} []

6

Hi @MxyzptlkFishStix , I had issues finding it, but here it is-

query_cache_type=1
key_buffer_size=16M
max_connections=150
max_tmp_tables=1
table_open_cache=512
local-infile=0
query_cache_limit=1M
thread_cache_size=4
query_cache_size=32M
join_buffer_size=1M
innodb_file_per_table=1
default-storage-engine=MyISAM
innodb_use_native_aio=0
max_allowed_packet=268435456
open_files_limit=10000
innodb_buffer_pool_size=134217728
#character-set-server=utf8
#collation-server=utf8_unicode_ci
interactive_timeout=90
wait_timeout=90
performance_schema=0
thread_stack=256k
root@host [/home/m2wire/public_html/matic]#

7

OK so we got this…

https://paste.privatesystems.net/pastes/f6a4ffd7470a3f6b846400d0a835d05a

cP/144/10672 root@162.211.82.165 [~]# free -m
total used free shared buffers cached
Mem: 3072 2802 269 10 0 1766
-/+ buffers/cache: 1036 2035
Swap: 0 0 0

cP/144/10672 root@162.211.82.165 [~]# mysql
Server version: 5.6.30 MySQL Community Server (GPL)

8

Here:
[mysqld]
query_cache_type=1
key_buffer_size=16M
max_connections=150
max_tmp_tables=1
table_open_cache=512
local-infile=0
query_cache_limit=1M
thread_cache_size=4
query_cache_size=32M
join_buffer_size=1M
innodb_file_per_table=1
default-storage-engine=MyISAM
innodb_use_native_aio=0
max_allowed_packet=268435456
open_files_limit=10000
innodb_buffer_pool_size=134217728
#character-set-server=utf8
#collation-server=utf8_unicode_ci
interactive_timeout=90
wait_timeout=90
performance_schema=0
thread_stack=256k

i can change anything upon your recommendation, but I could also just reinstall this and it will work. The crappiest part is the social integrations, so I imagine I’ll do that last. If I can get this page to come up, or even edit a page or database, I feel it will work. I know that sounds weird because I’m new at all this, but I know in what order things stopped working. The problem has something to do with my bounce email settings. I cannot find those values in the database and even tryed searching through source.

9

Sorry, this may be a wild goose chase, but does everything over here look alright? i replaced my password with DELETED- if it’s a blank pass, than there was never a password in that field

[code]<?php
$parameters = array(
‘db_driver’ => ‘pdo_mysql’,
‘db_host’ => ‘localhost’,
‘db_table_prefix’ => null,
‘db_port’ => ‘3306’,
‘db_name’ => ‘m2wire_mautic’,
‘db_user’ => ‘m2wire_m2’,
‘db_password’ => ‘DELETED’,
‘db_server_version’ => ‘5.6.30’,
‘mailer_from_name’ => ‘Jay @ M2’,
‘mailer_from_email’ => ‘jay@m2wire.com’,
‘mailer_transport’ => ‘smtp’,
‘mailer_host’ => ‘m2wire.com’,
‘mailer_port’ => ‘993’,
‘mailer_user’ => ‘jay@m2wire.com’,
‘mailer_password’ => ‘DELETED’,
‘mailer_encryption’ => ‘ssl’,
‘mailer_auth_mode’ => ‘login’,
‘mailer_spool_type’ => ‘file’,
‘mailer_spool_path’ => ‘%kernel.root_dir%/spool’,
‘secret_key’ => ‘ab11f6918a191ecd24823023d0976966ab89d1cda34fc6939508752ecab46df8’,
‘site_url’ => ‘https://m2wire.com/matic’,
‘webroot’ => null,
‘cache_path’ => ‘/home/m2wire/public_html/matic/app/cache’,
‘log_path’ => ‘/home/m2wire/public_html/matic/app/logs’,
‘image_path’ => ‘media/images’,
‘theme’ => ‘oxygen’,
‘locale’ => ‘en_US’,
‘trusted_hosts’ => array(

),
'trusted_proxies' => array(

),
'rememberme_key' => '892e7ba9c69e4b30f04a95e3d595fccf02304c6a',
'rememberme_lifetime' => '31536000',
'rememberme_path' => '/',
'rememberme_domain' => null,
'default_pagelimit' => 30,
'default_timezone' => 'America/New_York',
'date_format_full' => 'F j, Y g:i a T',
'date_format_short' => 'D, M d',
'date_format_dateonly' => 'F j, Y',
'date_format_timeonly' => 'g:i a',
'ip_lookup_service' => 'maxmind_download',
'ip_lookup_auth' => null,
'ip_lookup_config' => array(

),
'update_stability' => 'stable',
'cookie_path' => '/',
'cookie_domain' => null,
'cookie_secure' => false,
'cookie_httponly' => false,
'do_not_track_ips' => array(

),
'do_not_track_internal_ips' => array(

),
'link_shortener_url' => null,
'cached_data_timeout' => '10',
'batch_sleep_time' => 1,
'batch_campaign_sleep_time' => false,
'cors_restrict_domains' => true,
'cors_valid_domains' => array(

),
'api_enabled' => true,
'api_oauth2_access_token_lifetime' => 60,
'api_oauth2_refresh_token_lifetime' => 14,
'upload_dir' => '/home/m2wire/public_html/matic/app/../media/files',
'max_size' => '6',
'allowed_extensions' => array(
	"0" => "csv", 
	"1" => "doc", 
	"2" => "docx", 
	"3" => "epub", 
	"4" => "gif", 
	"5" => "jpg", 
	"6" => "jpeg", 
	"7" => "mpg", 
	"8" => "mpeg", 
	"9" => "mp3", 
	"10" => "odt", 
	"11" => "odp", 
	"12" => "ods", 
	"13" => "pdf", 
	"14" => "png", 
	"15" => "ppt", 
	"16" => "pptx", 
	"17" => "tif", 
	"18" => "tiff", 
	"19" => "txt", 
	"20" => "xls", 
	"21" => "xlsx", 
	"22" => "wav"
),
'campaign_time_wait_on_event_false' => 'PT1H',
'mailer_return_path' => 'bounce@m2wire.com',
'mailer_append_tracking_pixel' => true,
'mailer_convert_embed_images' => false,
'mailer_amazon_region' => 'email-smtp.us-east-1.amazonaws.com',
'mailer_spool_msg_limit' => null,
'mailer_spool_time_limit' => null,
'mailer_spool_recover_timeout' => '900',
'mailer_spool_clear_timeout' => '1800',
'unsubscribe_text' => '<a href='|URL|'>Unsubscribe</a> to no longer receive emails from us.',
'webview_text' => '<a href='|URL|'>Having trouble reading this email? Click here.</a>',
'unsubscribe_message' => 'We are sorry to see you go! |EMAIL| will no longer receive emails from us. If this was by mistake, <a href='|URL|'>click here to re-subscribe</a>.',
'resubscribe_message' => '|EMAIL| has been re-subscribed. If this was by mistake, <a href='|URL|'>click here to unsubscribe</a>.',
'monitored_email' => array(
	"general" => array(
		"address" => "bounce@m2wire.com", 
		"host" => "m2wire.com", 
		"port" => "465", 
		"encryption" => "/ssl/novalidate-cert", 
		"user" => "bounce@m2wire.com", 
		"password" => "DELETED"
	), 
	"EmailBundle_bounces" => array(
		"address" => "", 
		"host" => "", 
		"port" => "993", 
		"encryption" => "/ssl", 
		"user" => "", 
		"password" => "", 
		"override_settings" => "", 
		"folder" => "", 
		"ssl" => "1"
	), 
	"EmailBundle_unsubscribes" => array(
		"address" => "", 
		"host" => "", 
		"port" => "993", 
		"encryption" => "/ssl", 
		"user" => "", 
		"password" => "", 
		"override_settings" => "", 
		"folder" => "", 
		"ssl" => "1"
	)
),
'mailer_is_owner' => false,
'default_signature_text' => 'Best regards, |FROM_NAME|',
'notification_enabled' => false,
'notification_app_id' => null,
'notification_rest_api_key' => null,
'notification_safari_web_id' => null,
'cat_in_page_url' => false,
'google_analytics' => null,
'redirect_list_types' => array(
	"301" => "mautic.page.form.redirecttype.permanent", 
	"302" => "mautic.page.form.redirecttype.temporary"
),
'sms_enabled' => false,
'sms_username' => null,
'sms_password' => null,
'sms_sending_phone_number' => null,
'webhook_start' => 0,
'webhook_limit' => 1000,
'webhook_log_max' => 10,
'queue_mode' => 'immediate_process',
'twitter_handle_field' => 'twitter',

);
[/code]

10

Back again for Round II! Thanks for all the suggestions! however…

none of that worked. I spoke with my host, (knownhost) and they said this is most likely the script. I do have another newsletter plugin running without issues with the same settings.