0014399: Lack of detailed error message during schema creation - MantisBT

ID	Project	Category	View Status	Date Submitted	Last Update

0014399	mantisbt	installation	public	2012-06-20 08:06	2014-09-23 18:05

Reporter	dregad	Assigned To	dregad
Priority	normal	Severity	major	Reproducibility	always
Status	closed	Resolution	fixed
Product Version	1.2.12
Target Version	1.2.12	Fixed in Version	1.2.12

Summary	0014399: Lack of detailed error message during schema creation
Description	During MantisBT installation, when a schema upgrade step includes several SQL statements (as generated by ADOdb), a detailed error message is only reported the problem occurs while executing the last statement. In other cases (e.g. error on 1st statement), failure is properly detected by the installer, but there are no details on the error.
Tags	No tags attached.

dregad 2012-06-20 13:40 developer ~0032129	Problem fixed by calling ADOdb ExecuteSQLArray( $sqlarray, false ) instead of ExecuteSQLArray( $sqlarray ) which stops processing after first error.

RobertPattinson 2012-06-22 05:50 viewer ~0032145	Calling ExecuteSQLArray() with the 2nd param = false forces the function to return the error message on first failure instead of continuing with the next statement. thanks robert http://www.fedoraproject.org/wiki/User:Cyberworldukltd

dregad 2012-06-22 06:07 developer ~0032146	What is your point ?

grangeway 2013-04-05 17:56 reporter ~0036162	Marking as 'acknowledged' not resolved/closed to track that change gets ported to master-2.0.x branch

MantisBT: master 1ee24f63 2012-06-20 06:33 dregad Details Diff	Fix Lack of detailed error message during schema creation During MantisBT installation, when a schema upgrade step includes several SQL statements (as generated by ADOdb), a detailed error message was only reported the problem occurs while executing the last statement. Calling ExecuteSQLArray() with the 2nd param = false forces the function to return the error message on first failure instead of continuing with the next statement. Fixes 0014399	Affected Issues 0014399
	mod - admin/install.php	Diff File
MantisBT: master-1.2.x e94e0a8a 2012-06-20 06:33 dregad Details Diff	Fix Lack of detailed error message during schema creation During MantisBT installation, when a schema upgrade step includes several SQL statements (as generated by ADOdb), a detailed error message was only reported the problem occurs while executing the last statement. Calling ExecuteSQLArray() with the 2nd param = false forces the function to return the error message on first failure instead of continuing with the next statement. Fixes 0014399	Affected Issues 0014399
	mod - admin/install.php	Diff File

related to	0015721	closed	grangeway	Functionality to consider porting to master-2.0.x
related to	0009720	closed	dregad	Error upgrading from 1.1.x (PostgreSQL)