Re: [Phpwiki-talk] Type for cached_html for psql-initialise.sql

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

Alain Peyrat schrieb:
> Hi,
> 
> I'm working with Marc-Etienne Vargenau, we are running a phpwiki-1.3.14 + cvs
> installation with a postgresql database.
> 
> I found some errors while unpacking the cached page. At first glance, this seems
> to be caused by the fact that the datas are binaries (compressed by gzcompress)
> but the type is TEXT.
> 
> In file psql-initialize.sql, the line with the bytea (binary type) has been
> commented.
> 
> [...]
> 	--cached_html  	bytea DEFAULT ''
> 	cached_html  	TEXT DEFAULT ''
> [...]
> 
> Do you remember why ?

I tried two versions:
With and without HAVE_BYTEA in the backends.
7.x worked fine and 8.x failed with one of these, but I forgot which.

Looks like ADODB requires bytea:

lib\WikiDB\backend\ADODB_postgres7.php:
if (!defined("USE_BYTEA"))     // see schemas/psql-initialize.sql
     define("USE_BYTEA", true); // only BYTEA is binary safe

and Pear the opposite:

lib\WikiDB\backend\PearDB_pgsql.php
if (!defined("USE_BYTEA")) // see schemas/psql-initialize.sql
     //define("USE_BYTEA", true);
     define("USE_BYTEA", false);

I'm just moving to a new flat, so everything is hidden under a big pile 
of junk.
-- 
Reini Urban
http://phpwiki.org/  http://murbreak.at/