Results 1 to 10 of 10

Threaded View

  1. #1
    Join Date
    Sep 2006
    Location
    Australia
    Posts
    80
    Plugin Contributions
    0

    Default Auspost Install Error

    When installing the auspost module I get this message after clicking on upload in Admin/Tools/Install SQL patches

    #
    # Table structure for table `geo_zones`
    #

    DROP TABLE IF EXISTS geo_zones;
    CREATE TABLE 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;

    1067 Invalid default value for 'date_added'
    in:
    [CREATE TABLE 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.

    What does this mean?

    Thanks
    Katie
    Last edited by lucky__starre; 25 Sep 2006 at 03:52 AM.

 

 

Similar Threads

  1. Auspost Shipping Module with new AusPost API
    By Whiterabbizt in forum All Other Contributions/Addons
    Replies: 3
    Last Post: 30 Apr 2012, 10:23 AM
  2. failed install of Auspost module - now a geo table error
    By bacc in forum Installing on a Windows Server
    Replies: 1
    Last Post: 26 Dec 2008, 02:00 AM
  3. AusPost Error
    By lucky__starre in forum Addon Shipping Modules
    Replies: 1
    Last Post: 9 Aug 2007, 02:26 AM
  4. Problem when install Auspost Module
    By als88 in forum Built-in Shipping and Payment Modules
    Replies: 2
    Last Post: 15 Jul 2007, 02:00 AM
  5. AUSPOST Error
    By ALFO in forum Addon Shipping Modules
    Replies: 6
    Last Post: 8 Oct 2006, 01:42 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
disjunctive-egg