[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