Mautic Community Forums

2.7.1 - cannot click on contacts

For no aparent reason mautic no longer shows us contacts. When we click on contacts nothing happens and the error log gets filled with the following below. We have tried to upgrade to 2.8.1 but also get another error. We need mautic to work with any version so hoping someone can help!



[2017-05-30 10:47:31] mautic.CRITICAL: Uncaught PHP Exception DoctrineDBALExceptionInvalidFieldNameException: “An exception occurred while executing ‘SELECT (CASE WHEN m0_.id = 1310 THEN 0 WHEN m0_.id = 3694 THEN 1 WHEN m0_.id = 378 THEN 2 WHEN m0_.id = 3638 THEN 3 WHEN m0_.id = 3564 THEN 4 WHEN m0_.id = 1300 THEN 5 WHEN m0_.id = 1213 THEN 6 WHEN m0_.id = 3484 THEN 7 WHEN m0_.id = 3383 THEN 8 WHEN m0_.id = 3443 THEN 9 WHEN m0_.id = 3431 THEN 10 WHEN m0_.id = 3368 THEN 11 WHEN m0_.id = 3356 THEN 12 WHEN m0_.id = 3350 THEN 13 WHEN m0_.id = 3340 THEN 14 WHEN m0_.id = 3319 THEN 15 WHEN m0_.id = 3315 THEN 16 WHEN m0_.id = 3240 THEN 17 WHEN m0_.id = 3157 THEN 18 WHEN m0_.id = 3132 THEN 19 WHEN m0_.id = 3076 THEN 20 WHEN m0_.id = 1271 THEN 21 WHEN m0_.id = 463 THEN 22 WHEN m0_.id = 558 THEN 23 WHEN m0_.id = 2873 THEN 24 WHEN m0_.id = 2866 THEN 25 WHEN m0_.id = 641 THEN 26 WHEN m0_.id = 2842 THEN 27 WHEN m0_.id = 422 THEN 28 WHEN m0_.id = 1446 THEN 29 ELSE 30 END) AS sclr_0, m0_.is_published AS is_published_1, m0_.date_added AS date_added_2, m0_.created_by AS created_by_3, m0_.created_by_user AS created_by_user_4, m0_.date_modified AS date_modified_5, m0_.modified_by AS modified_by_6, m0_.modified_by_user AS modified_by_user_7, m0_.checked_out AS checked_out_8, m0_.checked_out_by AS checked_out_by_9, m0_.checked_out_by_user AS checked_out_by_user_10, m0_.id AS id_11, m0_.points AS points_12, m0_.last_active AS last_active_13, m0_.internal AS internal_14, m0_.social_cache AS social_cache_15, m0_.date_identified AS date_identified_16, m0_.preferred_profile_image AS preferred_profile_image_17, m0_.title AS title_18, m0_.firstname AS firstname_19, m0_.lastname AS lastname_20, m0_.company AS company_21, m0_.position AS position_22, m0_.email AS email_23, m0_.phone AS phone_24, m0_.mobile AS mobile_25, m0_.address1 AS address1_26, m0_.address2 AS address2_27, m0_.city AS city_28, m0_.state AS state_29, m0_.zipcode AS zipcode_30, m0_.timezone AS timezone_31, m0_.country AS country_32, m1_.id AS id_33, m1_.ip_address AS ip_address_34, m1_.ip_details AS ip_details_35, m2_.is_published AS is_published_36, m2_.date_added AS date_added_37, m2_.created_by AS created_by_38, m2_.created_by_user AS created_by_user_39, m2_.date_modified AS date_modified_40, m2_.modified_by AS modified_by_41, m2_.modified_by_user AS modified_by_user_42, m2_.checked_out AS checked_out_43, m2_.checked_out_by AS checked_out_by_44, m2_.checked_out_by_user AS checked_out_by_user_45, m2_.id AS id_46, m2_.username AS username_47, m2_.password AS password_48, m2_.first_name AS first_name_49, m2_.last_name AS last_name_50, m2_.email AS email_51, m2_.position AS position_52, m2_.timezone AS timezone_53, m2_.locale AS locale_54, m2_.last_login AS last_login_55, m2_.last_active AS last_active_56, m2_.online_status AS online_status_57, m2_.preferences AS preferences_58, m2_.signature AS signature_59, m0_.owner_id AS owner_id_60, m0_.stage_id AS stage_id_61, m2_.role_id AS role_id_62 FROM mauf1_leads m0_ LEFT JOIN mauf1_lead_ips_xref m3_ ON m0_.id = m3_.lead_id LEFT JOIN mauf1_ip_addresses m1_ ON m1_.id = m3_.ip_id LEFT JOIN mauf1_users m2_ ON m0_.owner_id = m2_.id WHERE m0_.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) ORDER BY sclr_0 ASC’ with params [1310, 3694, 378, 3638, 3564, 1300, 1213, 3484, 3383, 3443, 3431, 3368, 3356, 3350, 3340, 3319, 3315, 3240, 3157, 3132, 3076, 1271, 463, 558, 2873, 2866, 641, 2842, 422, 1446]: Unknown column ‘m0_.timezone’ in ‘field list’” at /home/nbwindsm/public_html/ecomms/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 (CASE WHEN m0_.id = 1310 THEN 0 WHEN m0_.id = 3694 THEN 1 WHEN m0_.id = 378 THEN 2 WHEN m0_.id = 3638 THEN 3 WHEN m0_.id = 3564 THEN 4 WHEN m0_.id = 1300 THEN 5 WHEN m0_.id = 1213 THEN 6 WHEN m0_.id = 3484 THEN 7 WHEN m0_.id = 3383 THEN 8 WHEN m0_.id = 3443 THEN 9 WHEN m0_.id = 3431 THEN 10 WHEN m0_.id = 3368 THEN 11 WHEN m0_.id = 3356 THEN 12 WHEN m0_.id = 3350 THEN 13 WHEN m0_.id = 3340 THEN 14 WHEN m0_.id = 3319 THEN 15 WHEN m0_.id = 3315 THEN 16 WHEN m0_.id = 3240 THEN 17 WHEN m0_.id = 3157 THEN 18 WHEN m0_.id = 3132 THEN 19 WHEN m0_.id = 3076 THEN 20 WHEN m0_.id = 1271 THEN 21 WHEN m0_.id = 463 THEN 22 WHEN m0_.id = 558 THEN 23 WHEN m0_.id = 2873 THEN 24 WHEN m0_.id = 2866 THEN 25 WHEN m0_.id = 641 THEN 26 WHEN m0_.id = 2842 THEN 27 WHEN m0_.id = 422 THEN 28 WHEN m0_.id = 1446 THEN 29 ELSE 30 END) AS sclr_0, m0_.is_published AS is_published_1, m0_.date_added AS date_added_2, m0_.created_by AS created_by_3, m0_.created_by_user AS created_by_user_4, m0_.date_modified AS date_modified_5, m0_.modified_by AS modified_by_6, m0_.modified_by_user AS modified_by_user_7, m0_.checked_out AS checked_out_8, m0_.checked_out_by AS checked_out_by_9, m0_.checked_out_by_user AS checked_out_by_user_10, m0_.id AS id_11, m0_.points AS points_12, m0_.last_active AS last_active_13, m0_.internal AS internal_14, m0_.social_cache AS social_cache_15, m0_.date_identified AS date_identified_16, m0_.preferred_profile_image AS preferred_profile_image_17, m0_.title AS title_18, m0_.firstname AS firstname_19, m0_.lastname AS lastname_20, m0_.company AS company_21, m0_.position AS position_22, m0_.email AS email_23, m0_.phone AS phone_24, m0_.mobile AS mobile_25, m0_.address1 AS address1_26, m0_.address2 AS address2_27, m0_.city AS city_28, m0_.state AS state_29, m0_.zipcode AS zipcode_30, m0_.timezone AS timezone_31, m0_.country AS country_32, m1_.id AS id_33, m1_.ip_address AS ip_address_34, m1_.ip_details AS ip_details_35, m2_.is_published AS is_published_36, m2_.date_added AS date_added_37, m2_.created_by AS created_by_38, m2_.created_by_user AS created_by_user_39, m2_.date_modified AS date_modified_40, m2_.modified_by AS modified_by_41, m2_.modified_by_user AS modified_by_user_42, m2_.checked_out AS checked_out_43, m2_.checked_out_by AS checked_out_by_44, m2_.checked_out_by_user AS checked_out_by_user_45, m2_.id AS id_46, m2_.username AS username_47, m2_.password AS password_48, m2_.first_name AS first_name_49, m2_.last_name AS last_name_50, m2_.email AS email_51, m2_.position AS position_52, m2_.timezone AS timezone_53, m2_.locale AS locale_54, m2_.last_login AS last_login_55, m2_.last_active AS last_active_56, m2_.online_status AS online_status_57, m2_.preferences AS preferences_58, m2_.signature AS signature_59, m0_.owner_id AS owner_id_60, m0_.stage_id AS stage_id_61, m2_.role_id AS role_id_62 FROM mauf1_leads m0_ LEFT JOIN mauf1_lead_ips_xref m3_ ON m0_.id = m3_.lead_id LEFT JOIN mauf1_ip_addresses m1_ ON m1_.id = m3_.ip_id LEFT JOIN mauf1_users m2_ ON m0_.owner_id = m2_.id WHERE m0_.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) ORDER BY sclr_0 ASC’ with params [1310, 3694, 378, 3638, 3564, 1300, 1213, 3484, 3383, 3443, 3431, 3368, 3356, 3350, 3340, 3319, 3315, 3240, 3157, 3132, 3076, 1271, 463, 558, 2873, 2866, 641, 2842, 422, 1446]:nnUnknown column ‘m0_.timezone’ in ‘field list’ at /home/ecomms/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/AbstractMySQLDriver.php:71, Doctrine\DBAL\Driver\Mysqli\MysqliException(code: 0): Unknown column ‘m0_.timezone’ in ‘field list’ at /home/ecomms/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/Mysqli/MysqliStatement.php:94)"} []

