[Phpgroupware-tracker] [ 101948 ] Weirdness with Addressbook and infolog

[nobody]

Support Request #101948, was updated on Thu 03/13/03 at 05: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: Fri 03/14/03 at 04:46
Logged In: YES 
user_id=16146
Browser: Mozilla/5.0 (X11; U; Linux i686; en-US; rv:1.0.1) Gecko/20020830

Ralf:

I don't know if this helps: on a system OTHER than the
laptop that has the working version I did the following:
1.  Cleared the postgres database files and recreated the
postgres cluster with initdb.
2.. Recreated the phpgroupware database.
3.  Reran the phpgroupware setu, all appeared to work properly.
4.  Started the app as the admin user and did the top level
setup for the site, for addressbook and for infolog.
5.  Entered an address in addressbook and got the same error.
6.  Checked infolog, no entries.  Tried to make an entry in
infolog and the screen just cleared and went back to phpgw
main screen.  Checked infolog again and no entry was made. 
Tried this a couple of times, same result.
7.  Using phpPgAdmin I checked on the database tables. 
There are zero records in phpgw_infolog and
deq_phpgw_infolog is still at sequence 1.

Robert

----------------------------------------------------------------------

By: robertdick
Date: Thu 03/13/03 at 18: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.

----------------------------------------------------------------------
You can respond by visiting: 
http://savannah.gnu.org/support/?func=detailsupport&support_id=101948&group_id=509