I encountered an error when I had my IP address in IPv6. The table exp_pro_search_log has a limited size for ip_address field, and that’s why I wasn’t getting any search results but the exception -
SQLSTATE[22001]: String data, right truncated: 1406 Data too long for column ‘ip_address’ at row 1:
INSERT INTO exp_pro_search_log (site_id, member_id, search_date, ip_address, keywords, parameters) VALUES (1, 150, 1682016324, ‘xxxx:xxxx:xxxx:xxxx:xxxx:xxxx:xxxx:xxxx’, ‘mosquito’, ‘{{{DOUBLEQUOTE:46ea97f4a9c38c3719771d1d7472ad27}}result_page{{DOUBLEQUOTE:46ea97f4a9c38c3719771d1d7472ad27}}:{{DOUBLEQUOTE:46ea97f4a9c38c3719771d1d7472ad27}}search\/results{{DOUBLEQUOTE:46ea97f4a9c38c3719771d1d7472ad27}}}’)
I changed the size of the column and got the error fixed. I think this column should have increased size now when you define it. Any thoughts?
Thanks.
Packet Tide owns and develops ExpressionEngine. © Packet Tide, All Rights Reserved.