[Top][All Lists]

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

[Phpgroupware-tracker] [bug #5173] Cannot update existing user

From: nobody
Subject: [Phpgroupware-tracker] [bug #5173] Cannot update existing user
Date: Tue, 09 Sep 2003 16:03:44 -0400
User-agent: Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.0)

=================== BUG #5173: FULL BUG SNAPSHOT ===================

Submitted by: jpfingstmann            Project: phpGroupWare                 
Submitted on: Tue 09/09/2003 at 20:03
Category:  API - Admin                Bug Group:  0.9.16RC1                 
Severity:  5 - Major                  Priority:  High                       
Resolution:  None                     Assigned to:  None                    
Status:  Open                         Component Version:  CVS               
Platform Version:  None               Reproducibility:  Every Time          

Summary:  Cannot update existing user

Original Submission:  In a new install (see below for details) I created an 
admin user (and have SQL authentication on) and when trying to update the admin 
to give access to all installed programs I get: 

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 ('test', 'Test1', NULL , '1', '1', '1', '1', '9')

MySQL Error: 1048 (Column 'last_name' cannot be null)


Line: 420

Session halted. 

I had filled in the last name though.  This does not happen when I create a 
user for the first time, it works fine.  However, any time I edit a user I 
cannot submit the changes due to this error.  Also I have noticed that when 
pulling up a user to modify, it automatically wipes the First Name and Last 
Name from the form (they are listed in view format) and puts as 
the domain.  You can log in to with gwtest password 
1234   (this installation contains no company data and is a new install).

Here is the run of events:

I have been having some problems upgrading from what shows as to the 
new RC1 in cvs - I will post about this when I do some more testing on this 
problem... So at the moment I have the RC1 as a separate installation.  I just 
took my groupware directory and copied it to a different directory (and added 
appropriate vhost in apache) and then did a CVS update.  I deleted and had setup create a new one linking to a newly created DB.  
So now you know the complete setup I went through in case you need it.

No Followups Have Been Posted

CC list is empty

No files currently attached

For detailed info, follow this link:

  Message sent via/by Savannah

reply via email to

[Prev in Thread] Current Thread [Next in Thread]