Our forum upgrade put the wrong name in the username of the new forum and its causing problems! We have a site we were supposed to launch last night and are quite desperate to fix this so we can launch (the site has been down for 3 days).
So we need to search for a match between [url removed, login to view] with [url removed, login to view] and replace [url removed, login to view] with the corresponding [url removed, login to view], and also make the value of [url removed, login to view] all lowercase and replace the phpbb_users.username_clean. There are about 1200 entries to update.
username_clean jenny (note lower case)
smf_members (no change)
phpbb_users (both changed)
username_clean jennyb (username made lower case)
Time is of the essence.. please only bid if you can provide the SQL query immediately.