@Yochanan
Looks like libldap-2.4.so.2 comes from xampp. (AUR // chaotic-aur)
The following commands will drop to root using su and then will attempt to sort/rank localized mirrors and do a full sync/upgrade, then exit su.
(make sure no other package managers are running)
su -
pacman-mirrors -g && pacman -Syyu
exit