Login or Register

RSS IconRecent posts in this topic

avatar
designica on Jun 13. 2008. 12:49 am
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 on Jun 13. 2008. 6: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.
activeCollab team member
avatar
IDEO on Jun 17. 2008. 7: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 on Jun 17. 2008. 7: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.
activeCollab team member
avatar
IDEO on Jun 17. 2008. 8: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 on Jun 19. 2008. 1:40 am
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

RSS IconRecent posts in this topic