Re: [Phpwiki-talk] PearDB BackLinks problem in old phpwiki postnuke install

[Daniel S. <dansut@OpenSTA.org>]

> > This is a weird one - not even sure when it started happening but
> > its obviously not just my installation as doing a search on the
> > key phrases in the error message:
> >   modules/phpWiki/lib/WikiDB/backend/PearDB.php:667: Fatal[256]:
> >       wikidb_backend_mysql: fatal database error
> >     * DB Error: mismatch
> >     * (SELECT linker.* FROM nuke_phpwiki_link, nuke_phpwiki_page AS
> > linker, nuke_phpwiki_page AS linkee WHERE linkfrom=linker.id AND
> > linkto=linkee.id AND linkee.pagename='CYRANO' ORDER BY
> > linker.pagename)
> >
> > Brings up lots of other similary broken Wikis - including mine:
> >   http://portal.opensta.org/faq.php
> >
> > Everything else seems to be working OK - the problem only shows
> > itself when using the BackLinks plugin, but may actually happen
> > at other times as well.
> >
> > The bit of searching I've done so far suggests that something
> > changed in PearDB/prepare(), so a PHP upgrade probably broke it.

Reini Urban wrote:
> Hmm, your error seems to be mysql related.
> Pear::DB mismatch is error -7 (see pear/DB.php:45)
> See http://www.phpmag.net/itr/online_artikel/psecom,id,585,nodeid,114.html
> that this is really DB_ERROR_NOSUCHFIELD.

I thought that was the case - but there's no error in the SQL, I can
run this directly on my DB and it works fine.

The main reason I think changes in Pear::DB were at fault was this
exchange:
  http://www.phpbuilder.com/board/archive/index.php/t-10296881.html

> Which phpwiki version and Pear::DB version do you use?

Good questions ;-)  It was the PN module produced by Lawrence Akka
and available here:  http://sourceforge.net/projects/pn-modules/
But I believe the previous admin of this site made a few "fixes"...
Lawrence's module was based on 1.3.2 but updated from CVS in Dec2001

Pear::DB reported to be 1.6.2 - just updated it to 1.7.6 on a local
test machine and still get the same error.

I've disabled all the main uses of BackLinks in my Wiki for the time
being but left an error promoting page here:
  http://portal.opensta.org/faq.php?topic=BackLinks

Thanks for your response Reini - I didn't really want to bug you with
issues in ancient history, I was just hoping someone would have
already solved this issue.

Cheers
/dan
-- 
Daniel Sutcliffe <DanSut@OpenSTA.org>
  OpenSTA part-time caretaker - http://OpenSTA.org/