Major issue with 'category' table using mantis 1.2.0a3?

[prabhurangan]

Dear All,

I have been using mantis 1.2.0a3, and i tried to pump my old data of mantis 1.0.0. But in earlier versions we do not have a separate 'mantis_category_table', instead we have 'mantis_project_category_table'.

Please can anyone explain the process on how the category is updated in mantis 1.2.0a3, in the following tables:

mantis_bug_table
mantis_project_table
mantis_category_table

It confuses me a lot.

Regards,
Prabhu

[vboctor]

You need to run the upgrade script. The login page should indicate that your database schema is not up to date and direct you to the upgrade script.

[prabhurangan]

@Vboctor

Thanks a lot; i have figured out my issues and solved it.

Actually my issue is, why do we need 'category_id' in 'mantis_project_table', As a particular project relies on many category.

Database design is messy i think so; in some tables it has two primary keys, and so on...

Please go through the database design and some volunteers can make some customization in database design.

If i wrong please correct me....

REgards,
Prabhu.