What is the status of the hadith stating that whoever appoints a man while there is someone more pleasing to Allah has betrayed Allah, His Messenger and the believers?

Summary

This hadith is narrated by Ibn Adiy, al-Uqaili, Ibn Abi Asim and al-Hakim with nearly the same meaning, but its chain is weak because of the narrator Husain bin Qays, whose narrations were abandoned. The supporting narration through Yazid bin Abi Habib from Ikrimah, recorded by al-Baihaqi, is also weak because of Ibn Lahi'ah, whose memory was poor especially after his books burned. The narrator from Ibn Lahi'ah in that chain, Uthman bin Soleh, narrated after the fire, so the support does not strengthen the hadith.

Written in our own words from the original fatwa — check the source before acting on it.