stream icon indicating copy to clipboard operation
stream copied to clipboard

meta_value column size too small for certain meta data such as user_meta

Open johnolek opened this issue 8 years ago • 0 comments

I noticed an issue with certain meta data saving in the latest version of Stream. The stream_meta table includes a column named meta_value that is defined to be a VARCHAR with a max length of 200 characters. On our site, the values we're getting for user_meta are frequently over 200 characters, resulting in a MySQL error and preventing the data from being saved.

The table is defined here: https://github.com/xwp/stream/blob/develop/classes/class-install.php#L448

Is this something we could resolve by manually updating the table definition to have a higher limit, e.g. change 200 to 2000? Or would that change be wiped out in future updates if this code is executed on update and dbDelta sees that 2000 should actually be 200?

johnolek avatar Jan 17 '17 22:01 johnolek