I’m getting “The software powering this discussion forum encountered an unexpected problem” on topics with bookmarks. Reloading each topic after the error makes it go away.
I’m on the latest build: 2.8.0.beta10 (6b6c0fef4c)
סיכום מבוסס בינה מלאכותית
Users are encountering a database error related to the missing topic_id column when accessing bookmarked topics or using the Data Explorer plugin. Nacho_Caballero first reported the issue on Discourse v2.8.0.beta10, noting that reloading topics temporarily resolved it. pfaffman suggested checking for plugin conflicts or incomplete database migrations. After a server rebuild, Nacho_Caballero reported no further issues, though uncertainty remains about whether the rebuild was necessary or if the issue was transient. Separately, Vanessa_Aleksic-Brow experienced the same error in a Data Explorer report, confirming the topic_id column is missing from the table — a problem they cannot resolve without admin access. The issue appears tied to recent upgrades or migrations, and while rebuilding may help, the root cause — such as a failed migration or schema change — remains unconfirmed. sam followed up to check on the rebuild outcome, which Nacho_Caballero confirmed was successful, though they also noted a side issue with missing avatars post-rebuild linked here.
Are you using any plugins? Maybe try safe_mode.
Or perhaps somehow your database didn’t get migrated on an upgrade?
Thanks, Jay.
I’ve gone into all my existing bookmarks and besides the 2 errors I saw this morning, no others came up (in normal or safe mode).
I might rebuild from the server tomorrow, but it seems like it was a temporary error. 
How did the rebuild go?
No issues after the rebuild, but I’m not sure if it’s because a rebuild was needed or because I didn’t have enough old unvisited bookmarked topics to test.
UPDATE: @sam Actually, I did run into an issue with missing avatar profile pics
I’ve run into the same error on a saved report I had created using the plugin for Data Explorer.
PG::UndefinedColumn: ERROR: column "topic_id" does not exist
LINE 46: topic_id,
I looked at the table and topic_id isn’t on the columns list anymore. I’m not an administrator, so I’m not sure what action I can take to try and fix this, or why it would disappear in the first place.
