# The site is currently offline due to encountering an error. (After Update)

**URL:** <https://forum.mautic.org/t/the-site-is-currently-offline-due-to-encountering-an-error-after-update/9985>\
**Category:** Product Support\
**Created:** [November 26, 2017, 8:33am UTC](https://forum.mautic.org/t/the-site-is-currently-offline-due-to-encountering-an-error-after-update/9985 "2017-11-26T08:33:24Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![luizeof](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.mautic.org/luizeof/32/241_2.png) [@luizeof](https://forum.mautic.org/u/luizeof)\
**Post date:** [November 26, 2017, 8:33am UTC](https://forum.mautic.org/t/the-site-is-currently-offline-due-to-encountering-an-error-after-update/9985/1 "2017-11-26T08:33:24Z")

</div>

i got an error while executing Mautic after UPDATE.  
  
  
  
error code is :

Quote:

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

  
Help me please !

---

<div class="post-metadata">

**Author:** ![luizeof](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.mautic.org/luizeof/32/241_2.png) [@luizeof](https://forum.mautic.org/u/luizeof)\
**Post date:** [November 26, 2017, 8:33am UTC](https://forum.mautic.org/t/the-site-is-currently-offline-due-to-encountering-an-error-after-update/9985/2 "2017-11-26T08:33:24Z")

</div>

i got an error while executing Mautic after UPDATE.

error code is :

> [@](#):
>
> [2017-11-26 15:19:16] mautic.ERROR: DoctrineDBALExceptionInvalidFieldNameException: An exception occurred while executing ‘SELECT m0\_.is\_published AS is\_published\_0, m0\_.date\_added AS date\_added\_1, m0\_.created\_by AS created\_by\_2, m0\_.created\_by\_user AS created\_by\_user\_3, m0\_.date\_modified AS date\_modified\_4, m0\_.modified\_by AS modified\_by\_5, m0\_.modified\_by\_user AS modified\_by\_user\_6, m0\_.checked\_out AS checked\_out\_7, m0\_.checked\_out\_by AS checked\_out\_by\_8, m0\_.checked\_out\_by\_user AS checked\_out\_by\_user\_9, m0\_.id AS id\_10, m0\_.name AS name\_11, m0\_.description AS description\_12, m0\_.subject AS subject\_13, m0\_.from\_address AS from\_address\_14, m0\_.from\_name AS from\_name\_15, m0\_.reply\_to\_address AS reply\_to\_address\_16, m0\_.bcc\_address AS bcc\_address\_17, m0\_.template AS template\_18, m0\_.content AS content\_19, m0\_.utm\_tags AS utm\_tags\_20, m0\_.plain\_text AS plain\_text\_21, m0\_.custom\_html AS custom\_html\_22, m0\_.email\_type AS email\_type\_23, m0\_.publish\_up AS publish\_up\_24, m0\_.publish\_down AS publish\_down\_25, m0\_.read\_count AS read\_count\_26, m0\_.sent\_count AS sent\_count\_27, m0\_.revision AS revision\_28, m0\_.lang AS lang\_29, m0\_.variant\_settings AS variant\_settings\_30, m0\_.variant\_start\_date AS variant\_start\_date\_31, m0\_.dynamic\_content AS dynamic\_content\_32, m0\_.variant\_sent\_count AS variant\_sent\_count\_33, m0\_.variant\_read\_count AS variant\_read\_count\_34, m0\_.category\_id AS category\_id\_35, m0\_.translation\_parent\_id AS translation\_parent\_id\_36, m0\_.variant\_parent\_id AS variant\_parent\_id\_37, m0\_.unsubscribeform\_id AS unsubscribeform\_id\_38, m0\_.preference\_center\_id AS preference\_center\_id\_39 FROM maupv\_emails m0\_ LEFT JOIN maupv\_categories m1\_ ON m0\_.category\_id = m1\_.id WHERE m0\_.variant\_parent\_id IS NULL AND m0\_.translation\_parent\_id IS NULL ORDER BY m0\_.subject DESC LIMIT 30 OFFSET 0’: Unknown column ‘m0\_.preference\_center\_id’ in ‘field list’ - in file /home/admin/web/email.klubsehat.id/public\_html/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/AbstractMySQLDriver.php - at line 71

Help me please !

---

<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:** [November 27, 2017, 11:49am UTC](https://forum.mautic.org/t/the-site-is-currently-offline-due-to-encountering-an-error-after-update/9985/3 "2017-11-27T11:49:09Z")

</div>

@fianbiasa check my profile ,  
what was your old version?  
HOw did you update ?  
There was any data in your mautic.

---

<div class="post-metadata">

**Author:** ![luizeof](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.mautic.org/luizeof/32/241_2.png) [@luizeof](https://forum.mautic.org/u/luizeof)\
**Post date:** [December 11, 2017, 8:15am UTC](https://forum.mautic.org/t/the-site-is-currently-offline-due-to-encountering-an-error-after-update/9985/4 "2017-12-11T08:15:24Z")

</div>

[quote=27284:@bizcrony]@fianbiasa check my profile ,  
what was your old version?  
HOw did you update ?  
There was any data in your mautic.[/quote]

version 2.9.0  
press update button.  
sure

---

<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 11, 2017, 8:27am UTC](https://forum.mautic.org/t/the-site-is-currently-offline-due-to-encountering-an-error-after-update/9985/5 "2017-12-11T08:27:55Z")

</div>

@fianbiasa how are you doing update…? \*from Dashboard? From Ssh, or by doing upgrade.php, make sure before update clear cache and update schema
