Raw SQL Error Exposed on Duplicate Phone Number During User Creation

[mirolimsgd]

Description:

If a user tries to register with a phone number that already exists in the database, the system returns a raw SQL error message to the application (ERROR: duplicate key value violates unique constraint "users_phone_key" (SQLSTATE 23505)).

Expected Behavior:

Instead of exposing database-level errors, the application should catch this specific constraint violation and return a user-friendly message like "This phone number is already registered. Please use a different number or try logging in."

Benefit:

Enhances usability by providing clear, understandable error messages instead of technical jargon. Improves security by not exposing internal database details.

[sabokhat1]

@diyor28 this is working