Le mardi 25 mars 2008 à 18:34 +0100, Olivier Berger a écrit :
> Trying to create an admin account and the 3 demo accounts with
> postgres 8.3, I get this error :
>
> http://localhost/phpgroupware/setup/setup_demo.php
>
> Database error: Invalid SQL: DELETE FROM phpgw_app_sessions WHERE sessionid =
> '0' AND loginid = 0 AND app = 'phpgwapi' AND location = 'config'
> PostgreSQL Error: 1 (ERREUR: l'opérateur n'existe pas : character varying =
> integer LINE 1: ...gw_app_sessions WHERE sessionid = '0' AND loginid = 0 AND
> ap... ^ HINT: Aucun opérateur ne correspond au nom donné et aux types
> d'arguments. Vous devez ajouter des conversions explicites de type.)
>
> File: /usr/share/phpgroupware/phpgwapi/inc/class.config.inc.php
> Line: 68
>
> Session halted.
>
> Dunno if this is linked to this very version of postgresql or what.
>
It seems the following patch fixes the problem.
Will try and add it for next update if it doesn't break things on mysql.
--
Olivier BERGER <[EMAIL PROTECTED]> (*NEW ADDRESS*)
http://www-inf.it-sudparis.eu/~olberger/ - OpenPGP-Id: 1024D/6B829EEC
Ingénieur Recherche - Dept INF
Institut TELECOM / TELECOM & Management SudParis
(http://www.it-sudparis.eu/), Evry
--- class.config.inc.php~ 2008-03-17 13:48:19.000000000 +0100
+++ class.config.inc.php 2008-03-26 12:31:49.000000000 +0100
@@ -62,7 +62,7 @@
{
$this->db->query('DELETE FROM phpgw_app_sessions'
. ' WHERE sessionid = \'0\''
- . ' AND loginid = 0'
+ . ' AND loginid = \'0\''
. " AND app = '{$this->appname}'"
. ' AND location = \'config\'',
__LINE__, __FILE__);
