View Issue Details
|ID||Project||Category||View Status||Date Submitted||Last Update|
|0028902||mantisbt||db mssql||public||2021-07-09 05:33||2023-10-31 16:32|
|Platform||SQL SERVER 2016||OS||WINDOWS SERVER||OS Version||2016|
|Target Version||2.26.0||Fixed in Version||2.26.0|
|Summary||0028902: APPLICATION ERROR 0000401 / Error MSSQL 4145 when view all bugs for 1000 projects or more|
When i want to see all bugs from all my projects, i got an error (cf. attached file).
Why BT is not using the same query pattern ?
|Tags||No tags attached.|
The problem is from an Oracle limitation in file "/core/classes/DbQuery.class.php" at "sql_in" function :
The constant "$oracle_in_limit" has its value to "1000" at line 155 :
I've modified the value to 1000000 and this fix my problem with MSSQL.
Thanks @bzi for creating the report and the analysis.
@dregad wouldn't it be better if such database special handling is treated in underlying ADOdb?
This is somewhat higher-level than what ADOdb currently does, so no small undertaking to implement.
Will this resolution fix 0024393? Application Error 401 but with Error Code -52.
That said, the offending query in this issue is not the same as the other one, so I'm not sure this would actually make a difference.