Field value is not updating real-time automatically via link field between 2 tables

Feedback
, ,
12

I found the 500 error problem.
It was because of lookup field in baserow. Hmmm…

When I have lookup fields and try to create a new row using api, it keeps returning 500 internal error.
Once I removed lookup fields and a new row was created successfully via api.

[POSTGRES][2024-02-27 07:27:46] 2024-02-27 07:27:46.862 UTC [78317] baserow@baserow ERROR:  cannot extract elements from a scalar
 [BACKEND][2024-02-27 07:27:46] 127.0.0.1:40136 - "GET /api/_health/ HTTP/1.1" 200
 [BACKEND][2024-02-27 07:27:46] ERROR 2024-02-27 07:27:46,865 django.request.log_response:241- Internal Server Error: /api/database/rows/table/522/
 [BACKEND][2024-02-27 07:27:46] Traceback (most recent call last):
 [BACKEND][2024-02-27 07:27:46]   File "/baserow/venv/lib/python3.9/site-packages/django/db/backends/utils.py", line 89, in _execute
 [BACKEND][2024-02-27 07:27:46]     return self.cursor.execute(sql, params)
 [BACKEND][2024-02-27 07:27:46] psycopg2.errors.InvalidParameterValue: cannot extract elements from a scalar
 [BACKEND][2024-02-27 07:27:46]
 [BACKEND][2024-02-27 07:27:46]
 [BACKEND][2024-02-27 07:27:46] The above exception was the direct cause of the following exception:
 [BACKEND][2024-02-27 07:27:46]
 [BACKEND][2024-02-27 07:27:46] Traceback (most recent call last):
 [BACKEND][2024-02-27 07:27:46]   File "/baserow/venv/lib/python3.9/site-packages/asgiref/sync.py", line 486, in thread_handler
 [BACKEND][2024-02-27 07:27:46]     raise exc_info[1]
 [BACKEND][2024-02-27 07:27:46]   File "/baserow/venv/lib/python3.9/site-packages/django/core/handlers/exception.py", line 43, in inner
 [BACKEND][2024-02-27 07:27:46]     response = await get_response(request)
 [BACKEND][2024-02-27 07:27:46]   File "/baserow/venv/lib/python3.9/site-packages/django/core/handlers/base.py", line 253, in _get_response_async
 [BACKEND][2024-02-27 07:27:46]     response = await wrapped_callback(
 [BACKEND][2024-02-27 07:27:46]   File "/baserow/venv/lib/python3.9/site-packages/asgiref/sync.py", line 448, in __call__

See this guy has the same problem.

  1. Can I know why this happened?
  2. This sounds like I can’t use lookup fields??
  3. Have your team fixed this problem in a new version or not?

Please let me know.
Thanks.