Summary
When running Fizzy on MariaDB, requests fail with:
ActiveRecord::ConfigurationError: the column 'fields' has not been configured as a store raised from Filter.from_params. MariaDB exposes JSON as LONGTEXT, so Rails store_accessor doesn't recognize it as a structured column.
Steps to Reproduce
- Use MariaDB (e.g., 10.6/11.x) with Fizzy
- Run
bin/rails db:prepare
- Hit
/0000001/ or a board page
Temporary Workaround
Adding:
store :fields, coder: JSON
to app/models/filter.rb
and:
store :particulars, coder: JSON
to app/models/event.rb
Summary
When running Fizzy on MariaDB, requests fail with:
ActiveRecord::ConfigurationError: the column 'fields' has not been configured as a storeraised fromFilter.from_params. MariaDB exposes JSON as LONGTEXT, so Railsstore_accessordoesn't recognize it as a structured column.Steps to Reproduce
bin/rails db:prepare/0000001/or a board pageTemporary Workaround
Adding:
to app/models/filter.rb
and:
to app/models/event.rb