View Issue Details

IDProjectCategoryView StatusLast Update
0006831OXID eShop (all versions)4.01. Database handlingpublic2022-01-19 10:32
Reportermkr73 Assigned To 
PrioritynormalSeverityfeatureReproducibilityalways
Status resolvedResolutionfixed 
Fixed in Version7.0.0-rc.2 
Summary0006831: Increase Column size for Text columns in oxcontents
DescriptionIn relation with the VisualCMS module, i run a size store problem.
With the new DSGVO (over 65535 bytes big) a can not store the whole Text.
I have to split the the Text and include theme per Smarty code ([{oxcontent ident="trackingoptout"}])

Is it possible to use MEDIUMTEXT or LONGTEXT instead of TEXT type?
Steps To ReproduceAdd a Text bigger than 65535 bytes long, and store them in the VisualCMS or CMS-Pages menu.
Only the first 65535 bytes will be stored. In VisualCMS the whole syntax will be damaged.
TagsNo tags attached.
ThemeNot defined
BrowserNot defined
PHP VersionNot defined
Database VersionNot defined

Activities

QA

2018-05-25 17:00

administrator   ~0012484

I changed the database field type to MEDIUMTEXT and did not encounter any problems. Maybe the table allocates more storage, but the performance didn't seem to get worse.

Think you can change it on you own, but - like always as you change something - I recommend sufficient testing.

[sp]