Woo Themes and Affiliate Link Structure

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.