bugphpGroupWare - Bugs: bug #5797, Invalid SQL statement on...

 
 

You are not allowed to post comments on this tracker with your current authentication level.

bug #5797: Invalid SQL statement on admin/inc/class.soaccess_history.inc.php

Submitted by:  None
Submitted on:  Wed 08 Oct 2003 02:23:27 AM UTC  
 
Item Group: 0.9.16RC1Category: API - phpGroupware API
Severity: 3 - NormalPriority: 5 - Normal
Status: FixedPrivacy: Public
Assigned to: Dave Hall <skwashd>Open/Closed: Closed
Component Version: SVNOperating System: None
Reproducibility: Every TimePlanned Release: None
Fixed Release: 

Wed 08 Oct 2003 07:09:13 AM UTC, comment #1:

Thanks for the bug report. I did see the diff until after doing the commit. I fixed a couple of other things there.

Please run a cvs update using:
cd /path/phpgroupware/admin/inc
cvs update -dPC

The C flag grabs clean copies so you don't get conflicts.

Cheers

Dave Hall <skwashd>
Project AdministratorIn charge of this item.
Wed 08 Oct 2003 02:23:27 AM UTC, 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.

-unavailable- a.k.a missGombal

Anonymous

 

Attached Files
file #715:  class.soaccess_history.inc.php.diff added by None (406B - application/octet-stream - fix for admin/inc/class.soaccess_history.inc.php)

 

Depends on the following items: None found

Items that depend on this one: None found

 

CC list is empty

 

Do you think this task is very important?
If so, you can click here to add your encouragement to it.
This task has 0 encouragements so far.

Only logged-in users can vote.

 

Please enter the title of George Orwell's famous dystopian book (it's a date):

 

 

Follow 3 latest changes.

Date Changed By Updated Field Previous Value => Replaced By
Wed 08 Oct 2003 07:09:13 AM UTCskwashdStatusNone=>(Error - Not Found)
  Assigned toNone=>NA
  Open/ClosedOpen=>(Error - Not Found)

Back to the top


Powered by Savane 3.1-cleanup1