Project

General

Profile

Actions
Copy link

Bug #4128

closed

Field creation limit due to column size limits

Added by krileon over 11 years ago. Updated about 10 years ago.

Status:
Closed
Priority:
Normal
Assignee:
krileon
Target version:
CB 2.0.0
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
Copy link
 #1

Updated by beat over 11 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
Copy link
 #3

Updated by krileon almost 11 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
Copy link
 #4

Updated by krileon almost 11 years ago

  • % Done changed from 0 to 70
Actions
Copy link
 #5

Updated by krileon almost 11 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
Copy link
 #6

Updated by beat about 10 years ago

  • Priority changed from Urgent to Normal
Actions
Copy link
 #7

Updated by beat about 10 years ago

  • Status changed from Resolved to Closed
Actions
Copy link

Also available in: Atom PDF