aC forum: Corporate v1.1 to 1.1.2

Post #6 by designica

designica — Wed, 18 Jun 2008 20:40:56 CDT

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

Post #5 by IDEO

IDEO — Tue, 17 Jun 2008 15:24:53 CDT

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

Post #4 by Ilija Studen

Ilija Studen — Tue, 17 Jun 2008 14:56:12 CDT

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.

Post #3 by IDEO

IDEO — Tue, 17 Jun 2008 14:40:14 CDT

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

Post #2 by Ilija Studen

Ilija Studen — Fri, 13 Jun 2008 01:14:02 CDT

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.

Post #1 by designica

designica — Thu, 12 Jun 2008 19:49:26 CDT

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"