signup Posted March 24, 2007 Share Posted March 24, 2007 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 More sharing options...
♥Vger Posted March 24, 2007 Share Posted March 24, 2007 It means that the table does not exist in your database. Check it via phpMyAdmin. Vger Link to comment Share on other sites More sharing options...
chooch Posted March 25, 2007 Share Posted March 25, 2007 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 More sharing options...
signup Posted May 4, 2007 Author Share Posted May 4, 2007 thanks you for your reply Link to comment Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.