[Phpgroupware-tracker] [ 101285 ] setup: phpgw tables created, not seen ?

[nobody]

Support Request #101285, was updated on 2002-Sep-13 17:15
You can respond by visiting: 
http://savannah.gnu.org/support/?func=detailsupport&support_id=101285&group_id=509

Category: Bug Report
Status: Open
Priority: 5
Summary: setup: phpgw tables created, not seen ?

By: ericswebber
Date: 2002-Sep-13 17:15
Logged In: YES 
user_id=10620
Browser: Mozilla/4.0 (compatible; MSIE 5.5; Windows NT 5.0)

environment:

postgres (PostgreSQL) 7.2.1
Red 7.3
phpGroupWare version 0.9.14.000 Setup III - Domain: 
default(pgsql)   with CVS update from today...

SYMPTOMS:

Setup seems to work fine, header.inc.php created.
Tables all created in Postgres and all are actually 
there, even admin user and demo accounts are created 
successfully via setup.

But when I come back in via the url: 
http://domain.com/phpgroupware 
I get the following message:

   "Fatal Error: It appears that you have not created 
the database tables for phpGroupWare. Click here run 
for setup"

Whereupon, clicking setup brings me back into the 
setup screen, which indicates everything is already 
setup in terms of tables, and upon a psql query all 
tables are in fact present in the database.

So I traced the error message to the following file:

phpgwapi/inc/functions.inc.php

and the code that preceded the error message's display 
reads:

 @$GLOBALS['phpgw']->db->query("select count
(config_name) from phpgw_config");

which when I execute MANUALLY in psql, I get 19 rows !!

So what gives here ?  setup itself can communicate 
well enough with postgres to create the tables yet 
just trying to bring up root page in phpgroupware and 
all of a sudden the db communication fouls up somehow 
someway ?

here are the manual query results.

phpgroupware=> select config_name from phpgw_config;
     config_name
----------------------
 useframes
 temp_dir
 files_dir
 webserver_url
 hostname
 daytime_port
 auth_type
 account_repository
 file_repository
 auto_create_expire
 acl_default
 ldap_encryption_type
 mcrypt_algo
 mcrypt_mode
 site_title
 showpoweredbyon
 countrylist
 sessions_checkip
 tz_offset
(19 rows)

phpgroupware=> select count(config_name) from 
phpgw_config;
 count
-------
    19
(1 row)

phpgroupware=>


very frustrated.

address@hidden



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