Views no longer working #6816
-
|
On my baremetal install (LXC on proxmox, v2.8.6), my Views have stopped working recently. They are no longer visible, nor can I open them in the settings. Creating a new View is also no longer possible. I can still click on 'views' and I get the pop-up, however if I click 'Save', nothing happens. |
Beta Was this translation helpful? Give feedback.
Replies: 2 comments 9 replies
-
|
Can't confirm that views are not working in 2.8.6 with Postgres. They work as usual. |
Beta Was this translation helpful? Give feedback.
-
|
I suppose you'll also get 500s when viewing your browser api calls in the development-tools. but good approach to have a look on the saves views table. |
Beta Was this translation helpful? Give feedback.
-
|
Unfortunately the document exporter errors out because the table doesn't exist... psycopg2.errors.UndefinedColumn: column documents_savedview.page_size does not exist And my backup from last month apparently has the same issue - which is strange, since I do not remember seeing this before. |
Beta Was this translation helpful? Give feedback.
-
|
using adminer I had a look at the datastructure... I am wondering if there was an update in the datastructure recently. In a fresh install the table has additional fields: compared to my original install: I'm guessing these missing columns is what is causing the data corruption. Could I simply add them to the table? |
Beta Was this translation helpful? Give feedback.
-
|
Adding the additional columns did the trick actually. Was a bit hesitant initially to tamper with the database, but since I had a backup it was ok if I messed up. |
Beta Was this translation helpful? Give feedback.
-
|
You didn't run migrations. That's a necessary step in bare metal installations. |
Beta Was this translation helpful? Give feedback.
-
|
This discussion has been automatically closed because it was marked as answered. Please see our contributing guidelines for more details. |
Beta Was this translation helpful? Give feedback.
Adding the additional columns did the trick actually. Was a bit hesitant initially to tamper with the database, but since I had a backup it was ok if I messed up.
With the columns added, I see the views immediately in the webui, and everything is working as it should. Still wondering what happened, as I cannot see anything mentioning a change to this table in the changelog.