[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: |
Tue, 29 Oct 2002 07:56:38 -0500 |
=================== BUG #1394: LATEST MODIFICATIONS ==================
http://savannah.gnu.org/bugs/?func=detailbug&bug_id=1394&group_id=509
Changes by: Ralf Becker <address@hidden>
Date: 2002-Oct-29 13:56 (Europe/Berlin)
What | Removed | Added
---------------------------------------------------------------------------
Resolution | None | Fixed
Assigned to | skwashd | ralfbecker
Status | Open | Closed
------------------ Additional Follow-up Comments ----------------------------
This has been corrected in CVS.
To grab a complete update of all fixes:
1) Check to see if you have cvs installed: 'cvs --help'.
1a) If not, install a copy of cvs-cli from your favorite
distro.
2) Then just type:
'cd <your phpgroupware dir>; cvs update -dP'.
You can do step 2 as many times in a day as you wish, and
will always get the most current bug fixes.
Thanks,
=================== BUG #1394: FULL BUG SNAPSHOT ===================
Submitted by: lance Project: phpGroupWare
Submitted on: 2002-Oct-10 17:29
Category: calendar Bug Group: 0.9.14 release
Severity: 5 - Major Priority: None
Resolution: Fixed Assigned to: ralfbecker
Status: Closed 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-29 13:56 By: ralfbecker
This has been corrected in CVS.
To grab a complete update of all fixes:
1) Check to see if you have cvs installed: 'cvs --help'.
1a) If not, install a copy of cvs-cli from your favorite
distro.
2) Then just type:
'cd <your phpgroupware dir>; cvs update -dP'.
You can do step 2 as many times in a day as you wish, and
will always get the most current bug fixes.
Thanks,
-------------------------------------------------------
Date: 2002-Oct-27 02:31 By: skwashd
Ok, now i know where to start hunting. I do not have pgsql, but I will try to
do a patch that doesn't break mysql, but fixes the pgsql problem. Are either
of you able to test it for me? It won't be ready for a few days ... need some
time on the cal code (pretty complex)
-------------------------------------------------------
Date: 2002-Oct-26 14:58 By: fredbox
yes, pgsql. It does seem to choke on the null value in the parens in that
statement. It worked if I could munge a 0 into those parens but that broke
something else. I don't remember exactly what at the moment.
-------------------------------------------------------
Date: 2002-Oct-26 14: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-25 19: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