[Phpwiki-talk] Re: WLUG Wiki <-> phpWiki

[Matt B. <ma...@ma...>]

Hi everyone,=20


On Tue, 2005-06-21 at 22:04 +1200, Perry Lorier wrote:

> We're just about to try again and see how far we can get.  We'll be sure
> to let everyone know of our progress.

OK. My first attempt at doing this was going to take the following form

1) Install vanilla phpwiki 1.3.11_rc3
2) Export (zip dump) from current WLUG wiki
3) Import via zip dump into phpwiki 1.3.11_rc3
4) Attempt to port all our modifications / plugins forward to 1.3.11_rc3
such that they are in a state to be potentially forwarded upstream.=20

I've run into a few problems however.=20

I'm doing all of the following on a Debian Sarge system using the
packaged Apache2 and PHP4 binaries.=20

* To get phpwiki to run, I had to modify my include path to point
directly to the PEAR dir inside the phpwiki source. Not doing this
caused an error about a redeclared DB class, presumably a conflict
between my system PEAR and phpwiki's PEAR. Is this a known problem on
Debian Sarge?

* Database logging doesn't work with postgresql (due to use of the
DELAYED keyword which is only supported by MySQL) and we don't want it
anyway. However there doesn't appear to be any way to disable this by
default. The logical action to my mind would be to set ACCESS_LOG_SQL=3D0
in config.ini, however the IniConfig parser appears to set all
uninitialised variables in the config file to 0 which then leads to
ACCESS_LOG_SQL being set to it's default value of 2. To get around this
I have created the patch below which allows the user to specify
ACCESS_LOG_SQL=3D-1 in config.ini to prevent database logging

--- phpwiki-1.3.11/lib/IniConfig.php    2005-04-09 06:11:50.000000000
+1200
+++ phpwiki/lib/IniConfig.php   2005-06-21 23:48:19.000000000 +1200
@@ -383,6 +383,8 @@
     if (!empty($rs['ACCESS_LOG_SQL'])) {
         if (!in_array(DATABASE_TYPE, array('SQL','ADODB')))
             define('ACCESS_LOG_SQL', 0);
+        if ($rs['ACCESS_LOG_SQL']=3D=3D-1)
+            define('ACCESS_LOG_SQL', 0);
     }
     // SQL defaults to ACCESS_LOG_SQL =3D 2
     else {

* Using precached HTML (WIKIDB_NOCACHE_MARKUP) results in errors of the
following type when I try and view any page in the wiki

Fatal Error:
lib/WikiDB/backend/PearDB.php:1014: Error: wikidb_backend_peardb_pgsql:
fatal database error=20

      * DB Error: unknown error
      * (UPDATE page SET cached_html=3D'x=C3=9A=C2=9D=E2=80=9D=C3=8Fn=C3=9B=
0=0C=C3=86=C3=AF}
      * A=0F=C2=B0Z=C3=8E=C2=BFV=C3=892d=1B=E2=80=A0=1D=C2=B65H=C2=B7=C3=B6=
=18(6=1B=13=C2=B5%CR=C5=A1=14E=C3=9E}=E2=80=9Dlg;=C3=9A=3D
        $=E2=82=AC-=C5=A1=C3=BC=C3=B1=C3=A3''=C3=9EI1=E2=80=98=C3=9C[=C2=A5=
=C3=9D=E2=80=9C=C2=B1=15=C3=A4=1EN=C5=BE=C3=8B=E2=80=98|s=E2=80=99=0E=C2=B6=
=C3=BE=C2=B5=06>=C2=BF=E2=80=9Cb&y=C2=AD=C3=B6=10=C5=BE=C2=B7G|=C3=86&.=E2=
=80=98og''o)p=C2=A7=1C

To make the wiki work I have to set WIKIDB_NOCACHE_MARKUP =3D true in
config.ini. This looks like phpwiki is trying to insert bogus values
into the HTML cache.=20

* My first attempt at importing from the zip dump didn't succeed. Lots
of errors were encountered regarding diff merging between page
revisions. This resulted in only the very first revision (ie, not what
is currently displayed in the WLUG wiki) being imported into my new
wiki.=20

Any help with these above problems would be much appreciated and would
help us in our quest to get more in line with upstream PHPwiki.=20

Kind Regards

--=20
Matt Brown
ma...@ma...
Mob +64 275 611 544 www.mattb.net.nz