obmsch
2021-03-08 19:14
reporter
~0065205
Last edited: 2021-03-09 02:31
|
@dregad Did some Tests on 2.24.5 (with ADOdb 5.21) for mssqlnative (SQLServer 2016, driver 5.9.0)
1) All views are Ok.
2) Add Issue (all required fields filled)
Message: [Microsoft][ODBC Driver 17 for SQL Server][SQL Server]Cannot insert the value NULL into column 'bug_text_id', table 'MantisBT.dbo.mantis_bug_table'; column does not allow nulls. INSERT fails.
Stack trace
0 M:\www.root\MantisBT\core\classes\DbQuery.class.php 293 - - trigger_error <string>'401', <integer>256
1 M:\www.root\MantisBT\core\classes\DbQuery.class.php 788 DbQuery -> db_execute <integer>-1, <integer>-1
2 M:\www.root\MantisBT\core\database_api.php 313 DbQuery :: compat_db_query <string>'INSERT INTO {bug} ( project_id,reporter_id, handler_id,duplicate_id, priority,severity, reproducibility,status, resolution,projection, category_id,date_submitted, last_updated,eta, bug_text_id, os, os_build,platform, version,build, profile_id, summary, view_state, sponsorship_total, sticky, fixed_in_version, target_version, due_date ) VALUES ( ?,?,?,?, ?,?,?,?, ?,?,?,?, ?,?,?,?, ?,?,?,?, ?,?,?,?, ?,?,?,?)', <array> { [0] => 61, [1] => 3, [2] => 3, [3] => 0, [4] => 30, [5] => 50, [6] => 70, [7] => 50, [8] => 10, [9] => 10, [10] => 1, [11] => 1615244578, [12] => 1615244578, [13] => 10, [14] => NULL, [15] => 'Windows 10 Enterprise (64)', [16] => '1909, 18363.x', [17] => 'Ryzen 3700X, 32GB CBS LT 3200', [18] => '', [19] => '', [20] => 2, [21] => '123', [22] => 10, [23] => 0, [24] => 0, [25] => '', [26] => '1.1.x', [27] => 1 }, <integer>-1, <integer>-1, <boolean>true
3 M:\www.root\MantisBT\core\bug_api.php 581 - - db_query <string>'INSERT INTO {bug} ( project_id,reporter_id, handler_id,duplicate_id, priority,severity, reproducibility,status, resolution,projection, category_id,date_submitted, last_updated,eta, bug_text_id, os, os_build,platform, version,build, profile_id, summary, view_state, sponsorship_total, sticky, fixed_in_version, target_version, due_date ) VALUES ( ?,?,?,?, ?,?,?,?, ?,?,?,?, ?,?,?,?, ?,?,?,?, ?,?,?,?, ?,?,?,?)', <array> { [0] => 61, [1] => 3, [2] => 3, [3] => 0, [4] => 30, [5] => 50, [6] => 70, [7] => 50, [8] => 10, [9] => 10, [10] => 1, [11] => 1615244578, [12] => 1615244578, [13] => 10, [14] => NULL, [15] => 'Windows 10 Enterprise (64)', [16] => '1909, 18363.x', [17] => 'Ryzen 3700X, 32GB CBS LT 3200', [18] => '', [19] => '', [20] => 2, [21] => '123', [22] => 10, [23] => 0, [24] => 0, [25] => '', [26] => '1.1.x', [27] => 1 }
4 M:\www.root\MantisBT\core\commands\IssueAddCommand.php 346 BugData -> create -
5 M:\www.root\MantisBT\core\commands\Command.php 137 IssueAddCommand -> process -
6 M:\www.root\MantisBT\bug_report.php 256 Command -> execute -
3) Add Project Ok
4) Add Project -> SubProject
APPLICATION ERROR 0000700: Projekt „“ nicht gefunden.
Stack trace
0 M:\www.root\MantisBT\core\commands\Command.php 136 ProjectHierarchyAddCommand -> validate -
1 M:\www.root\MantisBT\manage_proj_create.php 91 Command -> execute -
5) Add Note to Issue
Message: [Microsoft][ODBC Driver 17 for SQL Server][SQL Server]Cannot insert the value NULL into column 'bugnote_text_id', table 'MantisBT.dbo.mantis_bugnote_table'; column does not allow nulls. INSERT fails.
Stack trace
0 M:\www.root\MantisBT\core\classes\DbQuery.class.php 293 - - trigger_error <string>'401', <integer>256
1 M:\www.root\MantisBT\core\classes\DbQuery.class.php 788 DbQuery -> db_execute <integer>-1, <integer>-1
2 M:\www.root\MantisBT\core\database_api.php 313 DbQuery :: compat_db_query <string>'INSERT INTO {bugnote} (bug_id, reporter_id, bugnote_text_id, view_state, date_submitted, last_modified, note_type, note_attr, time_tracking) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ? )', <array> { [0] => 827, [1] => 3, [2] => NULL, [3] => 10, [4] => 1615246171, [5] => 1615246171, [6] => 0, [7] => '', [8] => 0 }, <integer>-1, <integer>-1, <boolean>true
3 M:\www.root\MantisBT\core\bugnote_api.php 298 - - db_query <string>'INSERT INTO {bugnote} (bug_id, reporter_id, bugnote_text_id, view_state, date_submitted, last_modified, note_type, note_attr, time_tracking) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ? )', <array> { [0] => 827, [1] => 3, [2] => NULL, [3] => 10, [4] => 1615246171, [5] => 1615246171, [6] => 0, [7] => '', [8] => 0 }
4 M:\www.root\MantisBT\core\commands\IssueNoteAddCommand.php 248 - - bugnote_add <integer>827, <string>'asasdasdasdad', <string>'0:00', <boolean>false, <integer>0, <string>'', <integer>3, <boolean>false, <integer>0, <integer>0, <boolean>false, <boolean>true, <boolean>false
5 M:\www.root\MantisBT\core\commands\Command.php 137 IssueNoteAddCommand -> process -
6 M:\www.root\MantisBT\bugnote_add.php 64 Command -> execute -
Might be more. I'll check, but I doubt this is just mssql. Anything special about mysql not running into this?
BTW: 2.24.5 (with ADOdb 5.20.20) for mssqlnative (SQLServer 2016, driver 5.9.0), no problems so far.
Martin
EDIT (dregad): added markdown |
