Bug #15971
closed
Extensions which use function pi_getPidList() from class tslib_pibase do not work with DBAL
0%
Description
The function pi_getPidList() from class tslib_pibase which is used in some extensions (e.g. tt_news) to get the list of pids where to search for records is always returning 0 when DBAL is used. Therefore an extension which uses this function will never display any records.
TYPO3 4.0 cvs with dbal enabled
Postgres 8.3.1
PHP 5.1.2
(issue imported from #M3104)
Updated by Karsten Dambekalns over 18 years ago
I tried it, and with recursive starting point this ideed fails. I debugges it as far as this: the db (PostgreSQL 7.4) returns only a numeric key, although numeric and associative keys are requested. In the following sql_fetch_assoc() call the numeric keys get dumped and the query seemingly fails...
I have to debug this further...
Updated by Karsten Dambekalns over 18 years ago
Thanks to Christian Welzel for bringing some light into the issue. He found that the sue of admin_get_keys() in tt_news causes this, as somewhere in that method the fetch mode is set to ADODB_FETCH_NUM. Hooray and thanks for that info.
I tracked it down to a bug in the ADOdb extension maintained by me, and will upload a fixed version later today.
Updated by Karsten Dambekalns over 18 years ago
Please check if the issue is resolved with version 4.81.0 of the ADOdb extension. Thanks.
Updated by Rupert Germann over 18 years ago
with version 4.81.0 pi_getPidList() returns the correct values.