[buddypress-trac] [BuddyPress] #4118: `primary_link` column in wp_bp_activity allows too few characters

buddypress-trac at lists.automattic.com buddypress-trac at lists.automattic.com
Tue Apr 3 23:55:10 UTC 2012

#4118: `primary_link` column in wp_bp_activity allows too few characters
 Reporter:  boonebgorges  |      Owner:
     Type:  defect (bug)  |     Status:  new
 Priority:  normal        |  Milestone:  1.5.6
Component:  Activity      |    Version:
 Severity:  normal        |   Keywords:
 The `primary_link` column in the activity table is set to `varchar(150)`,
 and has been since the introduction of the column. It's not very uncommon
 for BP item URLs to be longer than this - imagine especially a forum topic
 inside of a group. If you have such a long URL at the moment, it gets
 cropped down to 150, and the `primary_link` (which is not used anywhere in
 BP to my knowledge, but is used by some plugins) ends up being incorrect.

 I can't think of a good reason for having this limitation. The column is
 not indexed, and only in an edge case would one ever need to include it in
 a `WHERE` clause. If we must use `varchar` instead of something like
 `text`, let's bump the limit up to something very high, like maybe 10000.


Ticket URL: <https://buddypress.trac.wordpress.org/ticket/4118>
BuddyPress <http://buddypress.org/>

More information about the buddypress-trac mailing list