Consolation World Record

One day a character decides that he's going to set a world record. Oh, the hijinks! Unfortunately, something goes horribly wrong, and he or she does not actually achieve the record. Not to worry, though - in the process of trying for World Record A, the character actually set World Record B, without even trying!

A common example is someone trying to set multiple records, fail, and get in the record books for most failed attempts.

Often used to set up an Aesop like "try your best and you will succeed at something."

Examples of Consolation World Record include:

Anime and Manga

Chapters 21 and 22 of Sket Dance focus on a classroom election for titles such as "Mr. Sportsman" and "Nicest Vocals". An introverted boy wants to remodel himself into the most popular guy in class, but does poorly in tests of athleticism, pop-culture knowledge and everything else. So as a last resort, the heroes persuade their classmates to cheer him up - only to find that everyone already voted him "#1 Mr. Nice-Guy".

Comic Books

In one The New Archies story, the students at Riverdale Jr. High attempt to make the world's biggest sub sandwich. When the representative from the McKinnes' Book of World Records measures it, however, they're a half-inch short... but Jughead inadvertently salvages the situation by eating the whole thing himself in world record time.

Film

In the musical Flying High, it's not clear what, if any, aviation record airplane mechanic "Rusty" Krause (played by Bert Lahr) was trying to set when he climbed into the pilot's seat, but because he didn't know how to land the plane, the one he ended up setting was for longest time up in the air.

Live Action TV

