Woo Themes and Affiliate Link Structure

Recently received an error from Woo. It’s below, and it has some unique insights to how the database and affiliate tracking is done.

Database Error

Database Error

A database error occurred while performing the requested procedure. Please review the database error below for more information.

system/libraries/drivers/Database/Mysql.php [371]:

There was an SQL error: Duplicate entry '9802422' for key 1 - INSERT INTO `wm_affclick` (`aff_id`, `url`, `remote_addr`, `referrer`, `woo_product`, `is_unique`) VALUES ('123456', 'http://www.woothemes.com/extension/google-product-feed/', '123.45.67.89', NULL, '', 0)

Stack Trace

  • system/libraries/drivers/Database/Mysql.php [99]:
    Mysql_Result->__construct(  )
  • system/libraries/Database.php [259]:
    Database_Mysql_Driver->query( INSERT INTO `wm_affclick` (`aff_id`, `url`, `remote_addr`, `referrer`, `woo_product`, `is_unique`) VALUES ('123456', 'http://www.woothemes.com/extension/google-product-feed/', '123.45.67.89', NULL, '', 0) )
  • system/libraries/Database.php [962]:
    Database_Core->query( INSERT INTO `wm_affclick` (`aff_id`, `url`, `remote_addr`, `referrer`, `woo_product`, `is_unique`) VALUES ('123456', 'http://www.woothemes.com/extension/google-product-feed/', '123.45.67.89', NULL, '', 0) )
  • application/models/affiliatestats.php [138]:
    Database_Core->insert( wm_affclick, Array
    (
        [aff_id] => 123456
        [url] => http://www.woothemes.com/extension/google-product-feed/
        [remote_addr] => 123.45.67.89
        [referrer] => 
        [woo_product] => 
        [is_unique] => 0
    )
     )
  • application/helpers/log.php [95]:
    AffiliateStats_Model->create( Array
    (
        [aff_id] => 123456
        [url] => http://www.woothemes.com/extension/google-product-feed/
        [remote_addr] => 123.45.67.89
        [referrer] => 
        [woo_product] => 
        [is_unique] => 0
    )
     )
  • application/controllers/go.php [124]:
    log_Core->add_affclick( 123456, http://www.woothemes.com/extension/google-product-feed/ )
  • Go_Controller->index(  )
  • system/core/Kohana.php [291]:
    ReflectionMethod->invokeArgs( Go_Controller Object
    (
        [uri] => URI Object
            (
            )
    
        [input] => Input Object
            (
                [use_xss_clean:protected] => 1
                [magic_quotes_gpc:protected] => 1
                [ip_address] => 
            )
    
        [session] => Session Object
            (
                [input:protected] => Input Object
                    (
                        [use_xss_clean:protected] => 1
                        [magic_quotes_gpc:protected] => 1
                        [ip_address] => 
                    )
    
            )
    
    )
     )
  • Kohana::instance(  )
  • system/core/Event.php [209]:
    call_user_func( Array
    (
        [0] => Kohana
        [1] => instance
    )
     )
  • system/core/Bootstrap.php [55]:
    Event::run( system.execute )
  • index.php [106]:
    require( system/core/Bootstrap.php )

Loaded in 0.0088 seconds, using 1.13MB of memory. Generated by Kohana v2.3.4.

Related Posts:

  • No Related Posts
This entry was posted in Server Admin, Web Development and tagged , , , . Bookmark the permalink.

One Response to Woo Themes and Affiliate Link Structure

  1. book the help says:

    The first time in a while that I searched Google for a question and got an interesting answer. Thankyou!

Leave a Reply

Your email address will not be published. Required fields are marked *