Urgent Helpt ~~ Got Error Message 1146 Everywhere ~~

[Gene_Gene]

My story is that I found my site went into blank page when going to the "go to checkout" step yesterday and I found there was something wrong with the shipping module which is the Aust Post shipping module. So, I turned a few options in shipping off and I could access to the checkout page again.

Then, I tried to re-install the Aust Post shipping module and ended up with the following error --

1146 Table 'localhost.zones_to_geo_zones' doesn't exist
in:
[select sum(tax_rate) as tax_rate from (tax_rates tr left join zones_to_geo_zones za on (tr.tax_zone_id = za.geo_zone_id) left join geo_zones tz on (tz.geo_zone_id = tr.tax_zone_id) ) where (za.zone_country_id is null or za.zone_country_id = 0 or za.zone_country_id = '13') and (za.zone_id is null or za.zone_id = 0 or za.zone_id = '188') and tr.tax_class_id = '0' group by tr.tax_priority]

My site is -- www. c u t i e l i t t l e m o u s e. c o m.au

You can see the error message is down at the bottom on the main page and every page which with products displaying previously.

Is anyone able to give me some lights of how to fix this? Thank you very much for your great great great help in advance. Much appreciated!

[kobra]

1146 Table 'localhost.zones_to_geo_zones' doesn't exist

Think that says it...

Check your DB with phpmyadmin....
If there was sql with that add on it most likely stated the table as
"zones_to_geo_zones" and you might have a prefix for your tables
Like "zen_zones_to_geo_zones" or something else

[Gene_Gene]

Think that says it...

Check your DB with phpmyadmin....
If there was sql with that add on it most likely stated the table as
"zones_to_geo_zones" and you might have a prefix for your tables
Like "zen_zones_to_geo_zones" or something else

Hello there,

Thank you very much for your prompt reply. I tried to look into the phpmyadmin...and cant find anything like "zones_to_geo_zones"..what should i do now??

[kobra]

Do you have a prefix?

What version of ZenCart?

Do you have a DB Backup?

[Gene_Gene]

No i don't have a prefix.
I am using version 1.3.8.
I have a back up, but it's been a while ago when i had that. If I restore the backup file. will it wipe out all my recent records? Like my recent orders, new customer, new products etc? Thank you.

[kobra]

I have a back up, but it's been a while ago when i had that. If I restore the backup file. will it wipe out all my recent records? Like my recent orders, new customer, new products etc?

Yes - - DO NOT restore the full backup

If compressed, expand it locally and find the entries ONLY for the zones_to_geo_zones table and copy & paste it into the sql area in phpmyadmin

Check that you now have that table

[Gene_Gene]

Thank you so much for your reply.
I found the backup file and expanded it and try to search the entire folder for "zones_to_geo_zones" and get the result of no match found.
I can find 2 php files under the name of "geo_zones" in the location of "admin/geo_zones" and "admin/includes/languages/english/geo_zones".
Am i searching it the wrong way? Could you please tell me a little bit regarding how can i search the entries ONLY for the zones_to_geo_zones table? Thank you heaps.

[Gene_Gene]

When i open the expanded folder there is a file named "localhost". I opened with with notepad and found the last bit is:

-- Table structure for table `zones_to_geo_zones`
--

DROP TABLE IF EXISTS `zones_to_geo_zones`;
CREATE TABLE `zones_to_geo_zones` (
`association_id` int(11) NOT NULL auto_increment,
`zone_country_id` int(11) NOT NULL default '0',
`zone_id` int(11) default NULL,
`geo_zone_id` int(11) default NULL,
`last_modified` datetime default NULL,
`date_added` datetime NOT NULL default '0001-01-01 00:00:00',
PRIMARY KEY (`association_id`),
KEY `idx_zones_zen` (`geo_zone_id`,`zone_country_id`,`zone_id`)
) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `zones_to_geo_zones`
--

LOCK TABLES `zones_to_geo_zones` WRITE;
/*!40000 ALTER TABLE `zones_to_geo_zones` DISABLE KEYS */;
INSERT INTO `zones_to_geo_zones` VALUES (1,223,18,1,NULL,'2008-09-13 21:52:17');
/*!40000 ALTER TABLE `zones_to_geo_zones` ENABLE KEYS */;
UNLOCK TABLES;

/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;


Is that what i need to copy and paste in "install SQL patches" in zencart admin? Thanks.

[kobra]

The part starting with

/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;

And after are all commented so are not necessary

[Gene_Gene]

Thank you so much for your prompt reply.
So do i just copy and paste:

/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;


in "install SQL patches" in zencart admin and click send? Thank you.
Just want to make sure that i don't make any mistake anymore. Thanks again.