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

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

Reini Urban schrieb:
>>* 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
>>
>>      * DB Error: unknown error
>>      * (UPDATE page SET cached_html='xÚÂâ€ÃnÛ0Æï}
>>      * A°ZοVÉ2d†¶5H·ö(6µ%CRÅ¡EÞ}â€lg;Ú
>>$€-šüñã''ÞI1‘Ü[¥Ó±äNžË‘|s’¶þµ>¿“b&y­öž·G|Æ&.‘og''o)p§
>>
>>To make the wiki work I have to set WIKIDB_NOCACHE_MARKUP = true in
>>config.ini. This looks like phpwiki is trying to insert bogus values
>>into the HTML cache.

I've found the PEAR pgsql problem. PEAR DB does not escape binary data 
with pg_escape_string(). I've checked in a fix.

I believe ADODB does that right - at least it uses pg_escape_string(), 
but haven't tested that yet.

> cached_html is gzipped.
> So postgresql has problems with binary data. I'll fix that.

-- 
Reini Urban
http://xarch.tu-graz.ac.at/home/rurban/
http://phpwiki.org/