Weak magnetism in insulating and superconducting cuprates