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

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

Changes by: Jonathan Rivera <jarg@xxxxxxxxx>
Date: Fri 10/03/2003 at 04:10 (GMT)

            What     | Removed                   | Added
---------------------------------------------------------------------------
          Resolution | None                      | Fixed


------------------ Additional Follow-up Comments ----------------------------
This has been corrected in CVS.



To grab a complete update of all fixes:



1)  Check to see if you have cvs installed: 'cvs --help'.

1a) If not, install a copy of cvs-cli from your favorite 

distro.



2)  Then just type:

    'cd <your phpgroupware dir>; cvs update -dP'.



You can do step 2 as many times in a day as you wish, and 

will always get the most current bug fixes.



Thanks,





=================== BUG #5655: FULL BUG SNAPSHOT ===================


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:  Fixed                    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.

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

-------------------------------------------------------
Date: Fri 10/03/2003 at 04:10       By: jarg
This has been corrected in CVS.



To grab a complete update of all fixes:



1)  Check to see if you have cvs installed: 'cvs --help'.

1a) If not, install a copy of cvs-cli from your favorite 

distro.



2)  Then just type:

    'cd <your phpgroupware dir>; cvs update -dP'.



You can do step 2 as many times in a day as you wish, and 

will always get the most current bug fixes.



Thanks,




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/