Re: [Phpgroupware-users] Weirdness with AddressBook and Infolog

[Dave Hall]

I think RH8 ships with pgsql 7.3 which has some issues with phpgw.  We
have some patches to apply, but the person who was meant to commit them
is currently AWOL.

Chris Weiss <address@hidden> wrote:

> >My problem is when I try to recreate the installation on another 
> machine>I get errors out of infolog whenever I attempt to make an 
> entry in
> >forlog or I make an entry in addressbook (which updates a link to
> >infolog).  When I attempt the entry to infolog the screen just 
> flashes>back to the main phpgw screen; when I attempt an entry to 
> addressbook I
> >receive an sql error from infolog but the addressbook entry is made
> >correctly.
> 
> typicaly "works here but not there" issues are due to differences 
> in the php.ini,
> like register_globals and php session config and file uploads config.
> 
> >
> >I have tried everything that I can think of to get phpgw to work
> >properly on the other machine: reloaded RH (both 7 & 8, same 
> results);>copied the phpgw tree from the "working" machine to the 
> other machine;
> >copied the database files from the working machine to the other 
> machine;>replaced the phpgw tree with the latest tree from CVS; 
> tried various php
> >releases; tried a different PEAR; the list goes on and on.
> 
> right now we don't use PEAR so that won't matter
> 
> >The sql error follows (if it helps):
> >Database error: Invalid SQL: SELECT COUNT(*) FROM phpgw_infolog WHERE
> >(info_owner=3 OR info_owner IN (3) OR (info_access='public' AND
> >info_owner IN(3))) AND info_addr_id=
> >PostgreSQL Error: 1 (ERROR: parser: parse error at or near "" )
> >
> >File: /var/www/html/phpgroupware/infolog/inc/class.soinfolog.inc.php
> >Line: 290
> 
> did it tell you the file and line the sql error came from?  Need 
> to see what it's
> trying to put in for info_addr_id and figure out why it is comming 
> out blank.
> 
> >I would appreciate any help that anyone might be able to offer 
> (and my
> >apologies to Ralf Becker for being so impatient).  I know the 
> resolution>is probably exceedingly simple but I have an 
> installation that really
> >wants to use infolog and addressbook as they "work" on the working
> >machine and I have run out of ideas on how to fix this.
> 
> 
> 
> _______________________________________________
> Phpgroupware-users mailing list
> address@hidden
> http://mail.gnu.org/mailman/listinfo/phpgroupware-users
>

dave.hall.vcf
Description: Card for <dave.hall@mbox.com.au>