[Phpgroupware-tracker] [bug #5520] database error when editing user and adding applications

[nobody]

=================== BUG #5520: FULL BUG SNAPSHOT ===================
http://savannah.gnu.org/bugs/?func=detailbug&bug_id=5520&group_id=509

Submitted by: esvinge                 Project: phpGroupWare                 
Submitted on: Tue 09/23/2003 at 21:12
Category:  API - Admin                Bug Group:  0.9.16RC1                 
Severity:  5 - Major                  Priority:  Normal                     
Resolution:  None                     Assigned to:  None                    
Status:  Open                         Component Version:  TGZ               
Platform Version:  Linux - Debian     Reproducibility:  Every Time          

Summary:  database error when editing user and adding applications

Original Submission:  The program tries to add the user to the address book 
even though their is no option to check or not check that and it crashes 
because it has no last name or first name. When all I was trying to do was add 
check marks and increase the number of applications. Not a severe bug but one 
that should be fixed by not adding people to address books by default, and also 
not giving a database crash when people forget to add the first + last names.



Below is the error.



type1person_idvorDatabase error: Invalid SQL: INSERT INTO phpgw_contact_person 
(prefix, first_name, last_name, created_on, created_by, modified_on, 
modified_by, person_id) VALUES ('esvinge', NULL , NULL , '1', '1', '1', '1', 
'3')

MySQL Error: 1048 (Column 'first_name' cannot be null)



File: /home/circlea/www/phpgwapi/inc/class.sql_entity.inc.php

Line: 420

Session halted. 





No Followups Have Been Posted


CC list is empty


No files currently attached


For detailed info, follow this link:
http://savannah.gnu.org/bugs/?func=detailbug&bug_id=5520&group_id=509

_______________________________________________
  Message sent via/by Savannah
  http://savannah.gnu.org/