phpgroupware-tracker
[Top][All Lists]
Advanced

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

[Phpgroupware-tracker] [Bug #1394] SQL in calendar.uicalendar.planner


From: nobody
Subject: [Phpgroupware-tracker] [Bug #1394] SQL in calendar.uicalendar.planner
Date: Sat, 26 Oct 2002 08:52:16 -0400

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

Changes by: Dave Hall <address@hidden>
Date: 2002-Oct-26 22:52 (Australia/Melbourne)

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


------------------ Additional Follow-up Comments ----------------------------
Fredbox do you also use pqsql?  

I am just trying to establish the cause ... i suspect it has something to do 
with "phpgw_cal_user.cal_login in ()" in pgsql ... but not sure.

Please let me know.





=================== BUG #1394: FULL BUG SNAPSHOT ===================


Submitted by: lance                     Project: phpGroupWare                   
Submitted on: 2002-Oct-11 01:29
Category:  calendar                     Bug Group:  0.9.14 release              
Severity:  5 - Major                    Priority:  None                         
Resolution:  None                       Assigned to:  skwashd                   
Status:  Open                           Component Version:  None                
Platform Version:  None                 Reproducibility:  Every Time            

Summary:  SQL in calendar.uicalendar.planner

Original Submission:  0.9.14 from cvs 
I have this error. this was working 2 week ago.


Database error: Invalid SQL: SELECT DISTINCT 
phpgw_cal.cal_id,phpgw_cal.datetime,phpgw_cal.edatetime,phpgw_cal.priority FROM 
phpgw_cal, phpgw_cal_user, phpgw_cal_repeats WHERE (phpgw_cal_user.cal_id = 
phpgw_cal.cal_id) AND (phpgw_cal_repeats.cal_id = phpgw_cal.cal_id) AND 
(phpgw_cal.cal_type='M') AND (phpgw_cal_user.cal_login in () AND 
((phpgw_cal_repeats.recur_enddate >= 1033416000) OR 
(phpgw_cal_repeats.recur_enddate=0))) ORDER BY phpgw_cal.datetime ASC, 
phpgw_cal.edatetime ASC, phpgw_cal.priority ASC
PostgreSQL Error: 1 (ERROR: parser: parse error at or near ")" )

File: /phpgroupware-0.9.14/calendar/inc/class.socalendar_sql.inc.php
Line: 396

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

-------------------------------------------------------
Date: 2002-Oct-26 22:52             By: skwashd
Fredbox do you also use pqsql?  

I am just trying to establish the cause ... i suspect it has something to do 
with "phpgw_cal_user.cal_login in ()" in pgsql ... but not sure.

Please let me know.



-------------------------------------------------------
Date: 2002-Oct-26 03:31             By: fredbox
Ditto

0.9.14 from cvs; debian-stable, php-4.2.1-3, apache 1.3.26-1 


CC list is empty


No files currently attached


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




reply via email to

[Prev in Thread] Current Thread [Next in Thread]