osCmax v2.5 User Manual
Results 1 to 2 of 2

Error with DHL mod

This is a discussion on Error with DHL mod within the osCommerce 2.2 Modification Help forums, part of the osCommerce 2.2 Forums category; HI, I just recently installed the DHL mod "Airborne Express Quotes using ShipIT XML API". When I activate it through ...

      
  1. #1
    Lurker
    Join Date
    Jan 2008
    Posts
    4
    Rep Power
    0


    Question Error with DHL mod

    HI,
    I just recently installed the DHL mod "Airborne Express Quotes using ShipIT XML API". When I activate it through the admin side the checkout_shipping.php brakes and through the error:

    2006 - MySQL server has gone away
    select startdate, counter from counter
    [TEP STOP]
    2006 - MySQL server has gone away
    select count(*) as total from sessions where sesskey='a78ca29074150b4c9ab706c5dd4f1451'
    [TEP STOP]


    A quick look at the MySQL logs shows that the MySQL server has not gone down. It seem to have timed out.

    When I turn on debug print to screen in the DHL mod and reload the page it shows the xml request and a successful xml response with the same error messages following.

    Has anyone experienced this problem?

    Many thanks,
    ~trifid

  2. #2
    Lurker
    Join Date
    Jan 2008
    Posts
    4
    Rep Power
    0


    Post Re: Error with DHL mod

    Results of more diagnostic work on this problem.

    The first part of the error:
    2006 - MySQL server has gone away
    select startdate, counter from counter
    [TEP STOP]


    The select statement referenced in this error is from line 13 of /includes/counter.php

    The second part of the error:
    2006 - MySQL server has gone away
    select count(*) as total from sessions where sesskey='...
    [TEP STOP]

    The select statement in this error message comes from line 51 in checkout_shipping.php. This is the part of the code that verifies selected address.

    Measuring the response time of the page with DHL turned off with DHL turned on reveals response times that are much shorter than the time out default set for my MySQL server. This suggests that the error is not a timing out error.

    !!! Important
    A quick look at the store database I found the table "counter" referenced by the select statement in "counter.php". It does not have a primary key and the only data in it was dated well before the date I installed it. So no data has been written to this table.

    Could someone check their database I find out if there is a primary key for the table "counter".
    I suspect that not having a key makes this table inaccessible causing the store system to thrashing out the error.
    ~trifid


    Last edited by trifid; 02-29-2008 at 04:58 AM.

Similar Threads

  1. DHL Luftpost
    By michael_s in forum New osCommerce Contributions
    Replies: 0
    Last Post: 07-31-2007, 07:01 AM
  2. Deutsche Post / DHL
    By michael_s in forum New osCommerce Contributions
    Replies: 0
    Last Post: 07-31-2007, 07:01 AM
  3. DHL Luftpost
    By michael_s in forum New osCommerce Contributions
    Replies: 0
    Last Post: 07-31-2007, 05:13 AM
  4. check/money order payment mod error!
    By xzyyy in forum osCmax v2 Customization/Mods
    Replies: 3
    Last Post: 10-17-2006, 07:02 PM
  5. points and rewards mod error
    By Christy in forum osCmax v2 Customization/Mods
    Replies: 0
    Last Post: 10-02-2005, 07:14 AM

Bookmarks

Posting Permissions

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