[John Conners]

Remove the brackets – this is what you want to execute:

UPDATE bb_topicmeta SET

meta_value='http://www.portcityunderground.com/bbpress/'

WHERE meta_key='uri' LIMIT 1