I get the following error when trying to run the upgrade script

Query failed with message 'Data truncated for column 'user_filter' at row 1' 
Error params: 
File: NULL  
Line: NULL  
Sql: alter table `acx_time_reports` change column `user_filter` `user_filter` enum('anybody', 'logged_user', 'company', 'selected') not null default 'anybody' after `is_default`  
Error number: 1265  
Error message: Data truncated for column 'user_filter' at row 1  
Backtrace: 
#0  Error->__construct(Query failed with message 'Data truncated for column 'user_filter' at row 1', 1) called at [C:\server\www\collab\angie\classes\errors\DBQueryError.class.php:57]
#1  DBQueryError->__construct(alter table `acx_time_reports` change column `user_filter` `user_filter` enum('anybody', 'logged_user', 'company', 'selected') not null default 'anybody' after `is_default`, 1265, Data truncated for column 'user_filter' at row 1) called at [C:\server\www\collab\angie\classes\database\DBConnection.class.php:240]
#2  DBConnection->prepareAndExecute(alter table `acx_time_reports` change column `user_filter` `user_filter` enum('anybody', 'logged_user', 'company', 'selected') not null default 'anybody' after `is_default`, ) called at [C:\server\www\collab\angie\classes\database\DBConnection.class.php:90]
#3  DBConnection->execute(alter table `acx_time_reports` change column `user_filter` `user_filter` enum('anybody', 'logged_user', 'company', 'selected') not null default 'anybody' after `is_default`) called at [C:\server\www\collab\public\upgrade\scripts\Upgrade_2.class.php:53]
#4  Upgrade_2->updateExistingTables() called at [C:\server\www\collab\public\upgrade\execute.php:63]
 
Autoglobal varibles: 
$_GET: empty  
$_POST: array(3) {
  ["what"]=>
  string(12) "execute_step"
  ["group"]=>
  string(9) "1.1-1.1.2"
  ["step"]=>
  string(20) "updateExistingTables"
}
 
$_COOKIE: array(3) {
  ["__utma"]=>
  string(64) "265406158.1014781309204401000.1211478524.1211478524.1211478524.1"
  ["__utmz"]=>
  string(70) "265406158.1211478524.1.1.utmcsr=(direct)|utmccn=(direct)|utmcmd=(none)"
  ["PHPSESSID"]=>
  string(26) "1iim6nva6pp9aum30n2e0fhu65"
}
 
$_SESSION: array(2) {
  ["project_object_views"]=>
  array(0) {
  }
  ["ActiveCollab_sid"]=>
  string(36) "JYzoGE3ehXzHedD0.20312800-1213317645"

Hey,
I'm having the same problem trying to upgrade. I changed the MySQL strict mode as suggested but got the same error when I tried to run the upgrade again. Do you have any other suggestions on how to fix or get around this problem?

thanks

I verified that the mode had changed and restarted MySQL. I'll reboot the whole server and see if that fixes it. Thanks