Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

help me "Table '...' doesn't exist"


signup

Recommended Posts

1146 - Table 'sonpn_quytan.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 = '18') and tr.tax_class_id = '0' group by tr.tax_priority

 

[TEP STOP]

 

 

What is it bug??? sombody helpme?

Link to comment
Share on other sites

1146 - Table 'sonpn_quytan.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 = '18') and tr.tax_class_id = '0' group by tr.tax_priority

 

[TEP STOP]

 

 

What is it bug??? sombody helpme?

Did you insert the SQL via phpmyadmin in to the database? Looks like you forgot to do it!

Upon receiving fixes and advice, too many people don't bother to post updates informing the forum of how it went. Until of course they need help again on other issues and they come running back!

 

Why receive the information you require in good faith for free, only to then have the attitude to ignore the people who gave it to you?

 

There's no harm in saying, 'Thanks, it worked'. On the contrary, it creates a better atmosphere.

 

CHOOCH

Link to comment
Share on other sites

  • 1 month later...

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...