Hi,
thanks for the info, it’s fixed now in svn.
You can be happy about the SQL error in PostgreSQL, if the statement had
worked, it would have deleted all non-recuring events (that’s fixed now
too).
Ralf
When I enabled the calendar purge function to remove events older that 1 year,
I am faced with the following error using PostgreSQL:
Database error: Invalid SQL: DELETE egw_cal.* FROM egw_cal
LEFT JOIN egw_cal_repeats ON
egw_cal_repeats.cal_id = egw_cal.cal_id
WHERE egw_cal_repeats.cal_id IS NULL || (recur_enddate
< 1246497302 && recur_enddate != 0):
ERROR: syntax error at or near "egw_cal"
LINE 1: DELETE egw_cal.* FROM egw_cal
^
#0 /var/www/egroupware/phpgwapi/inc/class.egw_db.inc.php(674): egw_db-
halt(‘Invalid SQL: DE…’, 1520, ‘/var/www/egroup…’)
#1 /var/www/egroupware/calendar/inc/class.calendar_so.inc.php(1520): egw_db-
query(‘DELETE egw_cal…’, 1520, ‘/var/www/egroup…’)
#2 /var/www/egroupware/calendar/inc/class.calendar_boupdate.inc.php(2294):
calendar_so->purge(1246497302)
#3 [internal function]: calendar_boupdate->purge(1)
#4 /var/www/egroupware/phpgwapi/inc/common_functions.inc.php(886):
call_user_func(Array, 1)
#5 /var/www/egroupware/phpgwapi/inc/class.asyncservice.inc.php(421):
ExecMethod(‘calendar.calend…’, 1)
#6 [internal function]: asyncservice->check_run(‘crontab’)
#7 /var/www/egroupware/phpgwapi/inc/common_functions.inc.php(886):
call_user_func(Array, ‘crontab’)
#8 /var/www/egroupware/phpgwapi/cron/asyncservices.php(63):
ExecMethod(‘phpgwapi.asyncs…’, ‘crontab’)
#9 {main}
It appears not to like the DELETE egw_cal.* FROM egw_cal portion of the query.
This SF.net email is sponsored by Sprint
What will you do first with EVO, the first 4G phone?
Visit sprint.com/first – http://p.sf.net/sfu/sprint-com-first
eGroupWare-developers mailing list
eGroupWare-developers@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/egroupware-developers
–
Ralf Becker
Director Software Development
Stylite GmbH
[open style of IT]
Morschheimer Strasse 15
67292 Kirchheimbolanden
fon +49 (0) 6352 70629-0
fax +49 (0) 6352 70629-30
mailto: rb@stylite.de
www.stylite.de
www.egroupware.org
Geschäftsführer Andre Keller,
Gudrun Müller, Ralf Becker
Registergericht Kaiserslautern HRB 30575
Umsatzsteuer-Id / VAT-Id: DE214280951
This SF.net email is sponsored by Sprint
What will you do first with EVO, the first 4G phone?
Visit sprint.com/first – http://p.sf.net/sfu/sprint-com-first
eGroupWare-developers mailing list
eGroupWare-developers@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/egroupware-developers
