[Top][All Lists]
[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