View Issue Details

IDProjectCategoryView StatusLast Update
0017333mantisbtdb oraclepublic2014-12-08 02:07
Reporterdregad Assigned Todregad  
PrioritynormalSeverityminorReproducibilityalways
Status closedResolutionfixed 
Product Version1.3.0dev 
Target Version1.3.0-beta.1 
Summary0017333: Adding a new version fails with ORA-01400
Description

When trying to add a new version in the manage project page with Oracle, the operation fails

APPLICATION ERROR 401
Database query failed. Error received from database was 1400: ORA-01400: cannot insert NULL into ("MANTIS"."M_PROJECT_VERSION"."OBSOLETE") for the query: INSERT INTO m_project_version (project_id, version, date_order, released, obsolete) values (:0, :1, :2, :3, :4).

This used to work...

TagsNo tags attached.

Activities

dregad

dregad

2014-05-13 05:18

developer   ~0040271

This is indeed a regression, introduced by commit a80f447687722b52160d00c96c21a5be5f4329e1 which removed the call to db_prepare_bool().

atrol

atrol

2014-06-05 04:18

developer   ~0040745

Moved back to project mantis as
a) there are related changesets for master (1.3.x) in it
b) dregad is assigned

@grangeway, please make a copy of it if you need it in project "Track DBAL replacement"

grangeway

grangeway

2014-06-08 05:36

reporter   ~0040756

Issue cloned back into Track DBAL replacement as requested.

My advice to end users is still to wait on upgrading to 1.3 for the new db layer which Victor has said we can do a release of within a month of 1.3

Paul

Related Changesets

MantisBT: master a80f4476

2013-10-14 15:27

Paul Richards


Details Diff
Further backports of db_int*/phpdoc* Affected Issues
0017333, 0025470
mod - admin/install.php Diff File
mod - core/print_api.php Diff File
mod - core/profile_api.php Diff File
mod - core/project_hierarchy_api.php Diff File
mod - core/relationship_api.php Diff File
mod - core/string_api.php Diff File
mod - core/summary_api.php Diff File
mod - core/tag_api.php Diff File
mod - core/tokens_api.php Diff File
mod - core/user_api.php Diff File
mod - core/user_pref_api.php Diff File
mod - core/utility_api.php Diff File
mod - core/version_api.php Diff File
mod - core/wiki_api.php Diff File

MantisBT: master 1a444345

2014-05-13 01:30

dregad


Details Diff
Consistently use db_prepare_bool() for boolean columns

In Version API, the released column was treated as an integer, despite
the fact that it's defined as 'L' in the schema. This can cause problems
with PostgreSQL.

Also fixes 0017333, Oracle throwed an ORA-01400 error when adding a new
version (regression caused by a80f447687722b52160d00c96c21a5be5f4329e1,
which removed the call to db_prepare_bool()).
Affected Issues
0017333
mod - core/version_api.php Diff File