# 升级后无法加载 categories.json，报错

**URL:** https://meta.discourse.org/t/after-upgrade-unable-to-load-categories-json-with-error/82540
**Category:** Bug
**Created:** [2018年三月8日 19:07 UTC](https://meta.discourse.org/t/after-upgrade-unable-to-load-categories-json-with-error/82540 "2018-03-08T19:07:54Z")
**Posts on this page:** 5
**Page:** 1

<div class="post-metadata">

### Author: ![Magnetidog](https://sea3.discourse-cdn.com/meta/user_avatar/meta.discourse.org/magnetidog/32/116910_2.png) [@Magnetidog](https://meta.discourse.org/u/Magnetidog)
#### Post date: [2018年三月8日 19:07 UTC](https://meta.discourse.org/t/after-upgrade-unable-to-load-categories-json-with-error/82540/1 "2018-03-08T19:07:54Z")

</div>

We upgraded to the latest Discourse build; no major plugin installed, other than the fact we have a subdirectory install.

The error I am seeing in the logs is the following:

failed to handle exception in exception app middleware : PG::UndefinedColumn: ERROR: column categories.suppress\_from\_homepage does not exist

Is there some known issue?

(Edited this as before I thought it was a subdir error)

---

<div class="post-metadata">

### Author: ![Magnetidog](https://sea3.discourse-cdn.com/meta/user_avatar/meta.discourse.org/magnetidog/32/116910_2.png) [@Magnetidog](https://meta.discourse.org/u/Magnetidog)
#### Post date: [2018年三月8日 19:30 UTC](https://meta.discourse.org/t/after-upgrade-unable-to-load-categories-json-with-error/82540/2 "2018-03-08T19:30:51Z")

</div>

Still investigating this, as it seems to happen only in one of the two forums I upgraded.

I have created that column via psql for now and that brought the forum back online - unfortunately I am not familiar with when/if that column was removed.

---

<div class="post-metadata">

### Author: ![michaeld](https://sea3.discourse-cdn.com/meta/user_avatar/meta.discourse.org/michaeld/32/1594_2.png) [@michaeld](https://meta.discourse.org/u/michaeld)
#### Post date: [2018年三月8日 21:05 UTC](https://meta.discourse.org/t/after-upgrade-unable-to-load-categories-json-with-error/82540/3 "2018-03-08T21:05:35Z")

</div>

Run db:seed\_fu after the import, that will fix it.

Not too fond of this delayed-drop column mechanism, it haunted us too many times… 😢

---

<div class="post-metadata">

### Author: ![Magnetidog](https://sea3.discourse-cdn.com/meta/user_avatar/meta.discourse.org/magnetidog/32/116910_2.png) [@Magnetidog](https://meta.discourse.org/u/Magnetidog)
#### Post date: [2018年三月8日 21:07 UTC](https://meta.discourse.org/t/after-upgrade-unable-to-load-categories-json-with-error/82540/4 "2018-03-08T21:07:19Z")

</div>

Thank you Michael, this has helped! Also for the future!

---

<div class="post-metadata">

### Author: ![riking](https://sea3.discourse-cdn.com/meta/user_avatar/meta.discourse.org/riking/32/170938_2.png) [@riking](https://meta.discourse.org/u/riking)
#### Post date: [2018年三月8日 21:43 UTC](https://meta.discourse.org/t/after-upgrade-unable-to-load-categories-json-with-error/82540/5 "2018-03-08T21:43:28Z")

</div>

> [@Magnetidog](#):
>
> unfortunately I am not familiar with when/if that column was removed.

Looks like it was very recently:

> [@Discourse 2.0.0.beta4 Release Notes](https://meta.discourse.org/t/discourse-2-0-0-beta4-release-notes/82446):
>
> New features in 2.0.0.beta4 Two Factor Authentication via TOTP Thanks to community contributor @awole20 we now support Two Factor Authentication on Discourse! Two Factor Authentication can be enabled from a user’s preferences page. After verifying their password a user is prompted to scan the QR code via a supported app on their mobile device. After enabling Two Factor Authentication all existing login sessions are invalidated (you’ll need to log into all browsers again). …

Heading “Suppress category from latest”.
