1 message in com.mysql.lists.eventum-develPossible fix for Priority title problem
FromSent OnAttachments
Kevin Roberts28 Sep 2004 10:13 
Subject:Possible fix for Priority title problem
From:Kevin Roberts (kevi@hotmail.com)
Date:09/28/2004 10:13:31 AM
List:com.mysql.lists.eventum-devel

I think this will fix the Priority list problem. This is the problem where you are prevented from re-using a priority tile (e.g. "Low" or "Medium") if it is already defined for another project.

I compared the indexes for the table eventum_project_priority with the table eventum_project_category, and noticed they are almost identical in structure, but the Priority table indexes seem quite different. Also saw the Priorty ID was Tinyint (1) instead of Int(11).

Also noticed in the class files that Project and Prioirty logic seem identical.

I edited the structure/indexes for the Priority table to match the Project table (except for using pri_ prefix), and change pri_id to int(11), and the problem appears to be resolved. Specifically, I changed the Priority table to:

CREATE TABLE `eventum_project_priority` ( `pri_id` int(11) unsigned NOT NULL auto_increment, `pri_prj_id` int(11) unsigned NOT NULL default '0', `pri_title` varchar(64) NOT NULL default '', PRIMARY KEY (`pri_id`), UNIQUE KEY `uniq_priority` (`pri_prj_id`,`pri_title`), KEY `pri_prj_id` (`pri_prj_id`) ) TYPE=MyISAM

Regards.