basecamp / basecamp/fizzy

MariaDB JSON columns cause ActiveRecord::ConfigurationError with store_accessor (filters.fields)

Open
#2,402 3 comments 0 reactions 0 assignees View on GitHub
Dominant language
Ruby
Stars
8.2k
Forks
1.2k
Avg merge
2d 13h
Merged PRs (30d)
62

Description

### 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

1. Use MariaDB (e.g., 10.6/11.x) with Fizzy
2. Run `bin/rails db:prepare`
3. Hit `/0000001/` or a board page

### Temporary Workaround

Adding:

```ruby
store :fields, coder: JSON
```
to app/models/filter.rb

and:

```ruby
store :particulars, coder: JSON
```
to app/models/event.rb

Contributor guide

Open the contributing guide

Assessment

This issue has not been assessed yet.

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.