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.