Bug 510

Summary: Client Name field validation does not block form submission — SQL integrity error exposed to end user
Product: Smartwas Reporter: Karunakaran (Karunakaran)
Component: Meal ManagementAssignee: Arun (Arun)
Status: OPEN ---    
Severity: High    
Priority: ---    
Version: unspecified   
Hardware: PC   
OS: Windows   
Associated Test Case ID: Triaged By: ---
Root Cause Analysis (RCA):
Resolution Summary / Fix Details:
Impact Area:
Attachments: Client Name field validation fails to block form submission — raw SQL error exposed to user

Description Karunakaran (Karunakaran) 2026-09-15 10:00:41 UTC
When the "Client Name" field is left empty and the form is submitted, the inline validation message "Please enter Client Name" appears correctly, but the form still submits to the backend. This triggers an unhandled SQL exception (SQLSTATE[23000]: Column 'client_name' cannot be null) shown in a raw browser alert popup
Comment 1 Karunakaran (Karunakaran) 2026-09-15 10:02:05 UTC
Created attachment 334 [details]
Client Name field validation fails to block form submission — raw SQL error exposed to user