Hello,

in one of our Wikkas there occured a change in the behavior of this action: the wanted pages aren't listed anymore. There's only one page name listed and for the number of links Wikka outputs the sum of __all__ missing links. See here: http://www.kindred.de/wiki/wikka.php?wakka=WantedPages

There should be about 200 wanted pages listed. Is this problem known? Or -far more important- does anyone know how to fix this? We know that it __has__ some time ago worked as expected ...

Masin, please open a ticket in the trac for it, including the version (wikka, php) you use.

The lines involved look like this in my 'working' install (1.1.6.2)

../../actions$ grep 'LoadPagesLinkingTo' *
backlinks.php:if ($pages = $this->LoadPagesLinkingTo($this->getPageTag())) {
wantedpages.php: if ($pages = $this->LoadPagesLinkingTo($linking_to))

../../actions$ grep 'LoadWantedPages' *
wantedpages.php: if ($pages = $this->LoadWantedPages())


........./libs$ grep 'LoadPagesLinkingTo' *
Wakka.class.php: function LoadPagesLinkingTo($tag) { return $this->LoadAll("select from_tag as tag from ".$this->config["table_prefix"]."links where to_tag = '".mysql_real_escape_string($tag)."' order by tag"); }

../../libs$ grep 'LoadWantedPages' *
Wakka.class.php: function LoadWantedPages() { return $this->LoadAll("select distinct ".$this->config["table_prefix"]."links.to_tag as tag,count(".$this->config["table_prefix"]."links.from_tag) as count from ".$this->config["table_prefix"]."links left join ".$this->config["table_prefix"]."pages on ".$this->config["table_prefix"]."links.to_tag = ".$this->config["table_prefix"]."pages.tag where ".$this->config["table_prefix"]."pages.tag is NULL group by tag order by count desc"); }
Wakka.class.php: if ($pages = $this->LoadWantedPages())

The solution for ticket #346 is the patch attached in #309. It was just a MySQL upgrade three weeks ago. But thanks nonetheless :-)

I've closed #346 as a duplicate accordingly.