I think some older lessons/links don't work because GT is upgrading everything to HD-quality (replacing the older lessons). For the John Mayer tutorial you mentioned in your post, try this one:
http://www.guitartricks.com/tutorial.php?input=611
Great tutorial by Douglas with loads to learn!
Hope that helps.
JJ