[Phpgroupware-tracker] [bug #5218] Creating admin account fails - missing person_id value

[nobody]

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

Changes by: Jason Pfingstmann <address@hidden>
Date: Mon 09/15/2003 at 16:41 (GMT)

------------------ Additional Follow-up Comments ----------------------------
This is fixed.  Please close.  Thank you.



=================== BUG #5218: FULL BUG SNAPSHOT ===================


Submitted by: jpfingstmann            Project: phpGroupWare                 
Submitted on: Thu 09/11/2003 at 17:28
Category:  API - Setup                Bug Group:  devel cvs                 
Severity:  5 - Major                  Priority:  Normal                     
Resolution:  None                     Assigned to:  None                    
Status:  Open                         Component Version:  CVS               
Platform Version:  Linux - Other      Reproducibility:  Every Time          

Summary:  Creating admin account fails - missing person_id value

Original Submission:  It would seem that class.accounts_sql.inc.php does not 
have the proper value for $person_id in its mysql statement.  This is from a 
CVS update done about an hour ago and then again tested with a fresh install 
about 5 minutes ago.  I have tried to track down where $person_id is generated, 
but could not find it.  (Sorry, I'm a bash scripter at most...am trying to 
learn perl & php, but this is WAY to complex for me at the moment.)  Also it 
seems to me the values are odd (Default & Group for account_firstname & 
account_lastname).. This may be on purpose for all I know though.

Database error: Invalid SQL: insert into phpgw_accounts (account_lid, 
account_type, account_pwd, account_firstname, account_lastname, account_status, 
account_expires, person_id) values 
('Default','g','99bd70a84f18b1bb35393002eece64ca', 'Default','Group','A',-1,)
 MySQL Error: 1064 (You have an error in your SQL syntax near ')' at line 1)
 
File: 
/home/httpd/htdocs/simplygwdev.wearesimply.com/phpgwapi/inc/class.accounts_sql.inc.php
Line: 345

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

-------------------------------------------------------
Date: Mon 09/15/2003 at 16:41       By: jpfingstmann
This is fixed.  Please close.  Thank you.


CC list is empty


No files currently attached


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

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