Can compactifications solve the cosmological constant problem?