This is an annotated subset of the patches I applied to get 1.5 working locally. Some of these are carried over from 1.4. I'm sending it to the -devel list rather than the -users list; please let me know if that's not a good idea.

Thanks, Jeff

## ## These first two patches quote variables that ## have been observed empty (thereby causing SQL errors) ## on at least one occasion. ##

diff -rbBwu eventum-1.5/include/class.link_filter.php eventum-1.5n/include/class.link_filter.php --- eventum-1.5/include/class.link_filter.php Tue Mar 1 18:23:30 2005 +++ eventum-1.5n/include/class.link_filter.php Tue Mar 1 22:15:26 2005 @@ -311,8 +311,8 @@ " . APP_DEFAULT_DB . "." . APP_TABLE_PREFIX . "project_link_filter WHERE lfi_id = plf_lfi_id AND - lfi_usr_role < " . Auth::getCurrentRole() . " AND - plf_prj_id = $prj_id + lfi_usr_role < '" . Auth::getCurrentRole() . "' AND + plf_prj_id = '$prj_id' ORDER BY lfi_id"; $res = $GLOBALS["db_api"]->dbh->getAll($sql);

diff -rbBwu eventum-1.5/include/class.user.php eventum-1.5n/include/class.user.php --- eventum-1.5/include/class.user.php Tue Mar 1 18:23:30 2005 +++ eventum-1.5n/include/class.user.php Tue Mar 1 22:19:39 2005 @@ -699,7 +699,7 @@ FROM " . APP_DEFAULT_DB . "." . APP_TABLE_PREFIX . "user WHERE - usr_id IN (" . implode(', ', $items) . ")"; + usr_id IN ( '" . implode("', '", $items) . "')"; if (!is_array($usr_id)) { $res = $GLOBALS["db_api"]->dbh->getOne($stmt); } else {

## ## These last two patches are for compatibility with PHP safe_mode. ##

diff -rbBwu eventum-1.5/manage/check_email_settings.php eventum-1.5n/manage/check_email_settings.php --- eventum-1.5/manage/check_email_settings.php Tue Mar 1 18:23:30 2005 +++ eventum-1.5n/manage/check_email_settings.php Tue Mar 1 22:21:22 2005 @@ -27,7 +27,7 @@ // // @(#) $Id: s.check_email_settings.php 1.6 04/01/19 15:19:26-00:00 jpradomaia $ // -set_time_limit(0); +@set_time_limit(0); include_once("../config.inc.php"); include_once(APP_INC_PATH . "class.template.php"); include_once(APP_INC_PATH . "class.auth.php");

diff -rbBwu eventum-1.5/manage/projects.php eventum-1.5n/manage/projects.php --- eventum-1.5/manage/projects.php Tue Mar 1 18:23:30 2005 +++ eventum-1.5n/manage/projects.php Tue Mar 1 22:21:49 2005 @@ -27,7 +27,7 @@ // // @(#) $Id: s.projects.php 1.9 03/08/12 20:02:58-00:00 jpm $ // -set_time_limit(0); +@set_time_limit(0); include_once("../config.inc.php"); include_once(APP_INC_PATH . "class.template.php"); include_once(APP_INC_PATH . "class.auth.php");