[ActivityStore] Add ActivityStore implementation based on JSON data type of mysql

[fashxp]

see https://dev.mysql.com/doc/refman/8.0/en/json.html
and https://mariadb.com/kb/en/library/json-data-type/

[NiklasBr]

@fashxp Any progress on this issue?

We are still seeing errors like this:

[fashxp]

that's probably because you're using the wrong activity store for your DB backend.
if you are using mysql, you need to configure the activity store as we do in our demo: https://github.com/pimcore/demo/blob/10.x/config/cmf.yaml#L26

[NiklasBr]

Thanks. Where can I find documentation about this configuration?

[fashxp]

here and here is what we have: https://pimcore.com/docs/customer-management-framework/current/Installation/index.html and https://pimcore.com/docs/customer-management-framework/current/Activities/index.html#page_ActivityStore

any contributions to add more clarification are highly appreciated.

[NiklasBr]

I'd love to help, but I don't know or understand the motivation or design for the requirement of MariaDB. In other words, I can't help with the documentation because the documentation is missing information. So to whoever designed it this way I too say that any contributions to add more clarification are highly appreciated!

[github-actions]

Thanks a lot for reporting the issue. We did not consider the issue as "Pimcore:Priority", "Pimcore:ToDo" or "Pimcore:Backlog", so we're not going to work on that anytime soon. Please create a pull request to fix the issue if this is a bug report. We'll then review it as quickly as possible. If you're interested in contributing a feature, please contact us first here before creating a pull request. We'll then decide whether we'd accept it or not. Thanks for your understanding.