View Issue Details
|ID||Project||Category||View Status||Date Submitted||Last Update|
|0009314||mantisbt||db mssql||public||2008-06-30 05:43||2014-12-08 00:34|
|Platform||Windows||OS||Windows Server||OS Version||2003|
|Target Version||1.3.0-beta.1||Fixed in Version||1.3.0-beta.1|
|Summary||0009314: ADODB GetRowAssoc does not work|
I have no idea why this does not work. Is it a php 5.2.6 problem? Or a bug in ADODB? Or something to do with MSSQL?
The wrong result is an array numberd from 0 to n-1 with no values
|Steps To Reproduce|
Just run mantis using a MSSQL database
No problems with the same configuration in mantis 1.1.1
using MSSQL 2000
mmm, we are not upstream for ADODB but this looks like a bug in their code.
Am I missing something or this should be reported upstream?
I don't know. Just letting you know mantis does not work with the code it supplies
If our code is not working, we are supposed to fix it. If other people code is not working, they should fix it.
Assuming the GetRowAssoc() function is in the ADODB tree, this need to be reported (and fixed) upstream.
Please add here a link to your bug report so we can track the status of the issue, and update our code when they do a new release fixing this.
I understand that. But I also understand that mantis won't work for MSSQL in the current state. That, I think, is also a problem for mantis.
Reported here: http://phplens.com/lens/lensforum/msgs.php?id=17539
Yeah, that's why I'm not closing this straight away :)
If you fancy helping further, it would be nice to test their latest release and see if they already solved the issue.
Still no answer from the ADODB people
Found same problem with Oracle. LordLarry's correction would not work as we need to change the case of the array keys, so I put a solution on the ticket LordLarry opened in ADODB.
1.3.x will include a new PDO layer - so will not be affected by the adodb issue
Reopened, the issue is not fixed in master branch (1.3.x) at the
Update from upstream http://phplens.com/lens/lensforum/msgs.php?id=17539
Topic: Re:ADODB GetRowAssoc does not work with MSSQL
Fixed in AdoDB 5.17
GetRowAssoc is still an issue for Oracle even with latest version of AdoDB 5.18. This is due to MantisBT defaulting to ADODB_FETCH_ASSOC fetch mode, and the fact that Oracle returns uppercase column names in the recordset.
I have submitted a patch  upstream . Until this gets implemented, we can probably work around the issue by setting ADODB_FETCH_MODE = ADODB_FETCH_NUM for Oracle in db_connect().
Changed relation to 0013713 from parent/child to related, since there is a workaround possible by changing MantisBT code we don't need to set a hard dependency to have this issue fixed upstream (although we'd get better performance with the fix)
Note - to-date, there is no sign of a new ADOdb release coming out, John Lim has been silent since end of 2012...
|2008-06-30 05:43||LordLarry||New Issue|
|2008-06-30 05:43||LordLarry||Note Added: 0018228|
|2008-06-30 08:21||LordLarry||Note Added: 0018233|
|2008-06-30 11:24||vboctor||Tag Attached: patch|
|2008-07-03 09:09||giallu||Note Added: 0018287|
|2008-07-05 18:22||vboctor||Tag Attached: adodb|
|2008-07-15 15:42||grangeway||Status||new => assigned|
|2008-07-15 15:42||grangeway||Assigned To||=> grangeway|
|2008-07-23 05:02||LordLarry||Note Added: 0018642|
|2008-07-24 06:11||giallu||Note Added: 0018657|
|2008-07-24 06:35||LordLarry||Note Added: 0018658|
|2008-07-24 06:51||giallu||Note Added: 0018660|
|2008-11-26 10:37||LordLarry||Note Added: 0020066|
|2010-10-25 07:58||sveyret||Note Added: 0027150|
|2012-02-05 12:02||grangeway||Note Added: 0031136|
|2012-02-05 12:02||grangeway||Status||assigned => resolved|
|2012-02-05 12:02||grangeway||Fixed in Version||=> 1.3.0-beta.1|
|2012-02-05 12:02||grangeway||Resolution||open => no change required|
|2012-03-04 02:09||vboctor||Status||resolved => closed|
|2012-03-14 17:51||atrol||Note Added: 0031460|
|2012-03-14 17:51||atrol||Status||closed => feedback|
|2012-03-14 17:51||atrol||Resolution||no change required => reopened|
|2012-03-30 04:21||dregad||Relationship added||related to 0013713|
|2012-05-14 11:16||dregad||Note Added: 0031832|
|2012-05-25 07:02||dregad||Relationship replaced||child of 0013713|
|2012-05-25 07:02||dregad||Note Added: 0031904|
|2013-01-25 09:19||dregad||Note Added: 0034910|
|2013-01-25 09:27||dregad||Assigned To||grangeway =>|
|2013-01-25 10:39||dregad||Relationship added||related to 0015426|
|2013-06-20 05:34||dregad||Relationship replaced||related to 0013713|
|2013-06-20 05:36||dregad||Note Added: 0037232|
|2013-10-17 12:28||dregad||Status||feedback => resolved|
|2013-10-17 12:28||dregad||Resolution||reopened => fixed|
|2013-10-17 12:28||dregad||Assigned To||=> dregad|
|2013-10-17 12:28||dregad||Target Version||=> 1.3.0-beta.1|
|2014-12-08 00:34||vboctor||Status||resolved => closed|