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:655fa3312c0bd6f47c910c7bb832f508}}result_page{{DOUBLEQUOTE:655fa3312c0bd6f47c910c7bb832f508}}:{{DOUBLEQUOTE:655fa3312c0bd6f47c910c7bb832f508}}search\/results{{DOUBLEQUOTE:655fa3312c0bd6f47c910c7bb832f508}}}’)
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.