Question:
I am unable to approve links with ' in the title or description

Answer:
This is a problem with the wrong function being called. It was fixed in all version after 1.1.0 so either upgrade or open includes/functions_submissions.php and find:

// site has been accepted
$sql = "INSERT INTO " . $dbprefix . "links (topicid, postdate, website, description, url) VALUES (";
$sql .= dbSecure($rec->fields["topicid"]) . ", ";
$sql .= time() . ", ";
$sql .= "'" . dbSecure($rec->fields["website"]) . "', ";
$sql .= "'" . dbSecure($rec->fields["description"]) . "', ";
$sql .= "'" . dbSecure($rec->fields["url"]) . "')";
$db->execute($sql);

Replace with:

// site has been accepted
$sql = "INSERT INTO " . $dbprefix . "links (topicid, postdate, website, description, url) VALUES (";
$sql .= addslashes($rec->fields["topicid"]) . ", ";
$sql .= time() . ", ";
$sql .= "'" . addslashes($rec->fields["website"]) . "', ";
$sql .= "'" . addslashes($rec->fields["description"]) . "', ";
$sql .= "'" . addslashes($rec->fields["url"]) . "')";
$db->execute($sql);

Software:
Particle Links

Versions:
1.1.0