[SOLVED] Google OAuth. Server error whenever any new user is signing up using google oauth
This is the table
OK First create a backup of the table Then run
ALTER TABLE _1_users ENGINE=InnoDB;
And check that everything are okay
I already created backup of appwrite yesterday night and no users has been added as this error was their. So it must be fine? Where to run ALTER TABLE command?
Open a query console
It is loading since 2 mins
The query or open the window?
Oh, It takes time, is the rebuild of the index process
7 mins. How much time it generally takes, i have only 500 users data?
Yeah It should finish already
disconnect and retry (and something get corrupted just restore from backup)
No luck. Same issue
π¦
I will suggest rebooting the MariaDB Instance ( docker compose down && docker compose up -d ) and try again
Ok. One thing i notice is that i am not able to make any changes to any user from appwrite console! Neither I am able to delete
The errors are all from the same origin the _1_users table
I think I found out the issue. So one user has name "Suraj **" I removed stars and now the query run! have to check with logged in
Cool!
Damn! App is working now for new users π Thanks man thanks a lot ππ»
So this is basically a bug. When anyone signs from google or other OAuth. Appwrite should remove all charcater except alphabet and spaces.
What version is your appwrite?
0.15.3
So maybe it was fixed in later versions
Yeah maybe.
[SOLVED] Google OAuth. Server error whenever any new user is signing up using google oauth
