Problem with base.query()

[gino909]

Hi
I have a problem with one of our tables.
We have a python script which was running smothly, but now with 1 table is not running anymore also with only a rudimentary sql statement as follows:

sql = “select * from D.Flow”
dflow_queryset = base.query(sql)

I am getting following error message:

Traceback (most recent call last):
File “index.py”, line 168, in
dflow_queryset = base.query(sql)
File “/usr/local/lib/python3.7/site-packages/seatable_api/main.py”, line 842, in query
converted_results = convert_db_rows(metadata, results)
File “/usr/local/lib/python3.7/site-packages/seatable_api/utils.py”, line 127, in convert_db_rows
is_sm_structure, column_options = is_single_multiple_structure(column)
File “/usr/local/lib/python3.7/site-packages/seatable_api/utils.py”, line 105, in is_single_multiple_structure
options = column.get(‘data’, {}).get(‘options’, )
AttributeError: ‘NoneType’ object has no attribute ‘get’

When I choose another table the query works.
When I run the sql in the SQL plugin works too…

Can you give me any hint what it could be the problem?

Thank you

[gino909]

Hi
I have found the problem
The API-Sql problem occurs when there is a multi-select column without values to select.
For example I have added a multi-select column “test” without values

Now the SQL failes

After adding a value

the base.query(sql) works again

Regards

[cdb]

Thanks for reporting. We will look at this issue.

[rdb]

@gino909 Thanks for reporting the issue and your patience.

But I think your patience has paid off: Can you test again? SeaTable 3.3 / an update of your SeaTable Server to 3.3 should solve the issue.