[Phpgroupware-tracker] [bug #5797] Invalid SQL statement on admin/inc/class.soaccess_history.inc.php

[nobody]

=================== BUG #5797: FULL BUG SNAPSHOT ===================
http://savannah.gnu.org/bugs/?func=detailbug&bug_id=5797&group_id=509

Submitted by: None                    Project: phpGroupWare                 
Submitted on: Tue 10/07/2003 at 22:23
Category:  API - phpGWapi             Bug Group:  0.9.16RC1                 
Severity:  5 - Major                  Priority:  Normal                     
Resolution:  None                     Assigned to:  None                    
Status:  Open                         Component Version:  CVS               
Platform Version:  None               Reproducibility:  Every Time          

Summary:  Invalid SQL statement on admin/inc/class.soaccess_history.inc.php

Original Submission:  i get error when accessing user login history via 
admin->user accounts->account view->login history, like this:

Database error: Invalid SQL: SELECT COUNT(*) FROM phpgw_access_log AND 
account_id=8



further exploration reveal that such statement contained in 
admin/inc/class.soaccess_history.inc.php function return_logged_out(), that is 
incorrect. there should be WHERE clause instead of AND. diffs attached.



address@hidden a.k.a missGombal





No Followups Have Been Posted


CC list is empty


File Attachments
****************

-------------------------------------------------------
Date: Tue 10/07/2003 at 22:23  Name: class.soaccess_history.inc.php.diff  Size: 
0KB   By: None
fix for admin/inc/class.soaccess_history.inc.php
http://savannah.gnu.org/bugs/download.php?group_id=509&bug_id=5797&bug_file_id=708


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

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