We use cookies to improve your experience. No personal information is gathered and we don't serve ads. Cookies Policy.

ExpressionEngine Logo ExpressionEngine
Features Pricing Support Find A Developer
Partners Upgrades
Blog Add-Ons Learn
Docs Forums University
Log In or Sign Up
Log In Sign Up
ExpressionEngine Logo
Features Pro new Support Find A Developer
Partners Upgrades
Blog Add-Ons Learn
Docs Forums University Blog
  • Home
  • Forums

Bug in Pro Search

Development and Programming

Hop Studios's avatar
Hop Studios
481 posts
2 years ago
Hop Studios's avatar Hop Studios

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.

       
Rob Allen's avatar
Rob Allen
3,105 posts
2 years ago
Rob Allen's avatar Rob Allen

I’m wondering whether an auto pruning facility would work here to prevent this? Or whether capturing IP address is actually needed.

       

Reply

Sign In To Reply

ExpressionEngine Home Features Pro Contact Version Support
Learn Docs University Forums
Resources Support Add-Ons Partners Blog
Privacy Terms Trademark Use License

Packet Tide owns and develops ExpressionEngine. © Packet Tide, All Rights Reserved.