[Top][All Lists]
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Phpgroupware-tracker] [ 101948 ] Weirdness with Addressbook and infolog
From: |
nobody |
Subject: |
[Phpgroupware-tracker] [ 101948 ] Weirdness with Addressbook and infolog |
Date: |
Thu, 13 Mar 2003 18:46:55 -0500 |
Support Request #101948, was updated on Thu 03/13/03 at 06:36
You can respond by visiting:
http://savannah.gnu.org/support/?func=detailsupport&support_id=101948&group_id=509
Category: Question
Status: Open
Priority: 5
Summary: Weirdness with Addressbook and infolog
By: robertdick
Date: Thu 03/13/03 at 19:56
Logged In: YES
user_id=16146
Browser: Mozilla/5.0 (Windows; U; Windows NT 5.0; en-US; rv:1.0.2)
Gecko/20021120 Netscape/7.01
Here's the error:
Database error: Invalid SQL: SELECT COUNT(*) FROM
phpgw_infolog WHERE (info_owner=7
OR info_owner IN (7) OR (info_access='public' AND info_owner
IN(7))) 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
Session halted.
----------------------------------------------------------------------
By: arjaysam
Date: Thu 03/13/03 at 06:36
Logged In: YES
user_id=16146
Browser: Mozilla/5.0 (Windows; U; Windows NT 5.0; en-US; rv:1.0.2)
Gecko/20021120 Netscape/7.01
I have 9.14.001 installed on 2 RH8 systems, both using
postgres 7.2.2, both using RH supplied RPM's for all
requisite support files (ie php). One system is
working fine, I add or modify an entry in Addressbook
and the infolog portion does what it's supposed to do
(on add of a new record you just see the 0 record
display for infolog at the bottom of the addressbook
screen).
The other system gives a postgres SQL error out of
infolog when an addressbook record is added or
updated. It appears the error is caused by an
incomplete select statment (select count(*) from ...;
sorry, I dont have it available for pasting into this
note). The addressbook record is added properly. It
seems there is no "link" between the addressbook and
infolog on the second system.
I have copied over from the first system to the second
system the whole phpgroupware tree as well as the
Postgres database files but the problem remains. Im at
a dead loss as to what the problem is as I can't see
any differences between the two systems. If anything,
the system that is giving me the problem is "cleaner"
than the working system as I've even done a fresh
reinstall of RH8.
Any ideas or thoughts would be appreciated as I'm going
totally nutz trying to figure this one out.
Email me at address@hidden or address@hidden
Again, many thanks.
----------------------------------------------------------------------
You can respond by visiting:
http://savannah.gnu.org/support/?func=detailsupport&support_id=101948&group_id=509