In the mid-90s I was involved with a partner for two years in a non-internet related tech startup (I know, stupid). The OP provided money and the business end. It was a 50/50 deal. I was a developer but I was given sales tasks to contact local businesses and large corporations. Sales and marketing was supposed to be the other parties responsibility. I was not able to hire any employees and the product became overwhelmingly difficult to complete. We finished a prototype but somehow we didn't really get any serious customers. The touch screen niche isn't even that popular today. I couldn't even get a press release because it wasn't really an innovative product (according to some publications) and before the real tech boom.
After that I had someone who wanted to go into an internet venture, but bitten by the experience I took a corporate/consulting/training route. Lately I just take on random projects for clients.
Now I'm considering a startup, but the past failure sort of holds me back. I applied to one startup as an employee, and now he is discussing a possible low salary and being a partner. When I think of the past experience though, its hard to move forward. I read all these success stories of the internet hard hitters and they seem to just get it right the first time. Maybe I'm missing something here..
Ok, how about closer to home - you're a developer, right?
... "overnight success". You'll find they've been marketing, blogging, interviewing, sending press releases and working like maniacs for years, until the buzz finally caught them.
I suggest you add Founders at work to your reading list - you'll see some of the stories of the early days of some of the well known companies. It's not the easy big hitting you seem to believe.
Paypal - success first time? Nope - they were a cashless payments app for Palm, which was going nowhere. I think the idea was something like beaming payments over IR to another Palm.
37signals? Basecamp was an internal app used in their main business of web design. Which one day they decided to try selling. They don't do web design any more as Basecamp turned out to be a little bit successful.
Flickr? It started out as an MMO. They added in chat and real time photo sharing and a few other things and it turned out people really liked the photo sharing. Then they realised people wanted to share photos and leave them available. iirc the chat got progressively more hidden until they could kill it. The game never saw the light of day.
The two founders of Flickr finally got around to something like the game they were thinking of though: http://www.glitch.com/ Just took them a decade and a completely different company and product to get there :)
The common thread through them though is they were happy to kill the main business when they found something better that worked. If they hadn't, chances are many of them would have been long gone and you'd never have heard of them.
The first bright idea may be great, but even then it'll need a lot of adjusting and rethinking to get customers to want it, and to be able to sell at a profitable price, and cater for the 55 things you never thought of. It may equally turn out to be a brilliant idea that no one wants to buy. In both scenarios you need to come up with something different - ideally using the lessons you just learnt.
The key is recognising when you need to transition, or when plan A isn't working, and not to give up, but to try plans B and C.
Now, if you like the idea you're being offered, and you think you can believe in it - go for it. All your previous startup experience gives you is additional valuable experience of a scenario that didn't work, and a couple of skills that aren't your forte. Perhaps it was also simply not the right time for the offering. But it's not a negative to stop you doing it again.
Good luck.
I think there are many questions you can ask yourself to help with that decision. As mentioned, there have been many companies that have been born from failure. There are many successful entrepreneurs that have one or more failures under their belt.
Do you really want to be involved with a startup, or do you really just want a job? Do you have faith in the startup and the partners/founders involved? Does your prior experience shed light on weaknesses in aspects of the business? Are those weaknesses worrisome, or are they reasonable so much as they would be resolved over a reasonable amount of time? Are the partners/founders aware of the weaknesses? Would you recognize the point at which to exit the partnership?
On the positive side, do they have stregnths missing in your previous experience? Is this a business you would really enjoy being a part of? What positive experience and useful knowledge would you gain in the event of failure, and how useful would that be?
There are many things learned from being involved with a failed startup. Sometimes these are necessary in order to have the experience to succeed. The key is to decide if you have learned enough to make the right decisions when the need arises, and to spot when things go off-track. I wish you the best and hope you don't let the failure itself dissuade you from persuing the course that's right for you.