Have tried everything .. cutting and pasting into a query ... importing ... 3 different techs for support ... and no luck

anyone run into this? cannot get this to work without the zip search ... love to see it work

thanks

CommentFileSizeAuthor
#8 zipcodes.us_.mysql_.gz684.2 KBjimwebb-1
#3 screenshot-zipcode.jpg566.93 KBthriftyngreen

Comments

NewZeal’s picture

NewZeal commented

Check that the zipcodes table does not have a field called listings. If it does then delete it. This was present in much earlier versions of the listing_location module and has since been removed.

thriftyngreen’s picture

thriftyngreen commented

Thanks a lot been trying for hours ... :) really do not want to give up! Thanks!!! will try!

thriftyngreen’s picture

thriftyngreen commented
StatusFileSize
new screenshot-zipcode.jpg566.93 KB

It did not have that. I did now delete the original index named zip as after importing I got one named zip_2 so I figured give deleting that one a whirl to see if it worked. Nothing. I attached a screenshot. I would appreciate any guidance. I might consider paying someone an hour to break through this but like to be able to do it myself.

NewZeal’s picture

NewZeal commented

Yeah this really has nothing to do with the listing module and is part of installing the location module to work using location_search. If you get stuck I work as a contractor.

thriftyngreen’s picture

thriftyngreen commented

Yea I hear you I figured I would try both and see who answered :) I may need to hire you to set this up. I have it all ready to go just that barrier. Let me know how much we don't have a lot but would really like to get this going. http://thriftyandgreen.com email me if you would like cmcgrath@thriftyandgreen.com

NewZeal’s picture

NewZeal commented
Status: Active » Fixed

This was a location module issue.

Status: Fixed » Closed (fixed)

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

jimwebb-1’s picture

jimwebb-1 commented
StatusFileSize
new zipcodes.us_.mysql_.gz684.2 KB

I had a similar problem -- couldn't get the US zipcodes data set to import via PhpMyAdmin due to timeout issues. I finally got the file to import, then created a new export for all of you fine folks having the same problem. This .gz file is it — if you couldn't import the one that came with location, give this guy a try.

thriftyngreen’s picture

thriftyngreen commented

This is exciting however I think there are some deeper issues still being worked on with this module fyi I am told by May should be worked out

ddbell’s picture

ddbell commented

Jim, Thanks. Can you provide me a step by step on how to use your file with PhpMyAdmin. If PhpMyAdmin does not work please provide me a step by step that will. I am new to database import and exports using Drupal.

Thanks.

missym’s picture

missym commented

Jim - you rock. This worked like a charm: zipcodes.us_.mysql_.gz

SimpleAsCouldBe’s picture

SimpleAsCouldBe commented

I'm having the timeout issue too, but a warning to others--be careful with Jim's file. It's 2,349 records short of the file originally included in location 6.x-3.1. Not sure why, but it makes me avoid it.

Splitting the file into chunks works fine, although it's a PITA.