New Zenner
- Join Date:
- Feb 2009
- Posts:
- 3
- Plugin Contributions:
- 0
Austpost module v 3.02
i have installed this module and have the following problems.
when i i go to install sql patches. i get this message when i press upload
1067 Invalid default value for 'date_added'
in:
[CREATE TABLE 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.
then when i go to one of my products i get this
1146 Table 'choralwo_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 = '186') and tr.tax_class_id = '1' group by tr.tax_priority]
what have i done. Desperate as this site is supposed to launch on 1st march 09 . can someone help or private message me if you feel you can login and fix
