[Phpgroupware-tracker] [bugs #12340] Invalid SQL for 'View all tickets'

[Woon Wai Keen]

URL:
  <http://savannah.gnu.org/bugs/?func=detailitem&item_id=12340>

                 Summary: Invalid SQL for 'View all tickets'
                 Project: phpGroupWare
            Submitted by: doubleukay
            Submitted on: Wed 03/16/2005 at 14:49
              Item Group: 0.9.16.005
                Category: tts
                Severity: 5 - Average
                Priority: 5 - Normal
                  Status: None
                 Privacy: Public
             Assigned to: None
             Open/Closed: Open
       Component Version: DEB
        Platform Version: GNU/Linux - Debian
         Reproducibility: Every Time
         Planned Release: None
           Fixed Release: 

    _______________________________________________________

Details:

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'






    _______________________________________________________

Reply to this item at:

  <http://savannah.gnu.org/bugs/?func=detailitem&item_id=12340>

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