The second one is gram. incorrect.
"yesterday" denotes smth that happened in the past, a complete action. requires verbs in the past tense.
present perfect tense denotes an action which started in the past, but continues in the present. never to be used along with "yesterday".
Student or Learner