Skip to content

"Data too long" when saving many profiles #42

@jensschuppe

Description

@jensschuppe

Since profiles are being stored as a single CiviCRM setting, which have a column length of 64k (MySQL data type TEXT), storing many™ profiles my exceed this limit.

Problem 1 is that the number of profiles is limited due to that column length.

Problem 2 is even worse, because CiviCRM did not throw Data too long errors until a recent version and cut the serialized value, which would cause corrupted data (i.e. profile data not be loaded anymore)

We should consider storing profiles as separate setting entries or somewhere else. The CiviCRM settings system does not seem scalable easily.

Metadata

Metadata

Assignees

No one assigned

    Labels

    enhancementNew feature or requeststatus:fixedThe issue has been resolved (usually by committing/merging code)

    Type

    No type

    Projects

    No projects

    Milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions