Fixing "Title mismatch. Please check your selection" after manually changing node titles

Breaking this off from http://drupal.org/node/290259#comment-974065 to make it easier to find.

I was getting the error message "Title mismatch. Please check your selection" on a site with a lot of node references. I had manually updated the node_revisions.title field via an sql query. But I forgot to update the node.title field which is what caused the problem. There are two possible queries to fix this.

If you are like me and the right value is contained in the node_revisions table, use this query:

UPDATE node n
INNER JOIN node_revisions nr
ON n.vid = nr.vid
SET n.title = nr.title
WHERE n.title <> nr.title;

If you have the "right" value in your node table and need to move it to the node_revisions use this query:

UPDATE node_revisions nr
INNER JOIN node n
ON n.vid = nr.vid
SET nr.title = n.title
WHERE n.title <> nr.title;

I mark this as a fixed support request just so it can live on for documentation purposes. It's also possible that something could be tweaked in cck to help fix this situation automagically but I don't think that's necessary/valuable.