Documentation states:
Note: If your site is using table prefixes, you will need to adjust for this
manually, by opening the file in a text editor and replacing 'zipcodes' with
'prefix_zipcodes' throughout.

Which file specifically needs to have the prefix added? or all files?

Comments

dsellers154’s picture

dsellers154 commented

I am still trying to figure out where this script is hitting the zipcode database. I am sure I have looking at it at least 10times and just missed it. can anyone help me out on this?

TS79’s picture

TS79 commented

...

ankur’s picture

ankur commented
Status: Active » Closed (fixed)

The zipcodes.xx.sql files contain a bunch of SQL insert statements for the zipcodes table, for the country w/ ISO code 'xx' (switch this out with 'us' for the United States, 'ca' for Canada, etc).

If you're using a prefix for your database table names, you'll want to change these files to adjust all mentions of the "zipcodes" table "prefix_zipcodes", where "prefix_" is the table prefix you are using for your database.