Urgent Helpt ~~ Got Error Message 1146 Everywhere ~~

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!

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

kobra:

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?? :frusty:

Do you have a prefix?

What version of ZenCart?

Do you have a DB Backup?

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.

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

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.

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.

The part starting with

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

And after are all commented so are not necessary

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.

Sorry i think i misunderstood what you tried to tell me/.
Do i copy and paste:

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;

in "install SQL patches" in zencart admin and click send? Thank you.

Hi Kobra,

I tried to excute the code in "install SQL patches" and now it showing:

1146 Table 'localhost.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]

Thank you very much for helping me out. Cheers,

kobra:

The part starting with

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

> And after are all commented so are not necessary

Hi kobra,

Just wanna let you know that the problem is now solved with your great great help. Thank you heaps heaps and heaps.. You are the nicest person in the world.. I should buy you a dinner if you are in Aus... lol... You are really a life saver..

wish you all the best...

^.^