Re: [Phpwiki-talk] Wanted Pages SQL Problem

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

How did you fix it?
Reverting back to mysql-4.1.18 ?

2006/5/7, William Leader <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=3Dpage.id) LEFT JOIN
>       nonempty ON (link.linkto=3Dnonempty.id) WHERE ISNULL(nonempty.id)
>       AND linked.id=3Dlink.linkfrom AND linked.pagename NOT IN
>       ('PgsrcTranslation','InterWikiMap') LIMIT 0, 300 [nativecode=3D1054
>       ** 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.
--
Reini Urban
http://phpwiki.org/
http://spacemovie.mur.at/   http://helsinki.at/