comment_agent field is too small

[itzik770]

The comment_agent field in comments table is too small (255).

This causes an error if user agent field is larger than 255 - the comment is not inserted, and no message is displayed.
making this field 500 length fixed this problem

[dd32]

See #10389 - Truncate the field in order to prevent errors (not inserting).

Not sure increasing the length would be advisable however..

dev-feedback pending review of increasing the length or not. (If meta comes in, Storing such items in commentmeta would be better suited IMO)

[scribu]

Should wait for #2659.

[brianwhite]

I am not sure that this can wait given the coming release of Windows 7 next month. After I upgraded from windows Vista to Windows 7 I discovered that my user agent was too long. Further investigation revealed that many installations of Internet Explorer on computers that have been in use for a period of time and have multiple versions of the .NET CLR, etc. installed have user agent strings which exceed 255 when the Windows 7 specific strings were added after the upgrade. (The user agent sting is shorter and not problematical in fresh installations of Windows 7.) The likely hood of this happening becomes even greater with the introduction of tools like the Google Chrome Frame which add to the user agent string.

[scribu]

The best solution would be to move it to the new commentmeta table.

[scribu]

See #10856

[dd32]

Closing as duplicate of #10389 and #10856