bugphpGroupWare - Bugs: bug #5655, Adding an 'other field' with no...

 
 

You are not allowed to post comments on this tracker with your current authentication level.

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

Submitted by:  Hsing-Foo Wang <pooh_>
Submitted on:  Wed 01 Oct 2003 02:30:00 PM UTC  
 
Item Group: 0.9.16RC1Category: addressbook
Severity: 3 - NormalPriority: 5 - Normal
Status: FixedPrivacy: Public
Assigned to: NoneOpen/Closed: Closed
Component Version: NoneOperating System: GNU/Linux - RedHat/Fedora
Reproducibility: Every TimePlanned Release: None
Fixed Release: 

Fri 03 Oct 2003 04:10:36 AM UTC, comment #1:

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,

Jonathan Rivera <jarg>
Wed 01 Oct 2003 02:30:00 PM UTC, 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.

Hsing-Foo Wang <pooh_>

 

No files currently attached

 

Depends on the following items: None found

Items that depend on this one: None found

 

CC list is empty

 

Do you think this task is very important?
If so, you can click here to add your encouragement to it.
This task has 0 encouragements so far.

Only logged-in users can vote.

 

Please enter the title of George Orwell's famous dystopian book (it's a date):

 

 

Follow 2 latest changes.

Date Changed By Updated Field Previous Value => Replaced By
Sat 04 Oct 2003 01:13:07 AM UTCskwashdOpen/ClosedOpen=>(Error - Not Found)
Fri 03 Oct 2003 04:10:36 AM UTCjargStatusNone=>(Error - Not Found)

Back to the top


Powered by Savane 3.1-cleanup1