bugphpGroupWare - Bugs: bug #7678, Add a group with no users and try...

 
 

You are not allowed to post comments on this tracker with your current authentication level.

bug #7678: Add a group with no users and try to view new group in calendar

Submitted by:  None
Submitted on:  Wed 11 Feb 2004 01:46:49 PM UTC  
 
Item Group: 0.9.16RC3Category: calendar
Severity: 3 - NormalPriority: 1 - Later
Status: FixedPrivacy: Public
Assigned to: Dave Hall <skwashd>Open/Closed: Closed
Component Version: SVNOperating System: GNU/Linux - SuSE
Reproducibility: Every TimePlanned Release: None
Fixed Release: 

Fri 27 Feb 2004 03:48:48 AM UTC, comment #1:

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,

Dave Hall <skwashd>
Project AdministratorIn charge of this item.
Wed 11 Feb 2004 01:46:49 PM UTC, original submission:

If I add a group, and do not add any users to it, then when I go to the calendar and choose to view that groups calendar I get the following error displayed:

Database error: Invalid SQL: SELECT DISTINCT phpgw_cal.cal_id,phpgw_cal.datetime,phpgw_cal.edatetime,phpgw_cal.priority FROM phpgw_cal LEFT JOIN phpgw_cal_user on (phpgw_cal_user.cal_id = phpgw_cal.cal_id) , 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 >= 1072911600) OR (phpgw_cal_repeats.recur_enddate=0))) ORDER BY phpgw_cal.datetime ASC, phpgw_cal.edatetime ASC, phpgw_cal.priority ASC
MySQL Error: 1064 (You have an error in your SQL syntax near ') AND ((phpgw_cal_repeats.recur_enddate >= 1072911600) OR (phpgw_cal_repeats.rec' at line 1)

File: /srv/www/htdocs/phpgroupware-16-cvs/calendar/inc/class.socalendar_sql.inc.php
Line: 540

Session halted.

Should probably add something like a message that says there are no users currently in this group.

Anonymous

 

No files currently attached

 

Depends on the following items: None found

Items that depend on this one: None found

 

CC list is empty

 

Do you think this task is very important?
If so, you can click here to add your encouragement to it.
This task has 0 encouragements so far.

Only logged-in users can vote.

 

Please enter the title of George Orwell's famous dystopian book (it's a date):

 

 

Follow 4 latest changes.

Date Changed By Updated Field Previous Value => Replaced By
Fri 27 Feb 2004 03:48:48 AM UTCskwashdAssigned toNone=>skwashd
  Open/ClosedOpen=>Closed
Fri 27 Feb 2004 03:48:47 AM UTCskwashdStatusNone=>Fixed
Wed 11 Feb 2004 02:06:09 PM UTCdgraverCarbon-Copy-=>Added dgraver

Back to the top


Powered by Savane 3.1-cleanup1