Closed (fixed)
Project:
Location Feeds
Version:
7.x-1.4
Component:
Code
Priority:
Normal
Category:
Bug report
Assigned:
Reporter:
Created:
17 Nov 2011 at 16:54 UTC
Updated:
31 Dec 2012 at 01:05 UTC
I'm running a regular feeds import from a SOAP service, with some of the fields being long/lat fields.
I've mapped this correctly to the appropriate Location fields in Drupal, and for the majority of the nodes this works fine, however for some nodes I'm getting the error:
SQLSTATE[HY000]: General error: 1366 Incorrect integer value: '' for column 'field_location_lid' at row 1
Some of the nodes don't have a long/lat set, but for these, the value is either 0,0 or null, so the location field should not even be trying to save a location.
I've had a look through the location feeds code, but can't work it out.
Anyone else come across this issue before?
Thanks,
Edwin
Comments
Comment #1
mcdoolz commentedI'm experiencing the same.
SQLSTATE[HY000]: General error: 1366 Incorrect integer value: '' for column 'field_address_lid' at row 1Comment #2
ymeiner commentedIt is a problem when there is no location at all. I am trying to find a solution for it to. meanwhile i just entered a zip code that i know that is not in use
Comment #3
jeffschulerI was experiencing this, too... Removed and re-added my location mappings and it worked.
Comment #4
killtheliterate commentedAlso experiencing this problem. Encouraging to know that I'm not alone, at least.
Comment #5
killtheliterate commentedI've tried again and again to circumvent this error. It would seem that locations feeds imports fine, until I'm importing to more than 4 location fields. I've tried removing the mappings, using different test fields, etc... Once I've mapped 5 location fields in my importer, I begin to see this error.
---
Edit:
It seems like this is actually occuring if a location field is empty... So, is it requisite that a, say, csv, when importing into locations, must have all fields filled in?
Comment #6
killtheliterate commentedHere's my feed log. Obviously, the majority of my fields are specific to my use case, but you'll notice that Feeds doesn't get upset until it reaches an empty field that I've mapped to a location cck field. Below the feeds log error is the pdo exception that's in dblog.
dblog
Comment #7
digitalfrontiersmediaYou should also check your data to make sure there aren't illegal characters etc. in the data messing up the import. This was the cause of my errors of the type above.
Comment #8
killtheliterate commentedI've tried many different ways of making sure everything is uft-8. Would it be helpful for me to upload a sample csv and module of the feed importer?
Comment #9
elliotttf commentedI'm able to reproduce the problem locally, working on a fix now.
Comment #10
elliotttf commentedA fix has been deployed in 7.x-1.6. I don't know if this also affects the D6 version but I haven't made the change there. Thanks killtheliterate for the debug output!
Comment #12
geefin commentedI still had this occurring with 7.x-1.6.
'Fixed it' by adding a default country and a province of 'NULL' in the incoming feed.
Comment #13
mikel1 commentedI'm having this problem with 7.x-1.6 as well. I have a default country in the content type. I am only setting latitude and longitude in my feed though. When they are not present or are 0 I get the error described at the beginning of this thread. Will open a new ticket against 7.x-1.6