Project

General

Profile

Actions

Bug #4128

closed

Field creation limit due to column size limits

Added by krileon almost 8 years ago. Updated over 6 years ago.

Status:
Closed
Priority:
Normal
Assignee:
Target version:
Start date:
30 July 2013
Due date:
% Done:

100%

Estimated time:

Description

Currently you can only create roughly 100 fields due to _comprofiler MYSQL column size limits. Proposed workaround below should be officially implemented to end this issue for good.

http://www.joomlapolis.com/forum/64-rc3-general-discussions/78961-comprofiler-table-reaches-maximum-database-fields#78981

It's beginning to affect far too many users for a workaround to be viable. Changing from varchar will slightly make queries slower, but probably isn't noticeable.

https://www.joomlapolis.com/forum/153-professional-member-support/222114-comprofiler-table-reaches-maximum-database-fields

Actions #1

Updated by beat almost 8 years ago

I believe that a simple ALTER to move the storage engine from MyISAM to InnoDB removes that constraint completely.

But it should not be done on CB update, it could be done in Tools.

Actions #3

Updated by krileon over 7 years ago

Update CB DB tools check to check if the CB tables engine matches _users. This should be a forward upgrade only from XYZ to innodb.

Actions #4

Updated by krileon over 7 years ago

  • % Done changed from 0 to 70
Actions #5

Updated by krileon over 7 years ago

  • Status changed from Assigned to Resolved
  • % Done changed from 70 to 100

Proper upgrade to InnoDB is now possible. This should remove the column size limits for most.

Actions #6

Updated by beat almost 7 years ago

  • Priority changed from Urgent to Normal
Actions #7

Updated by beat over 6 years ago

  • Status changed from Resolved to Closed
Actions

Also available in: Atom PDF