Sounds like your DM isn't paying attention to his players or giving you any opportunities to shine. I dealt with this when I first started playing D&D and didn't have an optimized fighter in an all caster group. I got my ass handed to me by high AC, high BAB monsters that didn't have any SR or magical DR, and always went straight for the tank. I wasn't given any help but rather made fun of for being a wimpy fighter.
The experience nearly turned me off from D&D all together. I ended up leaving the group to become a DM for a group of friends, and since then have learned that, as a DM, talking to the players about what they like and don't like, what they want more of and want less of, is an effective way of making sure everyone has fun and feels like they're contributing to the group.
I think the best thing to do in your situation would be to talk to your DM outside of the game and let him know that you feel useless. Don't outright ask him to switch up the module, just relay your frustrations. If he's a good DM - not to blow smoke up my own ass - he'll consider your frustrations and make changes that will give you opportunities to shine.
But don't feel bad when you fail skill checks and set off traps or mess up Diplomacy checks. I don't know how your group reacts to failed checks, but in the group I play in, we have the most fun dealing with traps that set off or NPCs that get pissed off from bad Diplomacy checks. It adds a bit of flavor, too. So unless you're with a bunch of dickheads, don't feel bad when you fail

play along with it. No character, in my opinion, should be so perfect that they make all their checks.