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

[nobody]

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

Changes by: Dave Hall <address@hidden>
Date: Sun 09/14/03 at 09:31 (Australia/Melbourne)

            What     | Removed                   | Added
---------------------------------------------------------------------------
            Category | API - Admin               | None
           Bug Group | 0.9.16RC1                 | None
          Resolution | None                      | Fixed
              Status | Open                      | Closed


------------------ Additional Follow-up Comments ----------------------------
I am closing this one as it is fixed.  Note for "None", the tarball releases 
are built periodically,  I would suggest that during the testing process you 
try to run a cvs update at least daily to get all the latest fixes.  Before 
posting a bug report please run an update to verify the problem still exists in 
the latest version of the code.



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


Submitted by: jpfingstmann            Project: phpGroupWare                 
Submitted on: Wed 09/10/03 at 06:03
Category:  None                       Severity:  5 - Major                  
Bug Group:  None                      Resolution:  Fixed                    
Assigned to:  alexbsa                 Status:  Closed                       

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)



File: 
/home/httpd/htdocs/simplygwdev.wearesimply.com/phpgwapi/inc/class.sql_entity.inc.php

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 grupogonher.com as 
the domain.  You can log in to simplygwdev.wearesimply.com 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 0.9.14.006 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 
header.inc.php 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.

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

-------------------------------------------------------
Date: Sun 09/14/03 at 09:31         By: skwashd
I am closing this one as it is fixed.  Note for "None", the tarball releases 
are built periodically,  I would suggest that during the testing process you 
try to run a cvs update at least daily to get all the latest fixes.  Before 
posting a bug report please run an update to verify the problem still exists in 
the latest version of the code.

-------------------------------------------------------
Date: Thu 09/11/03 at 23:49         By: None
This also happens in 0.9.16RC1--see my bug report #5213.  Evidently the CVS 
change was not incorporated into the RC1.

-------------------------------------------------------
Date: Wed 09/10/03 at 14:39         By: alexbsa
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,



-------------------------------------------------------
Date: Wed 09/10/03 at 14:29         By: alexbsa
This has been fixed in CVS and should be available in the next

release.

-------------------------------------------------------
Date: Wed 09/10/03 at 10:29         By: cw
Probably releated in some why,



these failed saves each generate a blank addressbook entry.

-------------------------------------------------------
Date: Wed 09/10/03 at 10:05         By: skwashd
Thanks for the detailed report ... we will get onto this asap.  These are 
mostly known issues.



The upgrade script is now fixed.  It slipped through our last round QA process 
- sorry.  Upgrade from cvs if you like.



The admin form is being worked on.  Should have that fixed soon.



Thanks for assisting in the testing process.


CC list is empty


No files currently attached


For detailed info, follow this link:
http://savannah.gnu.org/bugs/?func=detailbug&bug_id=5173&group_id=509

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