[Top][All Lists]
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Phpgroupware-tracker] [bug #5520] database error when editing user and
From: |
nobody |
Subject: |
[Phpgroupware-tracker] [bug #5520] database error when editing user and adding applications |
Date: |
Tue, 23 Sep 2003 17:46:25 -0400 |
User-agent: |
Mozilla/5.0 (X11; U; Linux i686; en-US; rv:1.4) Gecko/20030908 Epiphany/1.0 |
=================== 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/