#562 WantedPages query is not valid Oracle syntax

Database
closed
5
2012-10-11
2006-11-20
C.J.
No

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.

Discussion

  • Reini Urban

    Reini Urban - 2006-12-02

    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).

     

Log in to post a comment.

Get latest updates about Open Source Projects, Conferences and News.

Sign up for the SourceForge newsletter:





No, thanks