I like the duct tape hub connector myself.

So how does one go about fixing this issue if it is still not correct?
That's really what we are here for guys.
The sump should drain outside prefferably at least 10 feet away from the foundation.
The S trap just needs a 4 inch flat on the upper section of the s trap, then it becomes a P trap.
I still do not understand what the Y is above the s trap...where does it go?
Does someone think they are equalizing the pressure or is this a redundant vent?
My advice is if this is a homeowner job, get the building dept at the least to get there to see where you went wrong. That is their job after all. Not just to look at the pro's and what they screw up, but to help homeowneres who will not hire someone, and end up doing it themselves anyway.
I love diggin up the old shtuff.