View Issue Details
ID | Project | Category | View Status | Date Submitted | Last Update |
---|---|---|---|---|---|
0012081 | mantisbt | db mssql | public | 2010-06-17 07:53 | 2014-09-23 18:05 |
Reporter | genius_p | Assigned To | dregad | ||
Priority | normal | Severity | major | Reproducibility | always |
Status | closed | Resolution | fixed | ||
Product Version | 1.2.1 | ||||
Target Version | 1.2.9 | Fixed in Version | 1.2.9 | ||
Summary | 0012081: call function config_set error | ||||
Description | In table mantis_config_table field Value is TEXT. SQL Server error text: "Operand type clash: int is incompatible with text"; | ||||
Additional Information | Use db_type = 'mssqlnative'. Path fixed this issue in attache. | ||||
Tags | No tags attached. | ||||
Attached Files | config_api.path (609 bytes)
--- C:/Users/Genius.COMPENG/Desktop/config_api.php �� ��� 23 14:28:34 2010 +++ //iserv/e$/Mantis/web/core/config_api.php �� �� 16 15:26:22 2010 @@ -346,7 +346,7 @@ project_id = " . db_param() . " AND user_id = " . db_param(); $t_params = Array( - $c_value, + "$c_value", $t_type, $c_access, $c_option, @@ -359,7 +359,7 @@ VALUES (" . db_param() . ', ' . db_param() . ', ' . db_param() . ', ' . db_param() . ', ' . db_param() . ',' . db_param() . ' )'; $t_params = Array( - $c_value, + "$c_value", $t_type, $c_access, $c_option, | ||||
I confirm it works. Thanks! |
|
Patch applied, thanks for the fix. |
|
Marking as 'acknowledged' not resolved/closed to track that change gets ported to master-2.0.x branch |
|
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 |
|
MantisBT: master a105985e 2012-01-02 03:58 Details Diff |
Fix SQL errors with SQL Server This commit addresses 2 occurences of SQL Server error: "Operand type clash: int is incompatible with text" which are triggered when calling the following functions: - config_set() - token_create() - token_update() This is due to the field "Value" in the relevant Mantis table being of type TEXT, while the corresponding value in the array passed in call to db_query_bound() is not a string. Thanks to genius_p for the original patch. Fixes 0012081, 0012082 |
Affected Issues 0012081, 0012082 |
|
mod - core/config_api.php | Diff File | ||
mod - core/tokens_api.php | Diff File | ||
MantisBT: master-1.2.x fa332f30 2012-01-02 03:58 Details Diff |
Fix SQL errors with SQL Server This commit addresses 2 occurences of SQL Server error: "Operand type clash: int is incompatible with text" which are triggered when calling the following functions: - config_set() - token_create() - token_update() This is due to the field "Value" in the relevant Mantis table being of type TEXT, while the corresponding value in the array passed in call to db_query_bound() is not a string. Thanks to genius_p for the original patch. Fixes 0012081, 0012082 |
Affected Issues 0012081, 0012082 |
|
mod - core/config_api.php | Diff File | ||
mod - core/tokens_api.php | Diff File |