Actions
Bug #8099
closedPlans table reaching row size limits
Description
The _cbsubs_plans table contains 162 columns. Many are varchar(255) with some varchar(256) (is this a bug?) columns that could be converted to text type. Changing them to text type would result in a smaller 20 byte pointer to reduce row size and prevent hitting row size limit errors (8k byte default for innodb). Several yes/no (1/0) columns are also using tinyint(4) instead of just tinyint(1) wasting additional bytes.
https://www.joomlapolis.com/forum/255-developer-members-support/242725-1118-error-on-cbsubs?start=6
Updated by beat about 4 years ago
Fixed in commit 88a2e01db429f4be41ba0f286a472c48353fc95e by changing most var char (255) with text types.
Updated by beat about 4 years ago
- Status changed from Feedback to Resolved
- Assignee set to beat
- % Done changed from 0 to 100
Actions