Weird Problem!

[Ewokmeat]

I just recently set up a new product under my AABox MS2-Max and set up all the information under Admin to the best of my knowledge. Right after that I get this error when trying to access www.mypage.com/catalog on the left side of the screen!

1146 - Table 'catalog.zones_to_geo_zones' doesn't exist

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 = '223') and (za.zone_id is null or za.zone_id = '0' or za.zone_id = '31') and tr.tax_class_id = '0' group by tr.tax_priority

I have tried to look at some of the past posts on a few forms and some suggest that it might be something to do with the modules/shipping section under admin. I'm not sure does any one else also have this problem?

Thanks for your valuable help!

[michael_s]

Ewokmeat,

That error means a table is missing from your DB. I have taken the liberty to add it to your database for you.

The has resolved the problem.

[Ewokmeat]

I can't stress enough on how much I appreciate all the great work and service your company provides. I'm going to transfer another site to your server soon as soon as I have a little talk with one of my other business partners! I think I'm also going to transfer my computer business' website to your server once I get a little comfortable with oscommerce!

Thanks again

[phillbro]

Hi,

I have the same problem as Ewokmeat.

Could you either insert the missing table, or let me know how to go about inserting the table?

Thanks in advance.

Phillbro

[phillbro]

Please disregard my previous post. I turned my brain back on and figured out how to create the missing table.