#291 [Clyde] Galaxia activity transition creation error

[Marc Archuleta]

In doing the CDLoan tutorial, I added the Approve Loan
-> Approved activity without a problem. After adding
this transition, I added the Approve Loan -> Rejected
transition and got the following error stack:

[ - Clyde v3-BETA - ] [ Thu Mar 24 15:36:58 2005 ]
#### USER AGENT: Mozilla/5.0 (Windows; U; Windows NT
5.1; en-US; rv:1.7.5) Gecko/20041107 Firefox/1.0
#### ACCT: ID: 2 - Login: admin - e-mail:
archuleta37@gmail.com
#### URL:
http://localhost/clyde/galaxia/admin/g_admin_activities.php/
#### REFERRER:
http://localhost/clyde/galaxia/admin/g_admin_activities.php
#### HOST: localhost
#### IP: 127.0.0.1
#### SQL: insert into
`galaxia_transitions`(`p_id`,`act_from_id`,`act_to_id`)
values('1','4','6')
#### ADODB: Errno: 1062 Message: Duplicate entry
'1-4' for key 1

}}}}}}} -> tiki_error_string(Array[7])
}}}}}}} LINE: 33,
c:\Inetpub\wwwroot\clyde\kernel\tiki_error_inc.php
}}}}}} -> tiki_error_handler(mysql, EXECUTE,
1062, Duplicate entry '1-4' for key 1, insert into
`galaxia_transitions`(`p_id`,`act_from_id`,`act_to_i...,
false, Object:ADODB_mysql)
}}}}}} LINE: 859,
c:\Inetpub\wwwroot\clyde\util\adodb\adodb.inc.php
}}}}} -> ADODB_mysql::_Execute(insert into
`galaxia_transitions`(`p_id`,`act_from_id`,`act_to_i...)
}}}}} LINE: 818,
c:\Inetpub\wwwroot\clyde\util\adodb\adodb.inc.php
}}}} -> ADODB_mysql::ADODB_mysql::Execute(insert
into
`galaxia_transitions`(`p_id`,`act_from_id`,`act_to_i...,
Array[3])
}}}} LINE: 351,
c:\Inetpub\wwwroot\clyde\kernel\TikiDB.php
}}} ->
ADODB_mysql::ADODB_mysql::TikiDB::query(insert into
`galaxia_transitions`(`p_id`,`act_from_id`,`act_to_i...,
Array[3], -1, -1, -1)
}}} LINE: 181,
c:\Inetpub\wwwroot\clyde\kernel\TikiBase.php
}} ->
ADODB_mysql::ADODB_mysql::TikiDB::ActivityManager::query(insert
into
`galaxia_transitions`(`p_id`,`act_from_id`,`act_to_i...,
Array[3])
}} LINE: 101,
c:\Inetpub\wwwroot\clyde\galaxia\src\ProcessManager\ActivityManager.php
} ->
ADODB_mysql::ADODB_mysql::TikiDB::ActivityManager::ActivityManager::add_transition(1,
4, 6)
} LINE: 227,
c:\Inetpub\wwwroot\clyde\galaxia\admin\g_admin_activities.php

as well as the following php warning:

Warning: Cannot modify header information - headers
already sent by (output started at
c:\Inetpub\wwwroot\clyde\kernel\tiki_error_inc.php:63)
in c:\Inetpub\wwwroot\clyde\kernel\TikiSystem.php on
line 246

[Marc Archuleta]

Logged In: YES
user_id=1232036

Solution to this bug: change the primary to to the second
and third columns in the table instead of the first and
second. This fix will need to be setup in any intallation
sql in TikiPro

DROP TABLE IF EXISTS `galaxia_transitions`;
CREATE TABLE `galaxia_transitions` (
`p_id` int(11) NOT NULL default '0',
`act_from_id` int(11) NOT NULL default '0',
`act_to_id` int(11) NOT NULL default '0',
PRIMARY KEY (`act_from_id`,`act_to_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

[Marc Archuleta]

Logged In: YES
user_id=1232036

updated the galaxia schema file and did a cvs commit