bugphpGroupWare - Bugs: bug #12340, Invalid SQL for 'View all tickets'

 
 

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

bug #12340: Invalid SQL for 'View all tickets'

Submitter:  Woon Wai Keen <doubleukay>
Submitted:  Wed 16 Mar 2005 02:49:13 PM UTC
   
 
Category:  tts Item Group:  0.9.16.005
Severity:  3 - Normal Priority:  5 - Normal
Status:  Fixed Privacy:  Public
Assigned to:  fipsfuchs Open/Closed:  Closed
Component Version:  DEB Operating System:  GNU/Linux - Debian
Reproducibility:  Every Time Planned Release:  None
Fixed Release: 

Mon 21 Mar 2005 10:08:28 AM UTC, comment #1: 

fixed for 0.9.16 branch

head branch doesn't have this sql statement

thx for report

Philipp Kamps <fipsfuchs>
Wed 16 Mar 2005 02:49:13 PM UTC, original submission:  

ERROR:
--
Database error: Invalid SQL: select * from phpgw_tts_tickets where 1 order by ticket_priority desc
PostgreSQL Error: 1 (ERROR: argument of WHERE must be type boolean, not type integer)

File: /usr/share/phpgroupware/tts/index.php
Line: 188

FIX:
--
Change 'where 1' to 'where 1=1'

Woon Wai Keen <doubleukay>

 

(Note: upload size limit is set to 16384 kB, after insertion of the required escape characters.)

No files currently attached

 

Depends on the following items: None found

Items that depend on this one: None found

 

CC list is empty

 

There are 0 votes so far. Votes easily highlight which items people would like to see resolved in priority, independently of the priority of the item set by tracker managers.

 

Follow 3 latest changes.

Date Changed by Updated Field Previous Value => Replaced by
2005-03-21 fipsfuchs StatusNone Fixed
    Open/ClosedOpen Closed
2005-03-17 skwashd Assigned toNone fipsfuchs

Back to the top

Powered by Savane 3.13-3230.
Corresponding source code