|
S
samp author
I'm getting this error when I try to add a new user to an 'Employees' table:
Error type 256
Error description Duplicate entry 'SP' for key 1
URL mydomain.com/work/Employees_add.php
Error file /home/login-id/public_html/work/include/dbconnection.php
Error line 26
SQL query insert into `Employees` (`First_Name`, `Last_Name`, `Address1`, `Address2`, `City`, `State`, `Zip`, `Fax`, `Email`, `Password`, `Permissions`, `Phone`, `Cell`, `ID_Initials`) values ('Phil', 'Adams', '3100 East 45th St.', NULL, 'Cleveland', 'OH', '44127', '216-241-5355', 'padams@mydomain.com', NULL, NULL, '2162415355', NULL, 'SP')
'ID_Initials' is a key field in that table. I see this error even when I include 'ID_Initials' on the add page and enter values manually. PHP seems to be using duplicate default value (I'm logged in as 'SP' for this example).
Where or how do I override this setting?
Thanks,
Sam
|
|
