#562 WantedPages query is not valid Oracle syntax

[C.J.]

When loading http://localhost/phpwiki-1.3.12p3/index.php/WantedPages using an Oracle DB, this error is displayed:

lib/WikiDB/backend/PearDB.php (In template 'body' < 'html'):1034: Error: WikiDB_backend_PearDB_oci8: fatal database error

* DB Error: unknown error
* (SELECT * FROM (SELECT p.pagename, pp.pagename as wantedfrom FROM phpwiki_page p JOIN phpwiki_link linked LEFT JOIN phpwiki_page pp ON linked.linkto = pp.id LEFT JOIN phpwiki_nonempty ne ON linked.linkto = ne.id WHERE ne.id is NULL AND p.id = linked.linkfrom AND pp.pagename NOT IN ('PgsrcTranslation','InterWikiMap')) WHERE NULL = NULL [nativecode=ORA-00905: missing keyword])

Two problems: (i) The nested query doesn't parse in Oracle. (ii) the NULL = NULL clause always returns failure and so 0 rows are returned.

[Reini Urban]

Logged In: YES
user_id=13755
Originator: NO

This is clearly a pear error in oci8.php, not related to phpwiki.
See modifyLimitQuery().
Looks like we should disallow PearDB altogether for oci8.

[SourceForge Robot]

Logged In: YES
user_id=1312539
Originator: NO

This Tracker item was closed automatically by the system. It was
previously set to a Pending status, and the original submitter
did not respond within 14 days (the time period specified by
the administrator of this Tracker).