avatar designica Pro Jun 12. 2008. 7:49 pm
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"

avatar Ilija Studen Staff Jun 13. 2008. 1:14 am
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.
avatar IDEO Pro Jun 17. 2008. 2:40 pm
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
avatar Ilija Studen Staff Jun 17. 2008. 2:56 pm
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.
avatar IDEO Pro Jun 17. 2008. 3:24 pm
I verified that the mode had changed and restarted MySQL. I'll reboot the whole server and see if that fixes it. Thanks
avatar designica Pro Jun 18. 2008. 8:40 pm
Sorry for the delay.

Changing the SQL mode did fix the issue for me.

I manualy edited the MYSQL config file (my.ini) and added:
sql-mode="MYSQL40"

I restarted the MySQL windows service and that was it.

Thank you