Re: [Phpwiki-talk] Wanted Pages SQL Problem

[William L. <le...@k2...>]

Ok, as mentioned in my other message I have a new problem. This problem 
came up when upgrading from MySQL 4.1.18 to 5.0.21. WantedPages now 
seems to be broken. Anyone should be able to see it at 
http://www.k2wrpg.org/wiki/index.php/WantedPages. If you do check it out 
you will see that it bombs out with this error:

lib\WikiDB\backend\PearDB.php (In template 'body' < 'html'):1027: Error: 
wikidb_backend_peardb_mysql: fatal database error

    * DB Error: no such field
    * (SELECT page.pagename,linked.pagename as wantedfrom FROM link,page
      as linked LEFT JOIN page ON (link.linkto=page.id) LEFT JOIN
      nonempty ON (link.linkto=nonempty.id) WHERE ISNULL(nonempty.id)
      AND linked.id=link.linkfrom AND linked.pagename NOT IN
      ('PgsrcTranslation','InterWikiMap') LIMIT 0, 300 [nativecode=1054
      ** Unknown column 'link.linkto' in 'on clause'])

Now I know just enough SQL to see that this is a really complicated 
join, and that I don't completely understand what the problem is. What 
really confuses me is the Unknown column 'link.linkto' because linkto 
certainly is a column of link,

I really would like to help fix this because WantedPages is one of my 
favorite pages, and I use it frequently to find stuff that needs to be 
done.

Thanks!
-Will