View Issue Details

WikiJump to Notes
IDProjectCategoryView StatusDate SubmittedLast Update
0016832mantisbtdb oraclepublic2014-01-13 08:382014-05-16 15:01
Reporterzrybola Assigned Todregad  
PrioritynormalSeverityminorReproducibilityhave not tried
Status closedResolutionduplicate 
Product Version1.2.15 
Summary0016832: Cannot insert NULL values
Description

We have installed Mantis 1.2.15 on the Oracle database. However, I came across a problem when trying to save a new ticket without filling in the steps to reproduce and additional information.

The problem is, that I can't insert NULL value for these attributes to the database. Oracle evaluates empty strings '' as NULL, however, the create scripts generated during the installation create these database columns as NOT NULL.

The same problem appears when saving the "create issue" event to the history table, where you don't have field_name, old_value and new_value set for this event.

TagsNo tags attached.

Relationships

Relationship GraphDependency Graph
duplicate of 0013227 closeddregad Oracle DB support multiple issues 

Activities

grangeway

grangeway

2014-01-13 12:07

reporter   ~0039041

MSSQL/Oracle support is known broken in the 1.2 releases.

We plan on replacing the database API after the 1.3 release to try to provide proven support for other database platforms moving forward.

For now, I'd suggest for best results using mantis with MySQL
dregad

dregad

2014-01-13 19:47

developer   ~0039043

There are many known issues with Oracle. Please refer to 0013227; there you'll find a link to an unofficial branch fixing some of the issues for Mantis 1.2.
grangeway

grangeway

2014-05-16 15:01

reporter   ~0040461

MantisBT currently supports Mysql and has support for other database engines.

The support for other databases is known to be problematic.

Having implemented the current database layer into Mantis 10 years ago, I'm currently working on replacing the current layer.

If you are interested in using Mantis with non-mysql databases - for example, Oracle, PGSQL or MSSQL, and would be willing to help out testing the new database layer, please drop me an email at paul@mantisforge.org

In the meantime, I'd advise running Mantis with Mysql Only to avoid issues.

Thanks
Paul