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'

Submitted by:  Woon Wai Keen <doubleukay>
Submitted on:  Wed 16 Mar 2005 02:49:13 PM UTC  
 
Item Group: 0.9.16.005Category: tts
Severity: 3 - NormalPriority: 5 - Normal
Status: FixedPrivacy: Public
Assigned to: Philipp Kamps <fipsfuchs>Open/Closed: Closed
Component Version: DEBOperating System: GNU/Linux - Debian
Reproducibility: Every TimePlanned 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>In charge of this item.
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>

 

No files currently attached

 

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
Mon 21 Mar 2005 10:08:28 AM UTCfipsfuchsStatusNone=>Fixed
  Open/ClosedOpen=>Closed
Thu 17 Mar 2005 12:23:47 PM UTCskwashdAssigned toNone=>fipsfuchs

Back to the top


Powered by Savane 3.1-cleanup1