phpwiki-talk

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

[Alain P. <al...@fr...>]

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 ?

Many thanks for your help,
Alain.

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/

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

[AlJeux <al...@fr...>]

Reini Urban a écrit :
> 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);

Thank you for your very fast answer. I didn't noticed the USE_BYTEA 
define. I will carefully take a look at it and will make some tests to 
find what we need exactly.

Many thanks,
Alain.