By PeterLucas on

I have trouble installing the zipcodes table from the Locations module.

I found some clues that zipcodes.mysql has issues.

Have they been fixed by now?
Which zipcodes.mysql file should I run on my database?

The 3.73 Mb zipcodes.us.mysql file just keeps timing out (or nothing happens). Is that because PhpMyAdmin can't handle it or is the file itself the problem?

Comments

PeterLucas’s picture

PeterLucas commented

zipcodes.mysql works, but with this error in the database:

Warning PRIMARY and INDEX keys should not both be set for column `country`
Warning More than one INDEX key was created for column `country`

zipcodes.us.mysql times out/does nothing.

Any suggestions?

SheilaRuth’s picture

SheilaRuth commented

I just downloaded the location module today, and I'm having a different but similar problem when trying to load zipcodes.mysql. I get the error:

ERROR 1171 at line 29: All parts of a PRIMARY KEY must be NOT NULL; If you need NULL in a key, use UNIQUE instead

Line 29 seems to be this one:
ALTER TABLE zipcodes ADD PRIMARY KEY (country, zip);

Thanks.