2.6.1 Update - Contacts broken - 500 error

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

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

Tried. Says its up to date

Still no contacts. Blue bar moves then stopes wuth nothing.
Right click contacts > Opened in new window > 500 server error still

2.6.0

[quote=20228:@MxyzptlkFishStix]Edit /app/version.txt and change it to 2.5.1.
Download this file and upload to the root of the Mautic directory.
If you have shell access, change directory to where Mautic is on your server and run the following command as the web server user:

sudo -u "web server user" php update.php

If you don’t have shell access, open it in your browser at mautic-domain.ext/update.php.[/quote]
Ok let me turn my pc on asap… happy that you are at it. I should be vigilant too.

@MxyzptlkFishStix
Ok uploaded the file and ran it via URL with domain/upgrade.php

It asked for click here to update clicked. Updated message received.

Clicked contacts still nothing

oh missed one thing. you asked to change file to 2.5.1

let me do that and rerun it

OK changed the version.txt

Reran the file via url and got the message SUCCESS - Remove this script!

Checked contacts again. Nothing happened. Still 500 error

Just went to log folder and found a new file with name prod -date.php may be its a result of script that ran…

Following is written in it if its of any help:

[2017-02-17 00:21:53] event.DEBUG: Notified event “console.command” to listener “SymfonyComponentHttpKernelEventListenerDebugHandlersListener::configure”. [] []
[2017-02-17 00:21:53] event.DEBUG: Notified event “console.terminate” to listener “MauticCoreBundleEventListenerConsoleTerminateListener::onConsoleTerminate”. [] []
[2017-02-17 00:21:53] event.DEBUG: Notified event “console.terminate” to listener “SymfonyBundleSwiftmailerBundleEventListenerEmailSenderListener::onTerminate”. [] []
[2017-02-17 00:21:56] event.DEBUG: Notified event “console.command” to listener “SymfonyComponentHttpKernelEventListenerDebugHandlersListener::configure”. [] []
[2017-02-17 00:21:56] doctrine.DEBUG: SHOW FULL TABLES WHERE Table_type = ‘BASE TABLE’ [] []
[2017-02-17 00:21:56] doctrine.DEBUG: SELECT version FROM mau02_migrations [] []
[2017-02-17 00:21:56] doctrine.DEBUG: SELECT version FROM mau02_migrations WHERE version IN (‘20150402000000’, ‘20150504000000’, ‘20150521000000’, ‘20150718000000’, ‘20150724000000’, ‘20150801000000’, ‘20150829000000’, ‘20150901000000’, ‘20151022000000’, ‘20151120000000’, ‘20151207000000’, ‘20160114000000’, ‘20160225000000’, ‘20160405000000’, ‘20160414000000’, ‘20160420000000’, ‘20160426000000’, ‘20160429000000’, ‘20160504000000’, ‘20160506000000’, ‘20160520000000’, ‘20160523000000’, ‘20160606000000’, ‘20160615000000’, ‘20160617000318’, ‘20160624032452’, ‘20160630000000’, ‘20160630000001’, ‘20160630000002’, ‘20160712000000’, ‘20160712000001’, ‘20160719000000’, ‘20160720000000’, ‘20160722000000’, ‘20160725161822’, ‘20160726000000’, ‘20160726000001’, ‘20160728000000’, ‘20160731000000’, ‘20160805000123’, ‘20160808000000’, ‘20160916000000’, ‘20160919204648’, ‘20160920195943’, ‘20160926000000’, ‘20160926000001’, ‘20160926182807’, ‘20161004080958’, ‘20161004090629’, ‘20161004123446’, ‘20161024162029’, ‘20161026110456’, ‘20161026202839’, ‘20161031134707’, ‘20161116195435’, ‘20161122172519’, ‘20161122215214’, ‘20161123225456’, ‘20161124145649’, ‘20161125002837’, ‘20161222183556’, ‘20170106102310’, ‘20170108012944’, ‘20170109025947’, ‘20170113015255’, ‘20170113143922’, ‘20170127205928’) ORDER BY version DESC LIMIT 1 [] []
[2017-02-17 00:21:56] doctrine.DEBUG: SELECT version FROM mau02_migrations [] []
[2017-02-17 00:21:56] event.DEBUG: Notified event “console.terminate” to listener “MauticCoreBundleEventListenerConsoleTerminateListener::onConsoleTerminate”. [] []
[2017-02-17 00:21:56] event.DEBUG: Notified event “console.terminate” to listener “SymfonyBundleSwiftmailerBundleEventListenerEmailSenderListener::onTerminate”. [] []

Anybody any idea what to do? Still waiting… withiut working system

@MxyzptlkFishStix sorry for tagging you again… just wanted to ask if you have something for me yet… will be waiting for your response if i should wait… thanks

Same exact scenario over here …

By clicking on ‘Contacts’ the query comes with an error (checked with Webdeveloper console ):
Column not found: 1054 Unknown column u0027l0_.timezone

I found a workaround.

  • Added a column ‘timezone’ to table leads’

For me, everything seems to be working fine now

i have same type of errors dealing with that Doctrine

I have mautic on 3 sites, only 1 had no errors with update in log, the other 2 1 had a bunch of stuff dealing with Doctrine and the other was very small on something else. I posted the article here i didn’t see this posting or i would have just said i have same problems. i updated from 2.6 because that was a complete mess of an update.

https://www.mautic.org/community/index.php/6960-2-6-1-update-errors-part-1-and-2

@maxjo I have the same exact issue!! Been breaking my head for the past 2 weeks!!
would love some help, please tell me how you Added a column ‘timezone’ to table leads’

update database schema.

@rogan
ALTER TABLE leads ADD COLUMN timezone VARCHAR(255) DEFAULT NULL
make backup first!