0010489: Some upgrades don't work due to DESCRIBE

ID	Project	Category	View Status	Date Submitted	Last Update
0010489	mantisbt	db oracle	public	2009-05-14 11:37	2014-05-16 15:01

Reporter	msierszen	Assigned To	grangeway
Priority	normal	Severity	minor	Reproducibility	always
Status	closed	Resolution	no change required
Product Version	1.1.7

Summary	0010489: Some upgrades don't work due to DESCRIBE
Description	The "DESCRIBE ..." query is not working with oracle. Solution: Use "SELECT * FROM USER_TAB_COLUMNS ..." instead. diff -rupN mantisbt-1.1.7/core/adodb/drivers/adodb-oci8.inc.php mantisbt-1.1.7_zce/core/adodb/drivers/adodb-oci8.inc.php --- mantisbt-1.1.7/core/adodb/drivers/adodb-oci8.inc.php 2009-04-20 09:14:00.000000000 +0200 +++ mantisbt-1.1.7_zce/core/adodb/drivers/adodb-oci8.inc.php 2009-05-13 11:24:18.163250000 +0200 @@ -977,6 +987,13 @@ NATSOFT.DOMAIN = */ function _query($sql,$inputarr) { $sql = preg_replace('/DESCRIBE (.)/i', 'SELECT FROM USER_TAB_COLUMNS WHERE table_name = UPPER(\'$1\')', $sql); `if (is_array($sql)) { // is prepared sql $stmt = $sql[1];`
Tags	No tags attached.

thraxisp 2009-05-14 20:22 reporter ~0021824	The "upgrade.php" script is only used to upgrade from pre1.0.0 to 1.0.0. It is no longer used.

grangeway 2009-05-23 09:49 reporter ~0021884	DESCRIBE is not used in queries within mantis in latest releases.

grangeway 2014-05-16 15:01 reporter ~0040494	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 Paul