Package: egroupware Version: 1.0.00.006-1.dfsg-1 Severity: important
I get an sql error in the calendar: ----------------------------- Database error: Invalid SQL: SELECT DISTINCT phpgw_cal.cal_id,phpgw_cal.datetime,phpgw_cal.edatetime,phpgw_cal.priority FROM phpgw_cal_user, phpgw_cal, 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 >= 1109631600 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. Check the manual that corresponds to your MySQL server version for the right syntax to use near ') AND (phpgw_cal_repeats.recur_enddate >= 1109631600 OR phpgw_c) File: /usr/share/egroupware/calendar/inc/class.socalendar_sql.inc.php Line: 543 Function: socalendar_::get_event_ids / socalendar::get_event_ids / socalendar::list_repeated_events / bocalendar::store_to_cache / uicalendar::timematrix / uicalendar::viewmatrix / execmethod Session halted. ----------------------------- What I did was: 1. Goto into the calendar 2. select matrix-view 3. display it for the current month 4. Click on 'Show next seven days' Uwe -- System Information: Debian Release: 3.1 APT prefers unstable APT policy: (990, 'unstable'), (500, 'testing') Architecture: powerpc (ppc) Kernel: Linux 2.6.11-rc4 Locale: [EMAIL PROTECTED], [EMAIL PROTECTED] (charmap=ISO-8859-15) (ignored: LC_ALL set to [EMAIL PROTECTED]) Versions of packages egroupware depends on: ii egroupware-addressbo 1.0.00.006-1.dfsg-1 eGroupWare addressbook management ii egroupware-bookmarks 1.0.00.006-1.dfsg-1 eGroupWare bookmark management app ii egroupware-calendar 1.0.00.006-1.dfsg-1 eGroupWare calendar management app ii egroupware-comic 1.0.00.006-1.dfsg-1 eGroupWare comic strip application ii egroupware-core 1.0.00.006-1.dfsg-1 eGroupWare core modules ii egroupware-developer 1.0.00.006-1.dfsg-1 eGroupWare developer tools ii egroupware-email 1.0.00.006-1.dfsg-1 eGroupWare E-mail client applicati ii egroupware-emailadmi 1.0.00.006-1.dfsg-1 eGroupWare E-mail user administrat ii egroupware-etemplate 1.0.00.006-1.dfsg-1 widget-based template system for e ii egroupware-felamimai 1.0.00.006-1.dfsg-1 eGroupWare FeLaMiMail application ii egroupware-filemanag 1.0.00.006-1.dfsg-1 eGroupWare file manager applicatio ii egroupware-forum 1.0.00.006-1.dfsg-1 eGroupWare forum application ii egroupware-ftp 1.0.00.006-1.dfsg-1 eGroupWare FTP application ii egroupware-fudforum 1.0.00.006-1.dfsg-1 eGroupWare FUDforum application ii egroupware-headlines 1.0.00.006-1.dfsg-1 eGroupWare headlines catcher appli ii egroupware-infolog 1.0.00.006-1.dfsg-1 eGroupWare infolog application ii egroupware-jinn 1.0.00.006-1.dfsg-1 content management system for eGro ii egroupware-manual 1.0.00.006-1.dfsg-1 eGroupWare manual ii egroupware-messenger 1.0.00.006-1.dfsg-1 eGroupWare messenger application ii egroupware-news-admi 1.0.00.006-1.dfsg-1 eGroupWare news administration int ii egroupware-phpbrain 1.0.00.006-1.dfsg-1 eGroupWare phpbrain application ii egroupware-phpldapad 1.0.00.006-1.dfsg-1 eGroupWare phpLDAPadmin applicatio ii egroupware-phpsysinf 1.0.00.006-1.dfsg-1 eGroupWare phpSysInfo application ii egroupware-polls 1.0.00.006-1.dfsg-1 eGroupWare polling application ii egroupware-projects 1.0.00.006-1.dfsg-1 eGroupWare projects management app ii egroupware-registrat 1.0.00.006-1.dfsg-1 eGroupWare registration applicatio ii egroupware-sitemgr 1.0.00.006-1.dfsg-1 eGroupWare site manager applicatio ii egroupware-skel 1.0.00.006-1.dfsg-1 eGroupWare skeleton application ii egroupware-stocks 1.0.00.006-1.dfsg-1 eGroupWare stock management applic ii egroupware-tts 1.0.00.006-1.dfsg-1 eGroupWare trouble ticket system a ii egroupware-wiki 1.0.00.006-1.dfsg-1 eGroupWare wiki application -- no debconf information -- To UNSUBSCRIBE, email to [EMAIL PROTECTED] with a subject of "unsubscribe". Trouble? Contact [EMAIL PROTECTED]