Date Fields are now Integers/Numbers

[ctownend]

Hello,

Just wondering why when creating a new Mantis database the date columns are INT or NUMBER based on your database type. It makes upgrading from an older version of Mantis very difficult. Can the datatypes be changed back manually or will this break the interface functionality.

Thanks
Chris

[atrol]

It makes upgrading from an older version of Mantis very difficult.

Difficult? Just run admin/install.php
http://www.mantisbt.org/docs/master-1.2 ... LL.UPGRADE

Can the datatypes be changed back manually or will this break the interface functionality.

This will break functionality.

[ctownend]

I should have mentioned that our old version of mantis was using mysql but we want the newer version to be running on Oracle. I have migrated the database from mysql to oracle using SQL Developer, modified the table names to meet oracle standards and updated all of the triggers. When trying to run the mantis upgrade I get an error ALTER TABLE m_bug_table ADD (due_date DATE DEFAULT null NOT NULL) ORA-01758: table must be empty to add mandatory (NOT NULL) column. I am using the latest branch of mantis for oracle.

[atrol]

I don't use Oracle with MantisBT.
There are various known issues using Oracle, have a look at http://www.mantisbt.org/bugs and filter by category "db oracle"

Maybe a better approach is to run the upgrade in MySQL before migrating to Oracle.