VIew Not Found when opening table after changing date/time column

Troy · May 25, 2024, 4:21pm

Please fill in the questionnaire below.

Technical Help Questionnaire

Have you read and followed the instructions at: *READ ME FIRST* Technical Help FAQs - #2 by nigel ?

Answer: Yes

I am using baserow.io and paid subscription and not self-hosting.

Describe the problem

I made a change to a date column in one of my tables and now when I click on the table to display it, it shows “View Not Found” and offers to take me back to the dashboard.

If I try to export the table, I get:

The change I made was to set a specific timezone for the date/time column as I have colleagues in different timezones that need to enter data for other timezones.

Troy · May 26, 2024, 11:41am

I can access the table, but now I am missing a bunch of rows in that table. Any thoughts?

Do I have to restore from a snapshot? To me it looks like a bug with the way the datetime column handles timezones. If this could be unset on the backend, that would be great.

Update - I cannot access the table anymore. I suspect if I can figure out how to change to a different view of the table, one without the datetime, I could access it and change it.

olgatrykush · May 27, 2024, 8:27am

@davide, could you please check out this issue?

Troy · May 27, 2024, 11:20am

I made a new table in a new database with the field that I edited and believe to cause the problem.

In my table that stopped working, I had a date column:

I toggled the “set timezone for all collaborators” to on because I wanted data entry to be consistent across timezones.

When I hit save, that is when the trouble started to happen.

I was able to play around yesterday and access different views of the table and I could get some rows to show up, maybe 50 out of 300 would be displayed.

The other tables that were linked to this one still show the records that I can’t see, so I suspect the data isn’t gone.

olgatrykush · May 27, 2024, 12:32pm

Thanks for sharing all the details, @Troy! We will look into the issue as soon as possible.

Troy · May 28, 2024, 11:23am

Has there been any luck in fixing this?

I have to decide today whether to create a new database and upload/add the lost information from the snapshot.

Troy · May 28, 2024, 1:42pm

It looks like the data is back - I’ll run through it, but thank you (and your team) very much.

davide · May 28, 2024, 2:43pm

Hello @Troy,

sorry for the delay. We have been busy with the next release, and I wasn’t able to look into it earlier.

The errors you experienced are suspicious and it definitely shouldn’t happen.

If this issue occurs again, please don’t hesitate to reopen this thread. It would be greatly appreciated if you could provide some steps to reproduce the situation or determine if it’s related to a specific table or database.

I’ll try to look into it as soon as possible.

Troy · May 28, 2024, 4:05pm

There really weren’t steps to reproduce. I edited the column “Date and Time of shot” (screen capture above in the thread) which was a date column. I clicked the box that said “Set timezone for all collaborators” and clicked save.

I navigated to another page and came back and that is when I started to have issues. I can’t recall anything else that I would have done (other than add data manually). It has been pretty solid for me since I started using it last year.

I am looking at the database now and that box is ticked, but as far as I can tell it seems to be working as expected and my data is there.

Once I get some time, I’ll make a duplicate of the database and attempt to see if I can reproduce the issues.

One thing I did notice was that some of the views for that table worked (I had about 5 different grid views). Only one worked, but that would only show a partial dataset. I could see any patterns (hidden columns, or filters) as to why one would work.

Nassim · April 24, 2025, 3:01pm

Hello !