Subverted in one episode of Lizzie McGuire where her brother and his friend try to get in the Guiness book of World Records. His parents say he won the world record for most world record attempts. When they open the book though they quickly close it in front of him. As it turns out someone already had that record, poking fun at how cliché this trope is.
Herman's Head: Herman is out to set a world record for continuous working at one sitting. He discovers that one of his colleagues is planning to sing at a night club, and leaving work to watch her would preclude him breaking the record. He watches her anyway. The next day, the record book authorities come in, and Herman wonders why. Turns out that he broke a record: eating the most sunflower seeds in one sitting! He'd been eating them the entire time.
In an episode of Sanford and Son, Fred attempted to set the record for longest time staying awake. He missed the mark by less than a minute, yet Bubba and Roger (the son of Lamont's girlfriend) each set their own records in their efforts to help Fred along (Bubba for most repetitions of one song, Roger for marathon basketball bouncing). Note how the man from Guiness took Roger and Bubba's word for how long they'd been at their particular tasks, but wouldn't give Fred the benefit of the doubt for a minute's worth of consciousness.
On The Brady Bunch, Bobby and Cindy failed to break the record for consecutive hours on a seesaw, but they set a record for consecutive hours by children on a seesaw. Plus they were in the newspaper.
iCarly had a variation. After failing to break the record for longest continuous webcast, the Records Books official noted that Spencer had broken the record for most moving parts on a sculpture. He then invites Carly, Freddie, and Sam to help him "finish" the sculpture (by adding extra pieces) so they can receive co-artist credit.
M*A*S*H. Klinger decides to sit up a pole in protest about his not being allowed to leave the Army. When the others realise he's close to breaking a world pole-sitting record, Colonel Potter orders him to stay up there, even though he's decided to come down. "It's either that or swallowing 24 goldfish!" Klinger breaks the record, and is allowed leave in Tokyo instead.
The short-lined USA sitcom "Campus Cops" featured this plot point. In it one of the main characters was trying to set a World Record for "Most Sexual Thoughts" in a 24 hour period. However with the record in sight, his machine malfunctions, and he is horrible electrocuted. While recuperating, he learns he has in fact set a new record for Most Electricity withstood by a human being.

Web Original

On Homestar Runner, the Strong Bad Email "record book", Strong Bad inadvertently earns the record for "Longest Bull Honkey" after objecting at length to The Cheat's suggestion of "most rectangular mouth".
- It's not shown, but what could be more of a consolation than "Most Macaroni Nailed To A Paper Towel Tube ...By Strong Mad"? Strong Mad wins it with a record of one.

Western Animation

SpongeBob SquarePants: Throughout an episode, Patrick is trying to win an award, since he is jealous of the closetful of awards that Spongebob has. In the end, he finally gets one for... "Doing absolutely nothing, longer than anyone else!"
- Spongebob asks him if he wants to try and win another one now, but Patrick tells him "No, I've got to protect my record!" and goes back to lying under his rock.
In the Hey Arnold! episode "World Records", Arnold and his friends attempt multiple times to set a world record, failing every time - until they get the record for most attempts to get into the Guinness Book of World Records.
In the Simpsons episode "Sweets and Sour Marge", Homer and the town of Springfield attempt to build the world's largest human pyramid. This does not go well; however, the town is awarded "Fattest Town".
One episode of Ned's Newt ended up giving Ned the world record for "worst world record attempt ever".
In one episode of Wow! Wow! Wubbzy!, Wubbzy attempts to break a record (and get a shiny trophy), but is distracted each time by a townsperson in need of help. In the end, he gets a trophy for doing the most good deeds in a day.
There was an episode of the comic The New Archies in which the class tries to break the record for longest submarine sandwich. It was a valiant effort, but the sandwich simply wasn't made long enough. Jughead, however, does land the record for eating it in the least amount of time the representative had ever seen—and Jughead wasn't even going for that!
Not sure if this ever appeared in the cartoon, but there was a book of Muppet Babies stories in which Skeeter tries to set a record, and after multiple failures Kermit declares that she set the record for most attempts to break a record without actually succeeding.
Hi Hi Puffy AmiYumi : "Record Breakers" were the duo attempt to bust world records for a number of ridiculous things. They failed at each miserably, but were eventually awarded "Most Attempts to Break a World Record by a Japanese Singing Group".
In Yvon of the Yukon, the entire town tries to break a world record in order to get back on the map (it had been removed due to being a small town with a long name), but their repeated attempts drive the records guy insane until he gives them the world record for "Craziest Town in the World"
In the Strawberry Shortcake's Berry Bitty Adventures episode "Berry Bitty World Record," the girls attempt to break a record in order to win a vacation for Berrykin Bloom, with Orange Blossom in charge of organizing their attempts. In the end, they don't break any of the records they were aiming for, but the judge (who turned out to be a friend of theirs) tells them that Orange broke the record for "most consecutive hops", since she spent the whole day going from girl to girl on her pogo stick.
Averted in Phineas and Ferb, where they not only get the World's Most Pointless Record for the world's largest bowling ball and the world's largest pinball game, they also get the WMPR for getting the most WMPR in one day.
One episode of Goof Troop centered around Goofy trying to win an award for some achievement - any achievement - at his high school reunion, because he thinks his son will be ashamed of him if he doesn't distinguish himself somehow. He gets a father/son award for extreme dedication to each other when Max impersonates Goofy to attempt a ridiculously dangerous skateboarding stunt on his behalf.

Real Life

A motorcyclist who was trying to break the land speed record for motorcycles was awarded the record for the fastest motorcyle crash ever survived: ~200 miles per hour.
Top Gear has done this on more than one occasion - Richard Hammond's infamous jet-car crash may or may not have set an official British record for land speed (unofficially the run before the crash was fastest, but to eliminate the possibility of a tailwind messing with the speed, the run must be made in two directions directly opposite of each other), but it certainly set a British, if not world, record for fastest land crash (again, probably unofficially)... They also inadvertently set the world indoor speed record with an F1 car. And almost set it with a Chevrolet Lacetti...
- Speed records are the average of two runs, going opposite ways, within one hour of each other. This is to negate the effects of wind in the speed measurement.
  - The trio joked that they could've got the official record for fastest crash if Richard had done it in the opposite direction as well.
  - May and Clarkson set two records at once a while back; the first to reach the north pole by truck, and the first man ever to reach the north pole, who didn't want to be there.
- They did make a good shot at setting a new record for fastest time to cross the English Channel in an amphibious vehicle (A truck with an outboard motor). If they had attached a prow to the front of the truck and brought a compass they might have made it. It was almost certainly the first time that anyone ever drove a truck from Dover to Calais without using the ferry.
In 1964, Craig Breedlove tried to set a new land-speed record, lost control, and laid down six-mile skid marks—the world's longest.
There have been multiple incidents where an effort to win a world record in some thing or another has gotten the person involved a consolation Darwin Award.