That guy/girl will remain single forever
or 'Married but still available' ;D

Learn to appreciate good qualities/characteristics and ignore/forgive bad ones are the Mantra for lasting relationship.