Help! 1146 Table doesn't exist?

[sberriemb]

I was trying to install the Aust Post shipping module and ended up with the following error:

1146 Table 'juniorgym1.zen_geo_zones' doesn't exist
in:
[select sum(tax_rate) as tax_rate from (zen_tax_rates tr left join zen_zones_to_geo_zones za on (tr.tax_zone_id = za.geo_zone_id) left join zen_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 = '183') and tr.tax_class_id = '1' group by tr.tax_priority]


The website is at http://www.juniorgym.com.au/zen-cart/ and you can see down the bottom of the main page the error code. This shows anywhere that the products were previously displaying.

So not only can I not see any of my products on my page but I can no longer edit the tax codes. I really don't know what to do some I'm hoping someone out there can shed some light? I've spent hours trying to work it out but its just beyond me -_-'

[sberriemb]

Also for reference I'm running Zen-Cart v1.3.7 and was trying to install Australian Post Module3.02

[DrByte]

When you installed Zen Cart, did you select "zen_" for a database table-prefix? Or did you leave it blank (which was the default)?
You can check this by looking for the setting for DB_PREFIX in your /includes/configure.php file.

The database query that you quoted is looking for tables that start with "zen_" but the database is saying it cannot find tables with that name.

If your DB_PREFIX is blank (ie: an empty setting such as: '' ) then if the auspost module is looking for zen_ tables, it's got them hard-coded, which would be somewhat sloppy coding. You'd need to go through that module and fix all the table-names so they use the correct prefix (in your case likely blank).
The proper way in Zen Cart to reference a table name is to use the predefined constants such as TABLE_GEO_ZONES, which have both the prefix and the tablename built in to them.

That's likely a lot more tech talk than you were expecting, but will hopefully give you an idea where to fix your problem.

[sberriemb]

Thanks for all the technical talk DrByte it helps me to understand things a bit better but unfortunately thats not the problem, I have it setup so the prefix is 'zen_'

[DrByte]

In phpMyAdmin, when you look at the list of tables in your juniorgym1 database ... do you have a zen_geo_zones table ?

If not, do you have a backup from before installing the mod you mentioned?

[RodG]

Hi sberriemb,
I've no idea what you need to do to fix your problem (I reckon restoring from a backup may be the quickest/easiest thing to do). However, when you do get your system working again you might want to try using the 'austpost improved' module instead. It doesn't use geo_zones.
Please don't try installing the 'improved' module until you fix the current problem, otherwise you'll just make things worse.

Cheers
Rod