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

[Reini U. <ru...@x-...>]

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

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.

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

> Just checking to see if anyone else has already fought this battle  and
> won - before I dive into it.

-- 
Reini Urban
http://phpwiki.org/   http://xarch.tu-graz.ac.at/home/rurban/