# Upgrade to 2.11.0 Email Error

**URL:** <https://forum.mautic.org/t/upgrade-to-2-11-0-email-error/10024>\
**Category:** Product Support\
**Created:** [December 1, 2017, 12:21am UTC](https://forum.mautic.org/t/upgrade-to-2-11-0-email-error/10024 "2017-12-01T00:21:33Z")\
**Posts on this page:** 8\
**Page:** 1

<div class="post-metadata">

**Author:** ![raymondkent](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.mautic.org/raymondkent/32/412_2.png) [@raymondkent](https://forum.mautic.org/u/raymondkent)\
**Post date:** [December 1, 2017, 12:21am UTC](https://forum.mautic.org/t/upgrade-to-2-11-0-email-error/10024/1 "2017-12-01T00:21:33Z")

</div>

Hi there,  
  
  
  
I just upgraded to new version v2.11.0 and now I get this error when trying to select email channel and I cant create or go any further with emails.  
  
  
  
Error message is “The site is currently offline due to encountering an error. If the problem persists, please contact the system administrator.  
  
System administrators, check server logs for errors.”  
  
  
  
Here’s a copy of the log error that I think relates.  
  
  
  
[2017-12-01 11:16:01] mautic.ERROR: DoctrineDBALExceptionInvalidFieldNameException: An exception occurred while executing ‘SELECT e0\_.is\_published AS is\_published\_0, e0\_.date\_added AS date\_added\_1, e0\_.created\_by AS created\_by\_2, e0\_.created\_by\_user AS created\_by\_user\_3, e0\_.date\_modified AS date\_modified\_4, e0\_.modified\_by AS modified\_by\_5, e0\_.modified\_by\_user AS modified\_by\_user\_6, e0\_.checked\_out AS checked\_out\_7, e0\_.checked\_out\_by AS checked\_out\_by\_8, e0\_.checked\_out\_by\_user AS checked\_out\_by\_user\_9, e0\_.id AS id\_10, e0\_.name AS name\_11, e0\_.description AS description\_12, e0\_.subject AS subject\_13, e0\_.from\_address AS from\_address\_14, e0\_.from\_name AS from\_name\_15, e0\_.reply\_to\_address AS reply\_to\_address\_16, e0\_.bcc\_address AS bcc\_address\_17, e0\_.template AS template\_18, e0\_.content AS content\_19, e0\_.utm\_tags AS utm\_tags\_20, e0\_.plain\_text AS plain\_text\_21, e0\_.custom\_html AS custom\_html\_22, e0\_.email\_type AS email\_type\_23, e0\_.publish\_up AS publish\_up\_24, e0\_.publish\_down AS publish\_down\_25, e0\_.read\_count AS read\_count\_26, e0\_.sent\_count AS sent\_count\_27, e0\_.revision AS revision\_28, e0\_.lang AS lang\_29, e0\_.variant\_settings AS variant\_settings\_30, e0\_.variant\_start\_date AS variant\_start\_date\_31, e0\_.dynamic\_content AS dynamic\_content\_32, e0\_.variant\_sent\_count AS variant\_sent\_count\_33, e0\_.variant\_read\_count AS variant\_read\_count\_34, e0\_.category\_id AS category\_id\_35, e0\_.translation\_parent\_id AS translation\_parent\_id\_36, e0\_.variant\_parent\_id AS variant\_parent\_id\_37, e0\_.unsubscribeform\_id AS unsubscribeform\_id\_38, e0\_.preference\_center\_id AS preference\_center\_id\_39 FROM emails e0\_ LEFT JOIN categories c1\_ ON e0\_.category\_id = c1\_.id WHERE e0\_.variant\_parent\_id IS NULL AND e0\_.translation\_parent\_id IS NULL ORDER BY e0\_.subject DESC LIMIT 50 OFFSET 0’: SQLSTATE[42S22]: Column not found: 1054 Unknown column ‘e0\_.preference\_center\_id’ in ‘field list’ - in file /xxxxxxxx/xxxxxxxxx/xxxxxxxxx/dmpages.com/m/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/AbstractMySQLDriver.php - at line 71 [] []  
  
  
  
I have made a copy of my previous mautic install directory  
  
I then did a fresh mautic 2.11.0 install into original directory  
  
I copied the config from old to new and still have this issue.  
  
  
  
From my little understanding it looks more like a database select query/issue that’s not working.  
  
  
  
any suggestions on how to fix?  
  
  
  
Thanks

---

<div class="post-metadata">

**Author:** ![raymondkent](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.mautic.org/raymondkent/32/412_2.png) [@raymondkent](https://forum.mautic.org/u/raymondkent)\
**Post date:** [December 1, 2017, 12:21am UTC](https://forum.mautic.org/t/upgrade-to-2-11-0-email-error/10024/2 "2017-12-01T00:21:33Z")

</div>

Hi there,

I just upgraded to new version v2.11.0 and now I get this error when trying to select email channel and I cant create or go any further with emails.

Error message is “The site is currently offline due to encountering an error. If the problem persists, please contact the system administrator.  
System administrators, check server logs for errors.”

Here’s a copy of the log error that I think relates.

[2017-12-01 11:16:01] mautic.ERROR: DoctrineDBALExceptionInvalidFieldNameException: An exception occurred while executing ‘SELECT e0\_.is\_published AS is\_published\_0, e0\_.date\_added AS date\_added\_1, e0\_.created\_by AS created\_by\_2, e0\_.created\_by\_user AS created\_by\_user\_3, e0\_.date\_modified AS date\_modified\_4, e0\_.modified\_by AS modified\_by\_5, e0\_.modified\_by\_user AS modified\_by\_user\_6, e0\_.checked\_out AS checked\_out\_7, e0\_.checked\_out\_by AS checked\_out\_by\_8, e0\_.checked\_out\_by\_user AS checked\_out\_by\_user\_9, e0\_.id AS id\_10, e0\_.name AS name\_11, e0\_.description AS description\_12, e0\_.subject AS subject\_13, e0\_.from\_address AS from\_address\_14, e0\_.from\_name AS from\_name\_15, e0\_.reply\_to\_address AS reply\_to\_address\_16, e0\_.bcc\_address AS bcc\_address\_17, e0\_.template AS template\_18, e0\_.content AS content\_19, e0\_.utm\_tags AS utm\_tags\_20, e0\_.plain\_text AS plain\_text\_21, e0\_.custom\_html AS custom\_html\_22, e0\_.email\_type AS email\_type\_23, e0\_.publish\_up AS publish\_up\_24, e0\_.publish\_down AS publish\_down\_25, e0\_.read\_count AS read\_count\_26, e0\_.sent\_count AS sent\_count\_27, e0\_.revision AS revision\_28, e0\_.lang AS lang\_29, e0\_.variant\_settings AS variant\_settings\_30, e0\_.variant\_start\_date AS variant\_start\_date\_31, e0\_.dynamic\_content AS dynamic\_content\_32, e0\_.variant\_sent\_count AS variant\_sent\_count\_33, e0\_.variant\_read\_count AS variant\_read\_count\_34, e0\_.category\_id AS category\_id\_35, e0\_.translation\_parent\_id AS translation\_parent\_id\_36, e0\_.variant\_parent\_id AS variant\_parent\_id\_37, e0\_.unsubscribeform\_id AS unsubscribeform\_id\_38, e0\_.preference\_center\_id AS preference\_center\_id\_39 FROM emails e0\_ LEFT JOIN categories c1\_ ON e0\_.category\_id = c1\_.id WHERE e0\_.variant\_parent\_id IS NULL AND e0\_.translation\_parent\_id IS NULL ORDER BY e0\_.subject DESC LIMIT 50 OFFSET 0’: SQLSTATE[42S22]: Column not found: 1054 Unknown column ‘e0\_.preference\_center\_id’ in ‘field list’ - in file /xxxxxxxx/xxxxxxxxx/xxxxxxxxx/dmpages.com/m/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/AbstractMySQLDriver.php - at line 71 [] []

I have made a copy of my previous mautic install directory  
I then did a fresh mautic 2.11.0 install into original directory  
I copied the config from old to new and still have this issue.

From my little understanding it looks more like a database select query/issue that’s not working.

any suggestions on how to fix?

Thanks

---

<div class="post-metadata">

**Author:** ![bizcrony](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.mautic.org/bizcrony/32/409_2.png) [@bizcrony](https://forum.mautic.org/u/bizcrony)\
**Post date:** [December 1, 2017, 9:10am UTC](https://forum.mautic.org/t/upgrade-to-2-11-0-email-error/10024/3 "2017-12-01T09:10:32Z")

</div>

@raymondkent how you trying to update mautic ?

---

<div class="post-metadata">

**Author:** ![iSquirrel](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.mautic.org/isquirrel/32/36_2.png) [@iSquirrel](https://forum.mautic.org/u/iSquirrel)\
**Post date:** [December 5, 2017, 4:21pm UTC](https://forum.mautic.org/t/upgrade-to-2-11-0-email-error/10024/4 "2017-12-05T16:21:09Z")

</div>

Hi @bizcrony I have the same problem.

I tried to update mautic with the automatic install from inside the software.  
The installation got stuck on the clear cache so I have cleared the cache manually with the command `php app/console cache:clear`

![](https://a75.eu/cdn/images/Schermata2.jpg)

Now every thing seems to work ok but when I go to channels\>email I got the error “The site is currently offline due to encountering an error. If the problem persists, please contact the system administrator. System administrators, check server logs for errors.” see the image below:

![](https://a75.eu/cdn/images/Schermata1.jpg)

How can I solve this problem?

Andrea

---

<div class="post-metadata">

**Author:** ![bizcrony](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.mautic.org/bizcrony/32/409_2.png) [@bizcrony](https://forum.mautic.org/u/bizcrony)\
**Post date:** [December 5, 2017, 4:22pm UTC](https://forum.mautic.org/t/upgrade-to-2-11-0-email-error/10024/5 "2017-12-05T16:22:59Z")

</div>

@iSquirrel can you give me your FTP , check ma profile

---

<div class="post-metadata">

**Author:** ![iSquirrel](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.mautic.org/isquirrel/32/36_2.png) [@iSquirrel](https://forum.mautic.org/u/iSquirrel)\
**Post date:** [December 5, 2017, 4:26pm UTC](https://forum.mautic.org/t/upgrade-to-2-11-0-email-error/10024/6 "2017-12-05T16:26:58Z")

</div>

yes, where can I send you the credentials?

---

<div class="post-metadata">

**Author:** ![bizcrony](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.mautic.org/bizcrony/32/409_2.png) [@bizcrony](https://forum.mautic.org/u/bizcrony)\
**Post date:** [December 5, 2017, 4:28pm UTC](https://forum.mautic.org/t/upgrade-to-2-11-0-email-error/10024/7 "2017-12-05T16:28:06Z")

</div>

@iSquirrel check my profile and catch me if hard to find then you can email me [kishankumawat@live.com](mailto:kishankumawat@live.com)

---

<div class="post-metadata">

**Author:** ![iSquirrel](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.mautic.org/isquirrel/32/36_2.png) [@iSquirrel](https://forum.mautic.org/u/iSquirrel)\
**Post date:** [December 5, 2017, 9:12pm UTC](https://forum.mautic.org/t/upgrade-to-2-11-0-email-error/10024/8 "2017-12-05T21:12:14Z")

</div>

@bizcrony I found the error.  
I tried to update the database schema with the command

```auto
php app/console doctrine:schema:update --force
```

and now everything is working well.

Thank you
