[Top][All Lists]
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
Re: [Phpgroupware-users] Weirdness with AddressBook and Infolog
From: |
Ralf Becker |
Subject: |
Re: [Phpgroupware-users] Weirdness with AddressBook and Infolog |
Date: |
Tue, 18 Mar 2003 01:31:45 +0100 |
User-agent: |
Mozilla/5.0 (X11; U; Linux i686; en-US; rv:1.0.0) Gecko/20020529 |
Robert Dick wrote:
Hi, all:
I've submitted this request under "Questions" on savannah so I apologize
if this is a dupw for anyone involved.
I have loaded phpgw 0.9.14.001-1 on a RH8 platform which has been
patched up-to-date from RHN. I have been able to successfully install
and configure phpgw against both postgres and mysql on the machine. The
apps I'm using are email, addressbook, calendar and infolog. All is good.
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.
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.
The working machine has had php and pear massaged repeatedly but, as
best I can tell, it is now running the latest RPM's from RH for php.
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=
^--- missing addr_id
The problem is the missing addr_id from the addressbook, do u have
register globals on or off in the php.ini?
I think, I heard from someone its off by default.
Ralf
PostgreSQL Error: 1 (ERROR: parser: parse error at or near "" )
File: /var/www/html/phpgroupware/infolog/inc/class.soinfolog.inc.php
Line: 290
Session halted.
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.
Robert
--
----------------------------------------------------------------------
Ralf Becker
digital ROCK, Becker & Macht GbR Telefon +49 (631) 31657-51
Leibnizstraße 17 Telefax +49 (631) 31657-52
D-67663 Kaiserslautern EMail address@hidden