service_links always tries to create a duplicate entry in service_attachments_info, because of the following line of code in
service_attachments.sync.inc
$sql = "UPDATE {service_attachments_info} SET changed = %d, query = '%s' WHERE nid = %d AND service = '%s'";
db_query($sql, $_SERVER['REQUEST_TIME'], 1, $candidate, $nid, $service);
this update always fails because of wrong parameter so it tries to create a new entry in the following lines
if (!db_affected_rows()) {
$sql = "INSERT INTO {service_attachments_info} (nid, service, created, changed, query) VALUES (%d, '%s', %d, %d, '%s')";
db_query($sql, $nid, $service, $_SERVER['REQUEST_TIME'], $_SERVER['REQUEST_TIME'], $candidate);
}
which leads to a mysql error.
attached patch solves that problem
Comments
Comment #1
davyvdb commented