View Issue Details
ID | Project | Category | View Status | Date Submitted | Last Update |
---|---|---|---|---|---|
0020365 | mantisbt | db mysql | public | 2015-12-08 11:18 | 2016-06-12 00:43 |
Reporter | dregad | Assigned To | dregad | ||
Priority | normal | Severity | major | Reproducibility | always |
Status | closed | Resolution | fixed | ||
Product Version | 1.3.0-rc.1 | ||||
Target Version | 1.3.0-rc.2 | Fixed in Version | 1.3.0-rc.2 | ||
Summary | 0020365: SYSTEM NOTICE: Undefined index with mysqli driver | ||||
Description | The issue was initially reported by atrol in 0020357 When running admin checks with Verbose messges turned on, the page displays errors like: SYSTEM NOTICE: Undefined index: comment | ||||
Tags | No tags attached. | ||||
I have the impression that this is an issue with the underlying ADOdb library - need to test. It seems that the recordset's fields' case is not properly set to lowercase as it should: In check_database_inc.php, the following query is executed: 'SHOW TABLE STATUS'. |
|
Just want to be sure that you did notice also this special treatment in check_database_inc.php |
|
Thanks, I know about that one. The problem is that these variables are used as index for the rows being retrieved further down, <pre> and db_fetch_array() is returning the first row like this <pre>Array and the subsequent ones like this <pre>Array It looks like the ADOdb ADORecordSet::MoveNext() method is not properly handling the field names' case in associative fetch mode. This issue also exists with ADOdb 5.19. Further research is needed, but I don't have time to do it now. |
|
Confirmed ADOdb issue https://github.com/ADOdb/ADOdb/issues/167. The problem is not as critical as I thought initially, because in our case it only affects queries on the MySQL information_schema. Mantis schema queries are not affected, because all our column names are in lowercase. |
|
ADOdb 5.20.2 which includes the required fix is expected to be released next week. |
|
MantisBT: master 0b972949 2015-12-26 13:32 Details Diff |
Update ADOdb library to 5.20.2 This is a prerequisite to fix issue 0020365. |
Affected Issues 0020365, 0020467 |
|
mod - library/README.md | Diff File | ||
mod - library/adodb | Diff File | ||
MantisBT: master b5c53a31 2015-12-26 13:39 Details Diff |
Admin check: fix system notice with mysql drivers With ADOdb 5.20.2, the mysql and mysqli drivers properly handle associative fetch mode case, and consistently return lowercase column names as per ADODB_ASSOC_CASE setting in database API. We therefore no longer need to differentiate processing between the 2 drivers. Minimum ADOdb version has been bumped accordingly. Fixes 0020365 |
Affected Issues 0020365 |
|
mod - admin/check/check_database_inc.php | Diff File | ||
mod - core/constant_inc.php | Diff File |