node not deleted from subscription_node on delete

If I delete a node that was pushed to my site, the nid is not being removed from the subscription_node table. This is because the sid is not being set in the subscribe_node_load so it is not available in the delete case of subscribe_nodeapi.

To fix this, all you need to add "sn.sid, " in the SELECT clause in the subscribe_node_load fuction, namely:

  return db_fetch_object(db_query('SELECT sn.remote_nid, sn.remote_uid, sn.remote_author, sn.sid, ss.base_url as remote_site_url, ss.name as remote_site FROM {subscribe_node} sn INNER JOIN {subscribe_subscriptions} ss ON ss.sid = sn.sid WHERE sn.nid = %d', $nid));

I hope this helps.