Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

GothicBeast

Members
  • Posts

    9
  • Joined

  • Last visited

Posts posted by GothicBeast

  1. Ok,

     

    This shipping module stopped working for FedEx today (at least that is what I discovered).

     

    I turned on debug mode and sending all the correct data. Maybe FedEx server is down, but my guess is they have changed their formatting.

     

    Am I the only one with this problem?

     

    Any idea what "data" change has happened, and needs to be adjusted?

  2. I just added Supertracker to my site.

     

    The instructions did not include:

    - ALTER TABLE `supertracker` ADD `agent` VARCHAR(255) NULL;

     

    It would probably help some people to have this call added to the supertracker_setup_db.php the call to add the agent to the supertracker table.

     

    if (tep_db_num_rows($check_result) < 1){

    //First time user, so just install the new database schema

    $insert_query = "CREATE TABLE `supertracker` (

    `tracking_id` bigint(20) NOT NULL auto_increment,

    `ip_address` varchar(15) NOT NULL default '',

    `browser_string` varchar(255) NOT NULL default '',

    `country_code` char(2) NOT NULL default '',

    `country_name` varchar(100) NOT NULL default '',

    `customer_id` int(11) NOT NULL default '0',

    `order_id` int(11) NOT NULL default '0',

    `referrer` varchar(255) NOT NULL default '',

    `referrer_query_string` varchar(255) NOT NULL default '',

    `landing_page` varchar(255) NOT NULL default '',

    `exit_page` varchar(100) NOT NULL default '',

    `time_arrived` datetime NOT NULL default '0000-00-00 00:00:00',

    `last_click` datetime NOT NULL default '0000-00-00 00:00:00',

    `num_clicks` int(11) NOT NULL default '1',

    `added_cart` varchar(5) NOT NULL default 'false',

    `completed_purchase` varchar(5) NOT NULL default 'false',

    `categories_viewed` varchar(255) NOT NULL default '',

    `products_viewed` varchar(255) NOT NULL default '',

    `cart_contents` mediumtext NOT NULL,

    `cart_total` int(11) NOT NULL default '0',

    `agent` varcgar(255) NOT NULL default '',

    PRIMARY KEY (`tracking_id`)

    ) TYPE=MyISAM AUTO_INCREMENT=1 ;";

    @$insert_result = tep_db_query($insert_query);

    if ($insert_result) echo 'New Supertracker Database Table Successfully Created';

    else echo 'There was a problem in trying to create the database. You may need to do this manually using the following SQL code: <br>' . $insert_query;

     

    Just a suggestion... help some of the people from having a problem :)

  3. I have installed this mod, but I get a strange error.

     

    I have a 1lb item in the shopping cart, but the info returned by the FEDEX shows the weight at 4lb?

     

    I don't know where the 3 extra pounds is showing up???

     

    ------------------------------------

     

    Ignore the above comment, I found out that it was related to a minimum weight setting :(

×
×
  • Create New...