MariaDB JSON columns cause ActiveRecord::ConfigurationError with store_accessor (filters.fields)
Author: omertahaoztopCreated Jan 20, 2026Updated Aug 15, 2026
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: JSONto app/models/filter.rb
and:
store :particulars, coder: JSONto app/models/event.rb
Source: basecamp/fizzy