Duplicate Entry Error

nothing bad happens, just annoying

this should prevent the errors

Also experimenting with bypassing php for this

INSERT INTO boost_crawler (url, hash) 

SELECT 
  CONCAT('http://www.example.com/', ua.dst) AS url,
  MD5(CONCAT('http://www.example.com/', ua.dst)) AS hash
FROM url_alias AS ua 
LEFT JOIN node AS n ON n.nid = CAST(substring(ua.src, 6) AS UNSIGNED) 
WHERE (n.status = 1 OR n.status IS NULL)

committed