Im having major problems with my shopping cart. Quite alot of work has gone into it in the last few months, I was supposed to launch tomorrow and now that doesnt look like happening. I tried installing a shipping module and I guess I messed everything up.


This is the message that appears everytime I load my page now.

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


Some important (or maybe not important) details

- I did not install zen cart myself. I installed it through fantastico in my CP, and have extremly little understanding on databases

- Following advice on prior posts on this topic i Checked the configure.php files for prefix.. its zen_

- I am using version 1.3.7



- I had this error whilst trying to upload the Australia Post module v1.0.2. I didnt read through the readme properly and didnt do the script changes in regards to the prefix. I have since made the necessay changes and uploaded the sql file again with no such luck. Everytime I upload it again I now get this message



1067 Invalid default value for 'date_added'
in:
[CREATE TABLE zen_zen_geo_zones ( geo_zone_id int(11) NOT NULL auto_increment, geo_zone_name varchar(32) NOT NULL default '', geo_zone_description varchar(255) NOT NULL default '', last_modified datetime default NULL, date_added datetime NOT NULL default '', PRIMARY KEY (geo_zone_id) ) TYPE=MyISAM;]
If you were entering information, press the BACK button in your browser and re-check the information you had entered to be sure you left no blank fields.







Any help will be greatly appreciated as Im stuck in limbo until I can fix this and I really cannot start again from scratch





thanks in advance