It adds the field 'uid' to existing table, but does not fill in the values from real nodes, so all usernames in the views get '(not verified)' message. This does the trick:

db_query('UPDATE {node_comments} c SET uid = (SELECT uid FROM {node} n WHERE n.nid = c.cid)');

(if this uid field is really needed at all).

Comments

quicksketch’s picture

Status: Needs review » Closed (duplicate)