I know one must not be jumping too quick but my system is not populated yet and still testing. So went ahead and updated it as it is a bug fix update.
During update the process was stalled at clearing cache. I waited for 15 minutes or so and later opened the dashboard in another window. All updated 2.6.1 showing at the bottom. Checked updates page with URL and it says I’m running current version.
Now if I click contacts it throws 500 error.
Went to log and found these errors:
[2017-02-17 03:12:57] mautic.CRITICAL: Uncaught PHP Exception DoctrineDBALExceptionInvalidFieldNameException: “An exception occurred while executing ‘INSERT INTO mau02_leads (is_published, date_added, created_by, created_by_user, date_modified, modified_by, modified_by_user, checked_out, checked_out_by, checked_out_by_user, points, last_active, internal, social_cache, date_identified, preferred_profile_image, title, firstname, lastname, company, position, email, phone, mobile, address1, address2, city, state, zipcode, timezone, country, owner_id, stage_id) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)’: Unknown column ‘timezone’ in ‘field list’” at /[root address]/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/AbstractMySQLDriver.php line 71 {“exception”:"[object] (Doctrine\DBAL\Exception\InvalidFieldNameException(code: 0): An exception occurred while executing ‘INSERT INTO mau02_leads (is_published, date_added, created_by, created_by_user, date_modified, modified_by, modified_by_user, checked_out, checked_out_by, checked_out_by_user, points, last_active, internal, social_cache, date_identified, preferred_profile_image, title, firstname, lastname, company, position, email, phone, mobile, address1, address2, city, state, zipcode, timezone, country, owner_id, stage_id) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)’:nnUnknown column ‘timezone’ in ‘field list’ at /[root address]/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/AbstractMySQLDriver.php:71, Doctrine\DBAL\Driver\Mysqli\MysqliException(code: 0): Unknown column ‘timezone’ in ‘field list’ at /[root address]/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/Mysqli/MysqliStatement.php:94)"} []
[2017-02-17 03:10:48] mautic.CRITICAL: Uncaught PHP Exception DoctrineDBALExceptionInvalidFieldNameException: “An exception occurred while executing ‘SELECT (CASE WHEN m0_.id = 4398 THEN 0 WHEN m0_.id = 1776 THEN 1 ELSE 2 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 mau02_leads m0_ LEFT JOIN mau02_lead_ips_xref m3_ ON m0_.id = m3_.lead_id LEFT JOIN mau02_ip_addresses m1_ ON m1_.id = m3_.ip_id LEFT JOIN mau02_users m2_ ON m0_.owner_id = m2_.id WHERE m0_.id IN (?, ?) ORDER BY sclr_0 ASC’ with params [4398, 1776]: Unknown column ‘m0_.timezone’ in ‘field list’” at [root address]/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 = 4398 THEN 0 WHEN m0_.id = 1776 THEN 1 ELSE 2 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 mau02_leads m0_ LEFT JOIN mau02_lead_ips_xref m3_ ON m0_.id = m3_.lead_id LEFT JOIN mau02_ip_addresses m1_ ON m1_.id = m3_.ip_id LEFT JOIN mau02_users m2_ ON m0_.owner_id = m2_.id WHERE m0_.id IN (?, ?) ORDER BY sclr_0 ASC’ with params [4398, 1776]:nnUnknown column ‘m0_.timezone’ in ‘field list’ at [root address]/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 [root address]/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/Mysqli/MysqliStatement.php:94)"} []
- Hasaan