[Phpwiki-talk] replaced INNER JOIN with LEFT JOIN - still WikiFatalError

[Tara S. <te...@cl...>]

I replaced INNER JOIN by LEFT JOIN, as suggested, and got the following=20
error:

Loading up virgin wiki

lib/WikiDB/backend/PearDB.php:653: Fatal[256]: wikidb_backend_mysql:=20
fatal database error

     * DB Error: syntax error<\li>
     * (INSERT INTO recent (id, latestversion, latestmajor, latestminor)=20
SELECT id, MAX(version), MAX(CASE WHEN minor_edit=3D0 THEN version END),=20
MAX(CASE WHEN minor_edit<>0 THEN version END) FROM version WHERE id=3D1=20
GROUP BY id [nativecode=3DYou have an error in your SQL syntax near 'WHEN=
=20
minor_edit=3D0 THEN version END), MAX(CASE WHEN minor_edit<>0 THEN versio=
n=20
EN' at line 1])<\li>
     * <\li>

lib/WikiDB/backend/PearDB.php:52: Notice[8]: Undefined property: _lock_co=
unt

lib/WikiDB/backend/PearDB.php:625: Notice[8]: Undefined property:=20
_lock_count

WikiFatalError

lib/WikiDB/backend/PearDB.php:653: Fatal[256]: wikidb_backend_mysql:=20
fatal database error

     * DB Error: syntax error<\li>
     * (INSERT INTO recent (id, latestversion, latestmajor, latestminor)=20
SELECT id, MAX(version), MAX(CASE WHEN minor_edit=3D0 THEN version END),=20
MAX(CASE WHEN minor_edit<>0 THEN version END) FROM version WHERE id=3D1=20
GROUP BY id [nativecode=3DYou have an error in your SQL syntax near 'WHEN=
=20
minor_edit=3D0 THEN version END), MAX(CASE WHEN minor_edit<>0 THEN versio=
n=20
EN' at line 1])<\li>
     * <\li>


http://tara.scdi.org/newwiki/ if you want to see the disaster. Any=20
suggestions?


--=20
Je r=E9ponds au mieux de mes connaissances
Climb to the Stars! - http://climbtothestars.org/
no tables: http://climbtothestars.org/coding/tableless/
Pompeurs Associ=E9s - http://pompage.net/