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

Leave a Reply

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