View Issue Details

WikiJump to Notes
IDProjectCategoryView StatusDate SubmittedLast Update
0007247mantisbtdb oraclepublic2006-06-30 06:552017-01-31 04:05
Reporterrulaan Assigned Toatrol  
PrioritynormalSeveritymajorReproducibilityalways
Status closedResolutionno change required 
Summary0007247: Not possible to create bug reports
Description

APPLICATION ERROR 0000401
Database query failed. Error received from database was 0001400: ORA-01400: cannot insert NULL into ("MANTIS"."MTS_BUG_TEXT"."STEPS_TO_REPRODUCE") for the query: INSERT INTO mts_bug_text
( description, steps_to_reproduce, additional_information )
VALUES
( '2', '',
'' )

and

APPLICATION ERROR 0000401
Database query failed. Error received from database was 0001400: ORA-01400: cannot insert NULL into ("MANTIS"."MTS_BUG_TEXT"."ADDITIONAL_INFORMATION") for the query: INSERT INTO mts_bug_text
( description, steps_to_reproduce, additional_information )
VALUES
( '2', '',
'' )

Additional Information

using Mantis 1.0.3 / Apache 2.0.58 / PHP 5.1.4 / Oracle DB 9.0.2.7 / Win2k3

Apparently there is no data for field STEPS_TO_REPRODUCE, but the column is defined not null (as per schema.php).

field ADDITIONAL_INFORMATION is optional, but the column is defined not null (as per schema.php).

Solved for now by removing not null constraints on both fields in the DB

TagsNo tags attached.

Activities

rulaan

rulaan

2006-06-30 07:30

reporter   ~0013057

Also not possible to create global profile:

APPLICATION ERROR 0000401
Database query failed. Error received from database was 0001400: ORA-01400: cannot insert NULL into ("MANTIS"."MTS_USER_PROFILE"."DESCRIPTION") for the query: INSERT INTO mts_user_profile
( user_id, platform, os, os_build, description )
VALUES
( '0', '1', '2', '3', '' )

Solved for now by removing not null constraints on field in the DB
rulaan

rulaan

2006-06-30 07:44

reporter   ~0013058

Also not possible to create project version:

APPLICATION ERROR 0000401
Database query failed. Error received from database was 0001400: ORA-01400: cannot insert NULL into ("MANTIS"."MTS_PROJECT_VERSION"."DESCRIPTION") for the query: INSERT INTO mts_project_version
( project_id, version, date_order, description, released )
VALUES
( '2', '1.0.1', TO_DATE('2006-06-30, 01:48:30 PM','RRRR-MM-DD, HH:MI:SS AM'), '', '1' )

Solved for now by removing not null constraints on field in the DB
rulaan

rulaan

2006-06-30 07:44

reporter   ~0013059

Add sub project

Database query failed. Error received from database was 0001400: ORA-01400: cannot insert NULL into ("MANTIS"."MTS_PROJECT"."DESCRIPTION") for the query: INSERT INTO mts_project
( name, status, enabled, view_state, file_path, description )
VALUES
( 'RFC030', '10', '1', '10', '', '' )
grangeway

grangeway

2014-05-16 15:01

reporter   ~0040497

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
atrol

atrol

2014-06-16 15:34

developer   ~0040812

Reminder sent to: dregad, grangeway

Not sure, maybe this issue should be moved back to project mantis.
If so, grangeway could make a copy of it in project "Track DBAL replacement"
atrol

atrol

2017-01-18 10:28

developer   ~0055205

We are resolving this issue as "no change required", because it was reported against an old version of MantisBT which is no longer supported.

We recommend that you upgrade to the latest stable version [1]; if after doing so the problem still exists, do not hesitate to reopen the issue.

[1] http://www.mantisbt.org/download.php