Mr O’Connor, who was from Connolly Road in Ballyphehane on the southside of Cork City, was known for abusing drugs for many years but his life had reportedly 'fallen apart' before his death