This error can be triggered if you are running activeCollab on MySQL in Strict SQL mode. You can find more information about this and how to turn it off here: MySQL 5 Strict Mode Issues. Please let me know if this helps.
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?
Have you restarted MySQL? Simply changing the setting does not affect running server. In the linked article there are instructions how to verify that you successfully changed the mode.
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"