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

CLEE25’s picture

Hmmm 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?

CLEE25’s picture

Issue summary: View changes
CLEE25’s picture

So, 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.

rdeboer’s picture

Thanks 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

CLEE25’s picture

Hey 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?

rdeboer’s picture

Assigned: Unassigned » rdeboer
Status: Active » Fixed

Increased ip_address length from 32 to 64 chars in ip_geoloc.install.

Status: Fixed » Closed (fixed)

Automatically closed - issue fixed for 2 weeks with no activity.