nextcloud / assistant

✨ Nextcloud Assistant
GNU Affero General Public License v3.0
30 stars 5 forks source link

Error with STRICT_TRANS_TABLES #95

Open janmuennich opened 3 months ago

janmuennich commented 3 months ago

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.