[Phpgroupware-developers] Bug in AddressBook Application

[Michel Gallou]

Version 0.9.14_001, php 4.3.1, apache 1.3.27, Postgres 7.3.2 

In address book The first page is right.

Error when i pass to the next page with the right arrow, in the address Book
application:

Database error: Invalid SQL: SELECT id,lid,tid,owner,access,cat_id 
,fn,n_given,n_family,org_name,org_unit,title,adr_one_street,adr_one_locality,adr_one_postalcode,tel_work,tel_fax,email 
FROM phpgw_addressbook  WHERE (tid='n')  AND (owner=7 OR (access='public' 
AND owner in(6,7,27)))  ORDER BY n_family,n_given,email ASC LIMIT 20,20
 PostgreSQL Error: 1 (ERROR:  LIMIT #,# syntax not supported. 	Use
separate LIMIT and OFFSET clauses. )
 
File: /home/htdocs/intranet/phpgroupware/phpgwapi/inc/class.contacts_sql.inc.php
Line: 501Session halted.
-- 
-------------------------------------------------
Michel GALLOU
Administrateur Systèmes et Réseaux

C.N.R.S. Délegation Bretagne et Pays de la Loire
Centre d'affaires Oberthur
74E, Rue de Paris 35069 Rennes Cedex

téléphone: (33) 2 99 28 68 05 télécopie: (33) 2 99 28 68 01
visioconférence: (33) 2 99 28 68 00
courriel: address@hidden ,  http://www.dr17.cnrs.fr
--------------------------------------------------