The translations_orders.elementIds and translations_orders.tags are set to varchar(8160) which causes this table to exceed the limit. This PR changes the types of those column from varchar to text.
Related Issue(s):
432
Changes Made:
Changed column types in src/migrations/Install.php
Added migration to change column type for existing installs in src/migrations/m231213_114020_change_translations_orders_columns_to_text.php
Testing:
[Describe the testing performed to ensure the changes are functioning as expected.]
Quality Assurance (QA):
[ ] The code has been reviewed and approved by the QA team.
[ ] The changes have been tested on different environments (e.g., staging, production).
[ ] Integration tests have been performed to verify the interactions between components.
[ ] Performance tests have been conducted to ensure the changes do not impact system performance.
[ ] Any necessary database migrations or data transformations have been executed successfully.
[ ] Accessibility requirements have been considered and tested (e.g., screen reader compatibility, keyboard navigation).
Resources:
Screenshots (if applicable):
[Include any relevant screenshots to visually demonstrate the changes.]
Wrapping up
Checklist:
[ ] The code builds without any errors or warnings.
[ ] The code follows the project's coding conventions and style guidelines.
[ ] Unit tests have been added or updated to cover the changes made.
[ ] The documentation has been updated to reflect the changes (if applicable).
[ ] All new and existing tests pass successfully.
[ ] The PR has been reviewed by at least one other team member.
Additional Notes:
[Include any additional notes, considerations, or context that may be relevant.]
Pull Request
Description:
The
translations_orders.elementIdsandtranslations_orders.tagsare set tovarchar(8160)which causes this table to exceed the limit. This PR changes the types of those column fromvarchartotext.Related Issue(s):
432
Changes Made:
src/migrations/Install.phpsrc/migrations/m231213_114020_change_translations_orders_columns_to_text.phpTesting:
[Describe the testing performed to ensure the changes are functioning as expected.]
Quality Assurance (QA):
Resources:
Screenshots (if applicable): [Include any relevant screenshots to visually demonstrate the changes.]
Wrapping up
Checklist:
Additional Notes: [Include any additional notes, considerations, or context that may be relevant.]