For no aparent reason mautic no longer shows us contacts. When we click on contacts nothing happens and the error log gets filled with the following below. We have tried to upgrade to 2.8.1 but also get another error. We need mautic to work with any version so hoping someone can help!

[2017-05-30 10:47:31] mautic.CRITICAL: Uncaught PHP Exception DoctrineDBALExceptionInvalidFieldNameException: “An exception occurred while executing ‘SELECT (CASE WHEN m0_.id = 1310 THEN 0 WHEN m0_.id = 3694 THEN 1 WHEN m0_.id = 378 THEN 2 WHEN m0_.id = 3638 THEN 3 WHEN m0_.id = 3564 THEN 4 WHEN m0_.id = 1300 THEN 5 WHEN m0_.id = 1213 THEN 6 WHEN m0_.id = 3484 THEN 7 WHEN m0_.id = 3383 THEN 8 WHEN m0_.id = 3443 THEN 9 WHEN m0_.id = 3431 THEN 10 WHEN m0_.id = 3368 THEN 11 WHEN m0_.id = 3356 THEN 12 WHEN m0_.id = 3350 THEN 13 WHEN m0_.id = 3340 THEN 14 WHEN m0_.id = 3319 THEN 15 WHEN m0_.id = 3315 THEN 16 WHEN m0_.id = 3240 THEN 17 WHEN m0_.id = 3157 THEN 18 WHEN m0_.id = 3132 THEN 19 WHEN m0_.id = 3076 THEN 20 WHEN m0_.id = 1271 THEN 21 WHEN m0_.id = 463 THEN 22 WHEN m0_.id = 558 THEN 23 WHEN m0_.id = 2873 THEN 24 WHEN m0_.id = 2866 THEN 25 WHEN m0_.id = 641 THEN 26 WHEN m0_.id = 2842 THEN 27 WHEN m0_.id = 422 THEN 28 WHEN m0_.id = 1446 THEN 29 ELSE 30 END) AS sclr_0, m0_.is_published AS is_published_1, m0_.date_added AS date_added_2, m0_.created_by AS created_by_3, m0_.created_by_user AS created_by_user_4, m0_.date_modified AS date_modified_5, m0_.modified_by AS modified_by_6, m0_.modified_by_user AS modified_by_user_7, m0_.checked_out AS checked_out_8, m0_.checked_out_by AS checked_out_by_9, m0_.checked_out_by_user AS checked_out_by_user_10, m0_.id AS id_11, m0_.points AS points_12, m0_.last_active AS last_active_13, m0_.internal AS internal_14, m0_.social_cache AS social_cache_15, m0_.date_identified AS date_identified_16, m0_.preferred_profile_image AS preferred_profile_image_17, m0_.title AS title_18, m0_.firstname AS firstname_19, m0_.lastname AS lastname_20, m0_.company AS company_21, m0_.position AS position_22, m0_.email AS email_23, m0_.phone AS phone_24, m0_.mobile AS mobile_25, m0_.address1 AS address1_26, m0_.address2 AS address2_27, m0_.city AS city_28, m0_.state AS state_29, m0_.zipcode AS zipcode_30, m0_.timezone AS timezone_31, m0_.country AS country_32, m1_.id AS id_33, m1_.ip_address AS ip_address_34, m1_.ip_details AS ip_details_35, m2_.is_published AS is_published_36, m2_.date_added AS date_added_37, m2_.created_by AS created_by_38, m2_.created_by_user AS created_by_user_39, m2_.date_modified AS date_modified_40, m2_.modified_by AS modified_by_41, m2_.modified_by_user AS modified_by_user_42, m2_.checked_out AS checked_out_43, m2_.checked_out_by AS checked_out_by_44, m2_.checked_out_by_user AS checked_out_by_user_45, m2_.id AS id_46, m2_.username AS username_47, m2_.password AS password_48, m2_.first_name AS first_name_49, m2_.last_name AS last_name_50, m2_.email AS email_51, m2_.position AS position_52, m2_.timezone AS timezone_53, m2_.locale AS locale_54, m2_.last_login AS last_login_55, m2_.last_active AS last_active_56, m2_.online_status AS online_status_57, m2_.preferences AS preferences_58, m2_.signature AS signature_59, m0_.owner_id AS owner_id_60, m0_.stage_id AS stage_id_61, m2_.role_id AS role_id_62 FROM mauf1_leads m0_ LEFT JOIN mauf1_lead_ips_xref m3_ ON m0_.id = m3_.lead_id LEFT JOIN mauf1_ip_addresses m1_ ON m1_.id = m3_.ip_id LEFT JOIN mauf1_users m2_ ON m0_.owner_id = m2_.id WHERE m0_.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) ORDER BY sclr_0 ASC’ with params [1310, 3694, 378, 3638, 3564, 1300, 1213, 3484, 3383, 3443, 3431, 3368, 3356, 3350, 3340, 3319, 3315, 3240, 3157, 3132, 3076, 1271, 463, 558, 2873, 2866, 641, 2842, 422, 1446]: Unknown column ‘m0_.timezone’ in ‘field list’” at /home/nbwindsm/public_html/ecomms/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 (CASE WHEN m0_.id = 1310 THEN 0 WHEN m0_.id = 3694 THEN 1 WHEN m0_.id = 378 THEN 2 WHEN m0_.id = 3638 THEN 3 WHEN m0_.id = 3564 THEN 4 WHEN m0_.id = 1300 THEN 5 WHEN m0_.id = 1213 THEN 6 WHEN m0_.id = 3484 THEN 7 WHEN m0_.id = 3383 THEN 8 WHEN m0_.id = 3443 THEN 9 WHEN m0_.id = 3431 THEN 10 WHEN m0_.id = 3368 THEN 11 WHEN m0_.id = 3356 THEN 12 WHEN m0_.id = 3350 THEN 13 WHEN m0_.id = 3340 THEN 14 WHEN m0_.id = 3319 THEN 15 WHEN m0_.id = 3315 THEN 16 WHEN m0_.id = 3240 THEN 17 WHEN m0_.id = 3157 THEN 18 WHEN m0_.id = 3132 THEN 19 WHEN m0_.id = 3076 THEN 20 WHEN m0_.id = 1271 THEN 21 WHEN m0_.id = 463 THEN 22 WHEN m0_.id = 558 THEN 23 WHEN m0_.id = 2873 THEN 24 WHEN m0_.id = 2866 THEN 25 WHEN m0_.id = 641 THEN 26 WHEN m0_.id = 2842 THEN 27 WHEN m0_.id = 422 THEN 28 WHEN m0_.id = 1446 THEN 29 ELSE 30 END) AS sclr_0, m0_.is_published AS is_published_1, m0_.date_added AS date_added_2, m0_.created_by AS created_by_3, m0_.created_by_user AS created_by_user_4, m0_.date_modified AS date_modified_5, m0_.modified_by AS modified_by_6, m0_.modified_by_user AS modified_by_user_7, m0_.checked_out AS checked_out_8, m0_.checked_out_by AS checked_out_by_9, m0_.checked_out_by_user AS checked_out_by_user_10, m0_.id AS id_11, m0_.points AS points_12, m0_.last_active AS last_active_13, m0_.internal AS internal_14, m0_.social_cache AS social_cache_15, m0_.date_identified AS date_identified_16, m0_.preferred_profile_image AS preferred_profile_image_17, m0_.title AS title_18, m0_.firstname AS firstname_19, m0_.lastname AS lastname_20, m0_.company AS company_21, m0_.position AS position_22, m0_.email AS email_23, m0_.phone AS phone_24, m0_.mobile AS mobile_25, m0_.address1 AS address1_26, m0_.address2 AS address2_27, m0_.city AS city_28, m0_.state AS state_29, m0_.zipcode AS zipcode_30, m0_.timezone AS timezone_31, m0_.country AS country_32, m1_.id AS id_33, m1_.ip_address AS ip_address_34, m1_.ip_details AS ip_details_35, m2_.is_published AS is_published_36, m2_.date_added AS date_added_37, m2_.created_by AS created_by_38, m2_.created_by_user AS created_by_user_39, m2_.date_modified AS date_modified_40, m2_.modified_by AS modified_by_41, m2_.modified_by_user AS modified_by_user_42, m2_.checked_out AS checked_out_43, m2_.checked_out_by AS checked_out_by_44, m2_.checked_out_by_user AS checked_out_by_user_45, m2_.id AS id_46, m2_.username AS username_47, m2_.password AS password_48, m2_.first_name AS first_name_49, m2_.last_name AS last_name_50, m2_.email AS email_51, m2_.position AS position_52, m2_.timezone AS timezone_53, m2_.locale AS locale_54, m2_.last_login AS last_login_55, m2_.last_active AS last_active_56, m2_.online_status AS online_status_57, m2_.preferences AS preferences_58, m2_.signature AS signature_59, m0_.owner_id AS owner_id_60, m0_.stage_id AS stage_id_61, m2_.role_id AS role_id_62 FROM mauf1_leads m0_ LEFT JOIN mauf1_lead_ips_xref m3_ ON m0_.id = m3_.lead_id LEFT JOIN mauf1_ip_addresses m1_ ON m1_.id = m3_.ip_id LEFT JOIN mauf1_users m2_ ON m0_.owner_id = m2_.id WHERE m0_.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) ORDER BY sclr_0 ASC’ with params [1310, 3694, 378, 3638, 3564, 1300, 1213, 3484, 3383, 3443, 3431, 3368, 3356, 3350, 3340, 3319, 3315, 3240, 3157, 3132, 3076, 1271, 463, 558, 2873, 2866, 641, 2842, 422, 1446]:nnUnknown column ‘m0_.timezone’ in ‘field list’ at /home/ecomms/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/AbstractMySQLDriver.php:71, Doctrine\DBAL\Driver\Mysqli\MysqliException(code: 0): Unknown column ‘m0_.timezone’ in ‘field list’ at /home/ecomms/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/Mysqli/MysqliStatement.php:94)"} []

Thank you, how would I go about completing the outstanding migrations?