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

[Dave Hall]

This mail is an automated notification from the bugs tracker
 of the project: phpGroupWare.

/**************************************************************************/
[bugs #1202] Latest Modifications:

Changes by: 
                Dave Hall <address@hidden>
'Date: 
                Sun 05/30/2004 at 22:55 (Australia/Melbourne)

            What     | Removed                   | Added
---------------------------------------------------------------------------
              Status | Open                      | Closed


------------------ Additional Follow-up Comments ----------------------------
Closed due to no response after 2 weeks of followup being posted






/**************************************************************************/
[bugs #1202] Full Item Snapshot:

URL: <http://savannah.gnu.org/bugs/?func=detailitem&item_id=1202>
Project: phpGroupWare
Submitted by: Eric Sean Webber
On: Fri 09/13/2002 at 17:22

Category:  API - Setup
Item Group:  0.9.14 release
Severity:  5 - Average
Priority:  5 - Normal
Resolution:  None
Assigned to:  None
Status:  Closed
Component Version:  ZIP
Platform Version:  GNU/Linux - RedHat/Fedora
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



Follow-up Comments
------------------


-------------------------------------------------------
Date: Sun 05/30/2004 at 22:55       By: skwashd
Closed due to no response after 2 weeks of followup being posted

-------------------------------------------------------
Date: Sun 11/24/2002 at 00:44       By: skwashd
Hey Eric,

What httpd are you running and what version of php are you using?

Also please have a look at 
http://savannah.gnu.org/cgi-bin/viewcvs/phpgroupware/phpgwapi/doc/php-configuration.txt

and see if your config matches this.

Cheers












For detailed info, follow this link:
<http://savannah.gnu.org/bugs/?func=detailitem&item_id=1202>

_______________________________________________
  Message sent via/by Savannah
  http://savannah.gnu.org/