MantisBT: master f44b1e91

Diff Back to Repository
Author Committer Branch Timestamp Parent
dregad dregad master 2016-02-27 04:24 master e18a9c23
Affected Issues  0016834: Can't remove category because of CLOB in the query
Changeset

Fix deletion of default category on MSSQL/Oracle

$f_category_id is of type int, but the config table's config_id column
is defined as VARCHAR(64). This causes a type mismatch on some RDBMS:

  • Oracle (ORA-00932: inconsistent data types: expected -, found CLOB)
  • MSSQL

Problem resolved by casting the variable to string when passing it to
db_query().

Fixes #16384
mod - manage_proj_cat_delete.php Diff File