Error with STRICT_TRANS_TABLES

[janmuennich]

Which version of assistant are you using?

1.1.0

Which version of Nextcloud are you using?

29.0.3

Which browser are you using? In case you are using the phone App, specify the Android or iOS version and device please.

No response

Describe the Bug

Configured with external app llm2, any call to LLM fails with the SQL error General error: 1364 Field 'result' doesn't have a default value

This happened on Percona MySQL 8.0 with STRICT_TRANS_TABLES enabled, which should be the default for most MySQL/MariaDB installations. After disabling STRICT_TRANS_TABLES, the call works.

Nextcloud MySQL Error.txt

Expected Behavior

Assistant to work with STRICT_TRANS_TABLES enabled as the rest of Nextcloud.

To Reproduce

See above.