# 2.6.1 Update - Contacts broken - 500 error

**URL:** <https://forum.mautic.org/t/2-6-1-update-contacts-broken-500-error/7576>\
**Category:** Product Support\
**Created:** [February 16, 2017, 10:32pm UTC](https://forum.mautic.org/t/2-6-1-update-contacts-broken-500-error/7576 "2017-02-16T22:32:40Z")\
**Posts on this page:** 18\
**Page:** 1

<div class="post-metadata">

**Author:** ![Hasaan](https://avatars.discourse-cdn.com/v4/letter/h/a9a28c/32.png) [@Hasaan](https://forum.mautic.org/u/Hasaan)\
**Post date:** [February 16, 2017, 10:32pm UTC](https://forum.mautic.org/t/2-6-1-update-contacts-broken-500-error/7576/1 "2017-02-16T22:32:40Z")

</div>

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

---

<div class="post-metadata">

**Author:** ![Hasaan](https://avatars.discourse-cdn.com/v4/letter/h/a9a28c/32.png) [@Hasaan](https://forum.mautic.org/u/Hasaan)\
**Post date:** [February 16, 2017, 10:32pm UTC](https://forum.mautic.org/t/2-6-1-update-contacts-broken-500-error/7576/2 "2017-02-16T22:32:40Z")

</div>

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

---

<div class="post-metadata">

**Author:** ![Hasaan](https://avatars.discourse-cdn.com/v4/letter/h/a9a28c/32.png) [@Hasaan](https://forum.mautic.org/u/Hasaan)\
**Post date:** [February 16, 2017, 11:37pm UTC](https://forum.mautic.org/t/2-6-1-update-contacts-broken-500-error/7576/3 "2017-02-16T23:37:12Z")

</div>

> [@20215:@MxyzptlkFishStix](#):
>
> /update/schema

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

---

<div class="post-metadata">

**Author:** ![Hasaan](https://avatars.discourse-cdn.com/v4/letter/h/a9a28c/32.png) [@Hasaan](https://forum.mautic.org/u/Hasaan)\
**Post date:** [February 16, 2017, 11:42pm UTC](https://forum.mautic.org/t/2-6-1-update-contacts-broken-500-error/7576/4 "2017-02-16T23:42:09Z")

</div>

> [@20224:@MxyzptlkFishStix](#):
>
> What did you update from?

2.6.0

---

<div class="post-metadata">

**Author:** ![Hasaan](https://avatars.discourse-cdn.com/v4/letter/h/a9a28c/32.png) [@Hasaan](https://forum.mautic.org/u/Hasaan)\
**Post date:** [February 17, 2017, 12:07am UTC](https://forum.mautic.org/t/2-6-1-update-contacts-broken-500-error/7576/5 "2017-02-17T00:07:16Z")

</div>

[quote=20228:@MxyzptlkFishStix]Edit /app/version.txt and change it to 2.5.1.  
Download this [file](https://raw.githubusercontent.com/mautic/mautic/master/upgrade.php) 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:

```auto
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.

---

<div class="post-metadata">

**Author:** ![Hasaan](https://avatars.discourse-cdn.com/v4/letter/h/a9a28c/32.png) [@Hasaan](https://forum.mautic.org/u/Hasaan)\
**Post date:** [February 17, 2017, 12:17am UTC](https://forum.mautic.org/t/2-6-1-update-contacts-broken-500-error/7576/6 "2017-02-17T00:17:35Z")

</div>

@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

---

<div class="post-metadata">

**Author:** ![Hasaan](https://avatars.discourse-cdn.com/v4/letter/h/a9a28c/32.png) [@Hasaan](https://forum.mautic.org/u/Hasaan)\
**Post date:** [February 17, 2017, 12:20am UTC](https://forum.mautic.org/t/2-6-1-update-contacts-broken-500-error/7576/7 "2017-02-17T00:20:33Z")

</div>

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

let me do that and rerun it

---

<div class="post-metadata">

**Author:** ![Hasaan](https://avatars.discourse-cdn.com/v4/letter/h/a9a28c/32.png) [@Hasaan](https://forum.mautic.org/u/Hasaan)\
**Post date:** [February 17, 2017, 12:23am UTC](https://forum.mautic.org/t/2-6-1-update-contacts-broken-500-error/7576/8 "2017-02-17T00:23:11Z")

</div>

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

---

<div class="post-metadata">

**Author:** ![Hasaan](https://avatars.discourse-cdn.com/v4/letter/h/a9a28c/32.png) [@Hasaan](https://forum.mautic.org/u/Hasaan)\
**Post date:** [February 17, 2017, 1:03am UTC](https://forum.mautic.org/t/2-6-1-update-contacts-broken-500-error/7576/9 "2017-02-17T01:03:35Z")

</div>

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”. [] []

---

<div class="post-metadata">

**Author:** ![Hasaan](https://avatars.discourse-cdn.com/v4/letter/h/a9a28c/32.png) [@Hasaan](https://forum.mautic.org/u/Hasaan)\
**Post date:** [February 17, 2017, 8:01am UTC](https://forum.mautic.org/t/2-6-1-update-contacts-broken-500-error/7576/10 "2017-02-17T08:01:11Z")

</div>

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

---

<div class="post-metadata">

**Author:** ![Hasaan](https://avatars.discourse-cdn.com/v4/letter/h/a9a28c/32.png) [@Hasaan](https://forum.mautic.org/u/Hasaan)\
**Post date:** [February 17, 2017, 8:42am UTC](https://forum.mautic.org/t/2-6-1-update-contacts-broken-500-error/7576/11 "2017-02-17T08:42:27Z")

</div>

@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

---

<div class="post-metadata">

**Author:** ![maxjo](https://avatars.discourse-cdn.com/v4/letter/m/c37758/32.png) [@maxjo](https://forum.mautic.org/u/maxjo)\
**Post date:** [February 17, 2017, 2:04pm UTC](https://forum.mautic.org/t/2-6-1-update-contacts-broken-500-error/7576/12 "2017-02-17T14:04:24Z")

</div>

Same exact scenario over here …

---

<div class="post-metadata">

**Author:** ![maxjo](https://avatars.discourse-cdn.com/v4/letter/m/c37758/32.png) [@maxjo](https://forum.mautic.org/u/maxjo)\
**Post date:** [February 17, 2017, 2:49pm UTC](https://forum.mautic.org/t/2-6-1-update-contacts-broken-500-error/7576/13 "2017-02-17T14:49:50Z")

</div>

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

---

<div class="post-metadata">

**Author:** ![maxjo](https://avatars.discourse-cdn.com/v4/letter/m/c37758/32.png) [@maxjo](https://forum.mautic.org/u/maxjo)\
**Post date:** [February 17, 2017, 5:59pm UTC](https://forum.mautic.org/t/2-6-1-update-contacts-broken-500-error/7576/14 "2017-02-17T17:59:32Z")

</div>

I found a workaround.

- Added a column ‘timezone’ to table leads’

For me, everything seems to be working fine now

---

<div class="post-metadata">

**Author:** ![ayayron](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.mautic.org/ayayron/32/10341_2.png) [@ayayron](https://forum.mautic.org/u/ayayron)\
**Post date:** [February 18, 2017, 12:48am UTC](https://forum.mautic.org/t/2-6-1-update-contacts-broken-500-error/7576/15 "2017-02-18T00:48:35Z")

</div>

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](https://www.mautic.org/community/index.php/6960-2-6-1-update-errors-part-1-and-2)

---

<div class="post-metadata">

**Author:** ![rogan](https://avatars.discourse-cdn.com/v4/letter/r/82dd89/32.png) [@rogan](https://forum.mautic.org/u/rogan)\
**Post date:** [March 1, 2017, 3:58am UTC](https://forum.mautic.org/t/2-6-1-update-contacts-broken-500-error/7576/16 "2017-03-01T03:58:46Z")

</div>

@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’

---

<div class="post-metadata">

**Author:** ![ninjoan](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.mautic.org/ninjoan/32/1005_2.png) [@ninjoan](https://forum.mautic.org/u/ninjoan)\
**Post date:** [March 1, 2017, 1:30pm UTC](https://forum.mautic.org/t/2-6-1-update-contacts-broken-500-error/7576/17 "2017-03-01T13:30:23Z")

</div>

update database schema.

---

<div class="post-metadata">

**Author:** ![maxjo](https://avatars.discourse-cdn.com/v4/letter/m/c37758/32.png) [@maxjo](https://forum.mautic.org/u/maxjo)\
**Post date:** [March 4, 2017, 10:00am UTC](https://forum.mautic.org/t/2-6-1-update-contacts-broken-500-error/7576/18 "2017-03-04T10:00:18Z")

</div>

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