I’m experiencing the same kind of issue on specific views.

 [BACKEND][2025-04-24 14:44:52] ERROR 2025-04-24 14:44:50,993 django.request.log_response:241- Internal Server Error: /api/database/views/grid/59950/  (B 
 [BACKEND][2025-04-24 14:44:52] Traceback (most recent call last): (B 
 [BACKEND][2025-04-24 14:44:52]   File "/baserow/venv/lib/python3.11/site-packages/asgiref/sync.py", line 518, in thread_handler (B 
 [BACKEND][2025-04-24 14:44:52]     raise exc_info[1] (B 
 [BACKEND][2025-04-24 14:44:52]   File "/baserow/venv/lib/python3.11/site-packages/django/core/handlers/exception.py", line 42, in inner (B 
 [BACKEND][2025-04-24 14:44:52]     response = await get_response(request) (B 
 [BACKEND][2025-04-24 14:44:52]                ^^^^^^^^^^^^^^^^^^^^^^^^^^^ (B 
 [BACKEND][2025-04-24 14:44:52]   File "/baserow/venv/lib/python3.11/site-packages/asgiref/sync.py", line 518, in thread_handler (B 
 [BACKEND][2025-04-24 14:44:52]     raise exc_info[1] (B 
 [BACKEND][2025-04-24 14:44:52]   File "/baserow/venv/lib/python3.11/site-packages/django/core/handlers/base.py", line 253, in _get_response_async (B 
 [BACKEND][2025-04-24 14:44:52]     response = await wrapped_callback( (B 
 [BACKEND][2025-04-24 14:44:52]                ^^^^^^^^^^^^^^^^^^^^^^^ (B 
 [BACKEND][2025-04-24 14:44:52]   File "/baserow/venv/lib/python3.11/site-packages/asgiref/sync.py", line 468, in __call__ (B 
 [BACKEND][2025-04-24 14:44:52]     ret = await asyncio.shield(exec_coro) (B 
 [BACKEND][2025-04-24 14:44:52]           ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ (B 
 [BACKEND][2025-04-24 14:44:52]   File "/baserow/venv/lib/python3.11/site-packages/asgiref/current_thread_executor.py", line 40, in run (B 
 [BACKEND][2025-04-24 14:44:52]     result = self.fn(*self.args, **self.kwargs) (B 
 [BACKEND][2025-04-24 14:44:52]              ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ (B 
 [BACKEND][2025-04-24 14:44:52]   File "/baserow/venv/lib/python3.11/site-packages/asgiref/sync.py", line 522, in thread_handler (B 
 [BACKEND][2025-04-24 14:44:52]     return func(*args, **kwargs) (B 
 [BACKEND][2025-04-24 14:44:52]            ^^^^^^^^^^^^^^^^^^^^^ (B 
 [BACKEND][2025-04-24 14:44:52]   File "/baserow/venv/lib/python3.11/site-packages/django/views/decorators/csrf.py", line 65, in _view_wrapper (B 
 [BACKEND][2025-04-24 14:44:52]     return view_func(request, *args, **kwargs) (B 
 [BACKEND][2025-04-24 14:44:52]            ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ (B 
 [BACKEND][2025-04-24 14:44:52]   File "/baserow/venv/lib/python3.11/site-packages/django/views/generic/base.py", line 104, in view (B 
 [BACKEND][2025-04-24 14:44:52]     return self.dispatch(request, *args, **kwargs) (B 
 [BACKEND][2025-04-24 14:44:52]            ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ (B 
 [BACKEND][2025-04-24 14:44:52]   File "/baserow/venv/lib/python3.11/site-packages/rest_framework/views.py", line 509, in dispatch (B 
 [BACKEND][2025-04-24 14:44:52]     response = self.handle_exception(exc) (B 
 [BACKEND][2025-04-24 14:44:52]                ^^^^^^^^^^^^^^^^^^^^^^^^^^ (B 
 [BACKEND][2025-04-24 14:44:52]   File "/baserow/venv/lib/python3.11/site-packages/rest_framework/views.py", line 469, in handle_exception (B 
 [BACKEND][2025-04-24 14:44:52]     self.raise_uncaught_exception(exc) (B 
 [BACKEND][2025-04-24 14:44:52]   File "/baserow/venv/lib/python3.11/site-packages/rest_framework/views.py", line 480, in raise_uncaught_exception (B 
 [BACKEND][2025-04-24 14:44:52]     raise exc (B 
 [BACKEND][2025-04-24 14:44:52]   File "/baserow/venv/lib/python3.11/site-packages/rest_framework/views.py", line 506, in dispatch (B 
 [BACKEND][2025-04-24 14:44:52]     response = handler(request, *args, **kwargs) (B 
 [BACKEND][2025-04-24 14:44:52]                ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ (B 
 [BACKEND][2025-04-24 14:44:52]   File "/baserow/backend/src/baserow/api/decorators.py", line 113, in func_wrapper (B 
 [BACKEND][2025-04-24 14:44:52]     return func(*args, **kwargs) (B 
 [BACKEND][2025-04-24 14:44:52]            ^^^^^^^^^^^^^^^^^^^^^ (B 
 [BACKEND][2025-04-24 14:44:52]   File "/baserow/backend/src/baserow/api/decorators.py", line 348, in func_wrapper (B 
 [BACKEND][2025-04-24 14:44:52]     return func(*args, **kwargs) (B 
 [BACKEND][2025-04-24 14:44:52]            ^^^^^^^^^^^^^^^^^^^^^ (B 
 [BACKEND][2025-04-24 14:44:52]   File "/baserow/backend/src/baserow/api/decorators.py", line 178, in func_wrapper (B 
 [BACKEND][2025-04-24 14:44:52]     return func(*args, **kwargs) (B 
 [BACKEND][2025-04-24 14:44:52]            ^^^^^^^^^^^^^^^^^^^^^ (B 
 [BACKEND][2025-04-24 14:44:52]   File "/baserow/backend/src/baserow/contrib/database/api/views/grid/views.py", line 254, in get (B 
 [BACKEND][2025-04-24 14:44:52]     response, page, _ = paginate_and_serialize_queryset( (B 
 [BACKEND][2025-04-24 14:44:52]                         ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ (B 
 [BACKEND][2025-04-24 14:44:52]   File "/baserow/backend/src/baserow/contrib/database/api/views/utils.py", line 168, in paginate_and_serialize_queryset (B 
 [BACKEND][2025-04-24 14:44:52]     page = paginator.paginate_queryset(queryset, request) (B 
 [BACKEND][2025-04-24 14:44:52]            ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ (B 
 [BACKEND][2025-04-24 14:44:52]   File "/baserow/venv/lib/python3.11/site-packages/rest_framework/pagination.py", line 402, in paginate_queryset (B 
 [BACKEND][2025-04-24 14:44:52]     return list(queryset[self.offset:self.offset + self.limit]) (B 
 [BACKEND][2025-04-24 14:44:52]            ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ (B 
 [BACKEND][2025-04-24 14:44:52]   File "/baserow/venv/lib/python3.11/site-packages/django/db/models/query.py", line 400, in __iter__ (B 
 [BACKEND][2025-04-24 14:44:52]     self._fetch_all() (B 
 [BACKEND][2025-04-24 14:44:52]   File "/baserow/backend/src/baserow/core/db.py", line 470, in _fetch_all (B 
 [BACKEND][2025-04-24 14:44:52]     super()._fetch_all() (B 
 [BACKEND][2025-04-24 14:44:52]   File "/baserow/venv/lib/python3.11/site-packages/django/db/models/query.py", line 1928, in _fetch_all (B 
 [BACKEND][2025-04-24 14:44:52]     self._result_cache = list(self._iterable_class(self)) (B 
 [BACKEND][2025-04-24 14:44:52]                          ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ (B 
 [BACKEND][2025-04-24 14:44:52]   File "/baserow/venv/lib/python3.11/site-packages/django/db/models/query.py", line 91, in __iter__ (B 
 [BACKEND][2025-04-24 14:44:52]     results = compiler.execute_sql( (B 
 [BACKEND][2025-04-24 14:44:52]               ^^^^^^^^^^^^^^^^^^^^^ (B 
 [BACKEND][2025-04-24 14:44:52]   File "/baserow/venv/lib/python3.11/site-packages/django/db/models/sql/compiler.py", line 1595, in execute_sql (B 
 [BACKEND][2025-04-24 14:44:52]     return list(result) (B 
 [BACKEND][2025-04-24 14:44:52]            ^^^^^^^^^^^^ (B 
 [BACKEND][2025-04-24 14:44:52]   File "/baserow/venv/lib/python3.11/site-packages/django/db/models/sql/compiler.py", line 2099, in cursor_iter (B 
 [BACKEND][2025-04-24 14:44:52]     for rows in iter((lambda: cursor.fetchmany(itersize)), sentinel): (B 
 [BACKEND][2025-04-24 14:44:52]   File "/baserow/venv/lib/python3.11/site-packages/django/db/models/sql/compiler.py", line 2099, in <lambda> (B 
 [BACKEND][2025-04-24 14:44:52]     for rows in iter((lambda: cursor.fetchmany(itersize)), sentinel): (B 
 [BACKEND][2025-04-24 14:44:52]                               ^^^^^^^^^^^^^^^^^^^^^^^^^^ (B 
 [BACKEND][2025-04-24 14:44:52]   File "/baserow/venv/lib/python3.11/site-packages/django/db/utils.py", line 98, in inner (B 
 [BACKEND][2025-04-24 14:44:52]     return func(*args, **kwargs) (B 
 [BACKEND][2025-04-24 14:44:52]            ^^^^^^^^^^^^^^^^^^^^^ (B 
 [BACKEND][2025-04-24 14:44:52] ValueError: year 202522 is out of range (B 
 [BACKEND][2025-04-24 14:44:53] 172.18.0.5:0 - "GET /api/database/views/grid/59950/?limit=80&offset=0&include=field_options%2Crow_metadata HTTP/1.1" 500 (B

In order to create monthly view, i have this formula field, i use this formula. It has been working, but it seems throw this error.

totext(if(or(totext(month(field('START')))=totext(month(today())+1),totext(month(field('END')))=totext(month(today())+1)),"SHOW","HIDE"))

But i can’t find the specific ValueError: year 202522 is out of range

Any idea ?

olgatrykush · April 25, 2025, 11:39am

Hey @Nassim, could you please elaborate a bit more on the issue? Are you getting an error saying “view not found”? I want to confirm: the only recent change is that a previously working formula has stopped working. Do I understand correctly?

Nassim · May 22, 2025, 8:52am

Hi @olgatrykush ,

I find the problem, wich was a datetime_format() on link row. The formula failed when there was more than 1 entry. I encapsulate the formula in min() function.

This error caused, the view error.