[Phpgroupware-tracker] [bug #6279] after upgrade , tts not working

[nobody]

=================== BUG #6279: LATEST MODIFICATIONS ==================
http://savannah.gnu.org/bugs/?func=detailbug&bug_id=6279&group_id=509

Changes by: Dave Hall <address@hidden>
Date: Mon 11/03/03 at 18:00 (Australia/Melbourne)

            What     | Removed                   | Added
---------------------------------------------------------------------------
         Assigned to | None                      | skwashd


------------------ Additional Follow-up Comments ----------------------------
Can you please try a fresh cvs update



Also did you run setup to upgrade the app?



There was a botched import of some changes to this app.



=================== BUG #6279: FULL BUG SNAPSHOT ===================


Submitted by: mexico                  Project: phpGroupWare                 
Submitted on: Sat 11/01/03 at 11:04
Category:  tts                        Bug Group:  0.9.16RC1                 
Severity:  5 - Major                  Priority:  High                       
Resolution:  None                     Assigned to:  skwashd                 
Status:  Open                         Component Version:  CVS               
Platform Version:  None               Reproducibility:  Every Time          

Summary:  after upgrade , tts not working

Original Submission:  when running tts (tts/index.php), app failed with:



The API is current

This application is current

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: /var/www/phpgroupware/tts/index.php

Line: 138



for me, i try to change tts/index.php, line 138 from 

$filtermethod = "where 1" . etc..

to

$filetrmethod = "where true" . etc..

and tts working (partialy)



it is impssible to close ticket .. in history, there is marked as closed, but 
is still visible



Session halted.



Follow-up Comments
*******************

-------------------------------------------------------
Date: Mon 11/03/03 at 18:00         By: skwashd
Can you please try a fresh cvs update



Also did you run setup to upgrade the app?



There was a botched import of some changes to this app.


CC list is empty


No files currently attached


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

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