# Update - can't view contacts now

**URL:** <https://forum.mautic.org/t/update-cant-view-contacts-now/8402>\
**Category:** Product Support\
**Created:** [May 3, 2017, 1:26am UTC](https://forum.mautic.org/t/update-cant-view-contacts-now/8402 "2017-05-03T01:26:49Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![cdelger](https://avatars.discourse-cdn.com/v4/letter/c/f04885/32.png) [@cdelger](https://forum.mautic.org/u/cdelger)\
**Post date:** [May 3, 2017, 1:26am UTC](https://forum.mautic.org/t/update-cant-view-contacts-now/8402/1 "2017-05-03T01:26:49Z")

</div>

hello,  
  
  
  
I applied the latest update using the upgrade script, and everything seems to be working except I am not able to view Contacts.  
  
  
  
I enabled debugging, and the following error is being generated when I click on the Contacts menu.  
  
  
  
mautic.CRITICAL: Uncaught PHP Exception DoctrineDBALExceptionInvalidFieldNameException: "An exception occurred while executing 'INSERT INTO leads  
  
  
  
I have custom fields and suspect that may be the cause of the problem.  
  
  
  
I made a backup of the mautic directory prior to updating, and have tried copying those files back over, but the problem still occurs.  
  
  
  
Could someone provide some guidance as to what steps I can take to get this working again?  
  
  
  
Thank you

---

<div class="post-metadata">

**Author:** ![cdelger](https://avatars.discourse-cdn.com/v4/letter/c/f04885/32.png) [@cdelger](https://forum.mautic.org/u/cdelger)\
**Post date:** [May 3, 2017, 1:26am UTC](https://forum.mautic.org/t/update-cant-view-contacts-now/8402/2 "2017-05-03T01:26:49Z")

</div>

hello,

I applied the latest update using the upgrade script, and everything seems to be working except I am not able to view Contacts.

I enabled debugging, and the following error is being generated when I click on the Contacts menu.

mautic.CRITICAL: Uncaught PHP Exception DoctrineDBALExceptionInvalidFieldNameException: "An exception occurred while executing 'INSERT INTO leads

I have custom fields and suspect that may be the cause of the problem.

I made a backup of the mautic directory prior to updating, and have tried copying those files back over, but the problem still occurs.

Could someone provide some guidance as to what steps I can take to get this working again?

Thank you

---

<div class="post-metadata">

**Author:** ![cdelger](https://avatars.discourse-cdn.com/v4/letter/c/f04885/32.png) [@cdelger](https://forum.mautic.org/u/cdelger)\
**Post date:** [May 3, 2017, 2:01am UTC](https://forum.mautic.org/t/update-cant-view-contacts-now/8402/3 "2017-05-03T02:01:09Z")

</div>

Some additional information, looking at the SQL here is the problem: SQLSTATE[42S22]: Column not found: 1054 Unknown column ‘l0\_.timezone’ in ‘field list’ (uncaught exception)

Any ideas how to resolve that?

---

<div class="post-metadata">

**Author:** ![cdelger](https://avatars.discourse-cdn.com/v4/letter/c/f04885/32.png) [@cdelger](https://forum.mautic.org/u/cdelger)\
**Post date:** [May 3, 2017, 3:40pm UTC](https://forum.mautic.org/t/update-cant-view-contacts-now/8402/4 "2017-05-03T15:40:26Z")

</div>

Posting the resolution just in case it helps someone else.

Using SQL command I added the column “timezone” to the leads table. I am now able to view Contacts again.

---

<div class="post-metadata">

**Author:** ![petertl](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.mautic.org/petertl/32/511_2.png) [@petertl](https://forum.mautic.org/u/petertl)\
**Post date:** [May 4, 2017, 6:04am UTC](https://forum.mautic.org/t/update-cant-view-contacts-now/8402/5 "2017-05-04T06:04:17Z")

</div>

This may work as workaround, but should not be the solution. Which data type did you use? Any constraints?

I hat this error, too, and the following blog post helped me: [https://johnlinhart.com/blog/uh-oh-mautic-upgrade-was-not-successful](https://johnlinhart.com/blog/uh-oh-mautic-upgrade-was-not-successful)

I did steps 1 to 4 and my system was up and running again.