Error when having multiple Tag fields on Nova Resource

[cv-chameleon]

Hi,

first of all thanks for the very nice package (and all other Spatie packages!)

I have a Product model which has multiple tag groups, so I made 2 Tag input fields on my Nova resource:

Tags::make(__('nova.product.product_attributes'))->type('product_attributes')->hideFromIndex(), Tags::make(__('nova.product.supplement_categories'))->type('supplement_categories')->hideFromIndex(),

On my local develoment setup with 10.3.39-MariaDB everything seems ok. But on my Forge server setup (mysql Ver 8.0.31 for Linux on x86_64 (MySQL Community Server - GPL)) I get following error when trying to save 1 or multiple tags.

This is the error I get:

SQLSTATE[22032]: <<Unknown error>>: 3141 Invalid JSON text in argument 1 to function json_extract: "Missing a comma or '}' after an object member." at position 19.

This is the exact query that's executed:
select * from tagswheretype = "product_attributes" and (json_unquote(json_extract(name, '$."nl"')) = "Glutenvrij natuur" or json_unquote(json_extract(slug, '$."nl"')) = "Glutenvrij natuur") limit 1

So when I run this query directly on my database, on my local setup I don't get an error. On my PROD environment I get the error returned.

While the installation requirements say that you need MySQL 5.5 or higher?

Thanks very much in advance.

EDIT:

After more debugging I found there was a typo in 1 of the values in the slug column.
It said {"nl":"glutenvrij,"fr":"sans-glutes"} instead of {"nl":"glutenvrij","fr":"sans-glutes"}.

My bad!

[cv-chameleon]

After more debugging I found there was a typo in 1 of the values in the slug column.
It said {"nl":"glutenvrij,"fr":"sans-glutes"} instead of {"nl":"glutenvrij","fr":"sans-glutes"}.

So nevermind :)