Error after installing Advance Shipper Module

[GeckoProducts]

Hello,

I am working on my first installation of ZenCart...And as a shipping requirment installed the Advanced Shipper Mod..

Unfortunately Conor from Ceon (developer of Adv. Shipper mod) is out on personal leave for a few days, so I can not request help from him...

I used the "Install SQL Patches" utility within the ZenCart admin to run the advshipp.sql script...This installed the additional tables into the database required by Advance Shipper and apparently updated the "orders" and "orders_total" tables that are included with ZenCart...

The installation seemed to go fine...Not errors or anything...I am working on setting up my first Advance Shipper Method to see if this is going to work out...I add a few of items to my shopping cart...When I click the "Go to Checkout" button, I get the following error:
----------------------
1146 Table 'skiareas_zc1.zen_us_zipcodes' doesn't exist
in:
[ SELECT latitude, longitude FROM zen_us_zipcodes WHERE zipcode <= '49504' ORDER BY zipcode DESC LIMIT 1;]
----------------------
It appears as though this "skiareas_zc1.zen_us_zipcodes" table does not exist....I checked for this table in my database using PHPAdmin...And it infact is NOT there...Where in the heck did this table go?? Is there anyway to restore this zip code table? I have no clue yet if anything else is missing until I get further through the checkout process..

I am STUCK! Any ideas? Thanks for the help.

Mike

[pickupman]

Mike,
This will get past the error, but I don't what the table data should be.

CREATE TABLE IF NOT EXISTS `zen_us_zipcodes` (
  `us_zip_codes_id` int(11) NOT NULL AUTO_INCREMENT,
  `latitude` varchar(20) NOT NULL DEFAULT '',
  `longitude` varchar(20) NOT NULL DEFAULT '',
  `zipcode` char(9) NOT NULL DEFAULT '',
  PRIMARY KEY (`us_zip_codes_id`)  
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=0 ;

[GeckoProducts]

Thanks a bunch!

I ran the script and it created the table...but now it is an empty table as you mentioned...

I am still getting this:
-------------
1146 Table 'skiareas_zc1.zen_us_zipcodes' doesn't exist
in:
[ SELECT latitude, longitude FROM zen_us_zipcodes WHERE zipcode <= '49504' ORDER BY zipcode DESC LIMIT 1;]
-------------
Is there any way someone can just export the table and send it to me? Then I import into my database/table?

Thanks....
Mike

[torvista]

Hi,
I have Advanced Shipper.

1) I have never had a problem with it.
2) There is no table mentioned in the installation sql file that has the word zipcodes in it.
3) I have no table with the word zipcodes in my database either.

So, I'm sorry but I don't think Advanced Shipper has anything to do with this, you should look at your other mods. Maybe another install script has previously failed.

I keep backups of all the downloaded mods I have installed in a reference directory. When I get a problem like this that no-one else seems to have experienced I search it using Windows GREP to hopefully find some link to the offending text/error message.

Good Luck,

Steve

[torvista]

DOH!!

I did this:

..I search it using Windows GREP to hopefully find some link..

and what did I find in the Advanced Shipper installation files but a \geolocation_db_tables directory with an sql file to create the table you are missing.
No doubt there is info in the readme about using it,

regards
Steve

[pickupman]

Mike,
Try going to Admin->Tools->Store Manager, scroll to the bottom and click on Optimize database button. It looks like zencart saves a hash of the db tables. I checked on mine, and clicking optimize cleared the field. When I reloaded the front end, the database table was filled with a new hash.

[mkalavitz]

Thanks Guys!

I think I am operational again!

I didn't realize that there was a us_zipcodes file in the Advance Shipper file folders...I did not find any readme on it anywhere.

So, I took the file and updated the script to create a new database with a different file name with a prefix...All of my databases for ZenCart are prefixed with zen_ So, I modified script to include zen_us_zipcodes Then I executed the file using phpMyadmin.....The response was that it executed OK.

I then went back to my store and the check out process went fine! I think that did it...I hope..

Now, I am going to mess with these shipping modules to see if I can get my shipping requirements under control.

Pickupman....I am going to try to install that script in a little while and see how it goes...I will give you some feed back!

Thanks to Pickupman and Torvista! I appreciate your help!

Regards,
Mike