Project

General

Profile

Actions

Bug #8099

closed

Plans table reaching row size limits

Added by krileon almost 4 years ago. Updated over 3 years ago.

Status:
Closed
Priority:
High
Assignee:
Target version:
Start date:
23 July 2020
Due date:
% Done:

100%

Estimated time:

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

Actions

Also available in: Atom PDF