Revisit User Auth and SignUp

[DannyThorne01]

Task: Revisit User Auth and SignUp

NOTE: I have a bit of a busy week this week and next week so I didn't really get to do more debugging into the errors you guys are having as such this ticket is a little bit open ended and involves more debugging rather than development. I apologize in advance.

Feature: THIS IS MAINLY A BUG FIX TICKET. There is an error when signing up a user. The user is registered in Supabase-> Auth-> Users, but we need user information in the Supabase -> Database -> Tables-> profiles. The user is entered into this table a new entry but all the information associated with the user is NULL. I tried testing our the backend function you guys created and I can see that it clearly pulls the data that user enters in the frontend, but for some reason the Supabase receives this data as NULL, which sometimes results in an error because the table columns have a strict NON-NULLABLE value type.

• Resolve the the NULL user data problem. I'm not entirely certain where the problem is, I know it has to be in the Supabase maybe related to the SQL function that you guys adjusted. When you have resolved this issue retry the Forgot Password functionality and make sure it works. One tip to try to debug what's going on -> Supabase -> Logs -> Auth and here you'll see all the logs relating to User SignUp And Login.
• I'm not sure how long the above task will take, but if you're done and you have a little extra time try to implement this pipeline on the website. You'll have to do this task for the next ticket anyways just a heads up. Follow this tutorial for a workflow to implement these pipelines: Supabase Middleware Auth
• User SignUp -> Website Page Shows up Showing the user name -> User Logs Out
• User LogIN -> Website Page Shows up Showing the user name -> User Logs Out
• User Forgot Password -> User Resets Password -> User LogIN -> Website Page Shows up Showing the user name -> User Logs Out

Make sure you do these for at least 2 NEW and different users. If you need random emails we can just provide you with some.

Estimated Directory: 6hrs- if this ticket is taking you more than 6hrs let us know!