Phase transition in the detection of modules in sparse networks