Project

General

Profile

Actions

Bug #8099

closed

Plans table reaching row size limits

Added by krileon over 4 years ago. Updated about 4 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 #1

Updated by beat about 4 years ago

Fixed in commit 88a2e01db429f4be41ba0f286a472c48353fc95e by changing most var char (255) with text types.

Actions #2

Updated by beat about 4 years ago

  • Status changed from Feedback to Resolved
  • Assignee set to beat
  • % Done changed from 0 to 100
Actions #3

Updated by beat about 4 years ago

  • Status changed from Resolved to Closed
Actions

Also available in: Atom PDF