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

CommentFileSizeAuthor
patch.txt964 bytesfortytwo

Comments

davyvdb’s picture

Status: Active » Fixed

Status: Fixed » Closed (fixed)

Automatically closed -- issue fixed for 2 weeks with no activity.