Bug #2 - Add Individual Customer gives Error Message

Description

Create Customer (Add Individual Customer)

Steps to Reproduce

1. Open App
2. Click Individual
3. Click Add Coporate Customer
4. Fill the necessary information
5. Review information
6. Create Customer

Expected Result

Customer account is created successfully

Actual Result

Failed to create customer: SQLSTATE[23514]: Check violation: 7 ERROR: new row for relation "customers" violates check constraint "customers_customer_type_check" DETAIL: Failing row contains (912, CLA20250907, null, Asas, null, Jacob, 2010-01-01, male, dee@gmail.com, 0802343433, 2, Games Street, Lekki, Lagos, Nigeria, null, Digital Marketing, 25000000.00, married, Simisola, Daughter, 08023434545, nin, 1234567890, active, 2025-09-23 14:52:53, 2025-09-23 14:52:53, null, individual, null, null, null, null, null, null, null, null, null, null, null, null, null, Thelightville Consulting, null, null, null). (Connection: pgsql, SQL: insert into "customers" ("customer_type", "email", "phone", "address", "city", "state", "country", "first_name", "last_name", "date_of_birth", "gender", "marital_status", "occupation", "employer", "annual_income", "identification_type", "identification_number", "next_of_kin_name", "next_of_kin_relationship", "next_of_kin_phone", "customer_number", "customer_status", "updated_at", "created_at") values (individual, dee@gmail.com, 0802343433, 2, Games Street, Lekki, Lagos, Nigeria, Asas, Jacob, 2010-01-01 00:00:00, male, married, Digital Marketing, Thelightville Consulting, 25000000, nin, 1234567890, Simisola, Daughter, 08023434545, CLA20250907, active, 2025-09-23 14:52:53, 2025-09-23 14:52:53) returning "id")

Attachments

Error 1.jpg

File not found

Missing

Developer Resolution Notes

Validated in current version: Retail/Corporate customer creation is fully functional. 910 retail and 496 corporate customers successfully created. All routes and controllers working properly.

Additional Comments (Tester Notes)

1. A future date was entered, and it gave an error message after the whole process. It should give the error message immediately. 2. Annual income can be categorised into income brackets 3. Commas should automatically be included when entering figures. 4. Inputs like phone numbers, ID-type numbers should be formatted so that they give an error message when a wrong format is entered. 5. Important fields should be indicated with an asterisk (*) and should return an error message if it is not filled

Last updated by: Admin User on Sep 25, 2025 at 2:03 PM

Bug Details

Priority: High
Severity: High
Module: Add Individual Customer
Browser: Chrome Version 140.0.7339.208
Operating System: Windows 10
Reported By: Admin User
Reported At: Sep 24, 2025 at 9:28 AM

Update Status

Status

Assign To

Resolution Notes (Developer Updates) For developers to provide technical resolution details

Additional Comments

Use this section to add testing notes, additional context, or follow-up information.

Tester Comments Add additional context, test results, or follow-up information

Quick Actions

Danger Zone

Once you delete a bug, there is no going back. Please be certain.