[Phpgroupware-tracker] [bug #5655] Adding an 'other field' with no value, results in a SQL error

[nobody]

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

Submitted by: pooh_                   Project: phpGroupWare                 
Submitted on: Wed 10/01/2003 at 14:30
Category:  addressbook                Bug Group:  0.9.16RC1                 
Severity:  5 - Major                  Priority:  Normal                     
Resolution:  None                     Assigned to:  None                    
Status:  Open                         Component Version:  None              
Platform Version:  Linux - RedHat     Reproducibility:  Every Time          

Summary:  Adding an 'other field'  with no value, results in a SQL error

Original Submission:  Last cvs update oct 1, 16.00 Europe time

When adding an 'other field'  in the addressbook without a value I get the 
following error:

-------------
Database error: Invalid SQL: INSERT INTO phpgw_contact_others (other_name, 
other_value, contact_owner, contact_id) VALUES ('Sofinummer', NULL , '3', '13')
 MySQL Error: 1048 (Column 'other_value' cannot be null)
 
File: /html/phpgwapi/inc/class.contacts_sql.inc.php
Line: 2025

Session halted. 
----------

This occurs not when adding the fields but on saving the record.



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=5655&group_id=509

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