[Phpgroupware-tracker] [Bug #1202] phpgw setup weirdness: Tables are created by setup, but phpgw cant see them ???

[nobody]

=================== BUG #1202: FULL BUG SNAPSHOT ===================
http://savannah.gnu.org/bugs/?func=detailbug&bug_id=1202&group_id=509

Submitted by: ericswebber               Project: phpGroupWare                   
Submitted on: 2002-Sep-13 17:22
Category:  API - Setup                  Bug Group:  0.9.14 release              
Severity:  5 - Major                    Priority:  High                         
Resolution:  None                       Assigned to:  None                      
Status:  Open                           Component Version:  ZIP                 
Platform Version:  Linux - RedHat       Reproducibility:  Every Time            

Summary:  phpgw setup weirdness: Tables are created by setup, but phpgw cant 
see them ???

Original Submission:  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





No Followups Have Been Posted


CC list is empty


No files currently attached


For detailed info, follow this link:
http://savannah.gnu.org/bugs/?func=detailbug&bug_id=1202&group_id=509