Bug - "Data too long for column 'profile_value'" when fulltext searching with long input

[pboguslawski]

Environment

• Server OS: Linux
• Browser: Any
• Znuny version: 6.5.11

Expected behavior

No error in error.log after full text search with long input.

Actual behavior

Error in error.log after full text search with long input.

How to reproduce

Steps to reproduce the behavior:

Run full text search for long text i.e.

a01234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789b

See error thrown in log:

[Tue Nov 19 14:03:01 2024] -e: DBD::mysql::db do failed: Data too long for column 'profile_value' at row 1 at /opt/otrs/Kernel/System/DB.pm line 504.
ERROR: OTRS-CGI-1 Perl: 5.32.1 OS: linux Time: Tue Nov 19 13:03:01 2024

 Message: Data too long for column 'profile_value' at row 1; DB server error code: 1406; SQL query: '
                INSERT INTO search_profile
                (login, profile_name,  profile_type, profile_key, profile_value)
                VALUES (?, ?, ?, ?, ?)
                '

 RemoteAddress: [...]
 RequestURI: /otrs/index.pl

 Traceback (3130):
   Module: Kernel::System::SearchProfile::SearchProfileAdd Line: 114
   Module: Kernel::Modules::AgentTicketSearch::Run Line: 515
   Module: Kernel::System::Web::InterfaceAgent::Run Line: 1150
   Module: ModPerl::ROOT::ModPerl::Registry::opt_otrs_bin_cgi_2dbin_index_2epl::handler Line: 39
   Module: (eval) (v1.99) Line: 207
   Module: ModPerl::RegistryCooker::run (v1.99) Line: 207
   Module: ModPerl::RegistryCooker::default_handler (v1.99) Line: 173
   Module: ModPerl::Registry::handler (v1.99) Line: 32