I am getting the error all over my site, and can't seem to find a way to at least hide it without disabling the module.
Somehow the system thinks my ip address is ' 2607:fcc8:b501:c900:b008:34ff:1f50:b60c'
Which is probably the machine id?
Anyway, here is the error. Any help appreciated.
QLSTATE[22001]: String data, right truncated: 1406 Data too long for column 'ip_address' at row 1
IPGV&M: could not save location to db: provider: google ip_address: 2307:fdc8:b5211:c900:b228:34ff:1230:b60c latitude: 38.252665 longitude: -85.758456 accuracy: 43000 formatted_address: 409 South 5th Street, Louisville, KY 40202, USA street_number: 409 route: South 5th Street neighborhood: Downtown locality: Louisville administrative_area_level_2: Jefferson administrative_area_level_1: Kentucky country: United States country_code: US postal_code: 40202
Comments
Comment #1
CLEE25 commentedHmmm quick follow up, this has nothing to do with the module that I can see. If I go to what is my ip address, it is actually showing that my ip is
2307:fdc8:b5211:c900:b228:34ff:1230:b60c
I know, strange. But my guess it that I was VPNd into a server, and somehow that affected my ip?
Comment #2
CLEE25 commentedComment #3
CLEE25 commentedSo, not a fix. But my guess is that ipgv&m doesn't handle (ipv6) Ip addresses. So, I changed the schema to allow the ip address to be 64 characters instead of 32.
Again, not a fix. But at least visitors with ip addresses in ipv6 won't get an error.
Comment #4
rdeboerThanks CLEE25 for your report and fix.
I guess I should allow for the IP address field on the db to be up to 64 chars.
Rik
Comment #5
CLEE25 commentedHey Rik,
Thanks again for the awesome module. I would probably do the increase. ipv6 is going to become more and more prevalent and that error appears even if you have warnings/notices turned off on the site.
The main question is will the module still work with ipv6 addresses?
Comment #6
rdeboerIncreased ip_address length from 32 to 64 chars in ip_geoloc.install.