user warning: Duplicate entry '172-445' for key 1 query: INSERT INTO machinelearningapi_distance_cache VALUES ( 172, 445, 5.26295375824) in /var/www/acquia-drupal-1.0.0-ISR-update/sites/all/modules/memetracker/machine_learning_api.inc on line 228.
user warning: Duplicate entry '173-177' for key 1 query: INSERT INTO machinelearningapi_distance_cache VALUES ( 173, 177, 2.92246603966) in /var/www/acquia-drupal-1.0.0-ISR-update/sites/all/modules/memetracker/machine_learning_api.inc on line 228.

Comments

vinayras’s picture

vinayras commented

I am also getting this error. Can anyone point this issue?

I am using Mysql 4.x and remove the key solves the problem - but i am sure that its is wrong way todo

Thanks
Vinay

vinayras’s picture

vinayras commented

I replaced

         $prev_value = db_result(db_query("SELECT * from 
         {machinelearningapi_distance_cache} WHERE cid1 = %d AND cid2 = %d",
         $cid1, $cid2));
         
         if (!$prev_value) {
           db_query("INSERT INTO {machinelearningapi_distance_cache} VALUES (
           %d, %d, %f)", $cid1, $cid2, $score);
         }

with 

db_query("DELETE FROM {machinelearningapi_distance_cache} WHERE cid1 = $cid1 AND cid2 = $cid2");
db_query("INSERT INTO {machinelearningapi_distance_cache} VALUES (%d, %d, %f)", $cid1, $cid2, $score);

and it works for me.

Vinay