My blog had been using the default permalink setting but today I changed it to "Month and name". Now in each post the "posted by" avatar is missing, presumably because the path to it is relative (img src="media/avatar.jpg") and needs to now written as the full path.
How do I change my settings so new posts get the correct path to the avatar image?
Where in the database do I find the the "posted by" text and path so I can update the previous posts? I looked in wp_posts but didn't find it.