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

[nobody]

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

Changes by: Edgar Luna <address@hidden>
Date: Tue 09/23/2003 at 15:46 (America/Mexico_City)

            What     | Removed                   | Added
---------------------------------------------------------------------------
         Assigned to | None                      | jarg


------------------ Additional Follow-up Comments ----------------------------
Ok, this bug is reported and will be fixed, but the decission about this was 
that for all accounts must be a contact entry. This is because contact have 
richest information about everyone, and there is an API to know if any given 
contact is a system contact or not.



What I think is that in the upgrade script _must_ create de contacts entries 
for actual users, and for create a new one must just insert an empty string for 
the problematic fields in phpgw_contact_person.



Any comment on this?



Thanks for testing.



=================== BUG #5520: FULL BUG SNAPSHOT ===================


Submitted by: esvinge                 Project: phpGroupWare                 
Submitted on: Tue 09/23/2003 at 15:12
Category:  API - Admin                Bug Group:  0.9.16RC1                 
Severity:  5 - Major                  Priority:  Normal                     
Resolution:  None                     Assigned to:  jarg                    
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. 



Follow-up Comments
*******************

-------------------------------------------------------
Date: Tue 09/23/2003 at 15:46       By: eald
Ok, this bug is reported and will be fixed, but the decission about this was 
that for all accounts must be a contact entry. This is because contact have 
richest information about everyone, and there is an API to know if any given 
contact is a system contact or not.



What I think is that in the upgrade script _must_ create de contacts entries 
for actual users, and for create a new one must just insert an empty string for 
the problematic fields in phpgw_contact_person.



Any comment on this?



Thanks for testing.


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/