Advice on Obtaining a Visa in Germany as a Foreigner

Hi, I want to preface this post by saying that I understand this is not a great situation and I should have done my best to avoid it, but I am stuck with this problem now and after trying to deal with it for over a month, I need help.

I am a Canadian student on an exchange program in Germany funded by ERASMUS. This is a European exchange program, but because my Canadian university has a partnership with my German university, I am able to obtain the scholarship funding awarded by this program. Therefore, I am currently working in an unpaid research internship role at a German university. Being an unpaid intern and my origin being Canada, I did not require a visa to enter Germany or to perform my internship. I am on my exchange in Germany from April 29th to July 30th and will travel within the Schengen region after this date, departing to Canada from the Netherlands on August 10th. This makes my total stay in the Schengen region to be 104 days, over the 90-day requirement.

I could not obtain my visa before entering Germany due to the short time between receiving my invitation letter and my departure. According to the [German missions in Toronto](https://canada.diplo.de/ca-en/consular-services/visa/yma), I can also legally obtain a visa for my “Youth Mobility” stay at other missions abroad or Alien’s Authorities (Ausländerbehörde). Knowing this and knowing I did not have time to get my visa prior to leaving, I assumed I could get it by the same process while in Germany when I arrived. Boy was I wrong.

I have been sending emails to my local Migrationsamt for over a month now and they have not been able to assist me with visa advice, only providing me with instructions to receive a residence permit. I even received advice from the German federal foreign office helpline and they also instructed me to contact the Migrationsamt/local aliens authority/foreigners authority to extend my stay in the Schengen region.

What do I do now? Do I try to have a German-speaking friend assist me in calling the Migrationsamt? Am I even contacting the right people? Any advice is much appreciated as this entire process has been causing me so much anxiety since I arrived I have not been able to enjoy a single day in this beautiful country without thinking about this situation.

Thank you in advance and sorry for such a long post.