bugphpGroupWare - Bugs: bug #1202, phpgw setup weirdness: Tables are...

 
 

You are not allowed to post comments on this tracker with your current authentication level.

bug #1202: phpgw setup weirdness: Tables are created by setup, but phpgw cant see them ???

Submitter:  Invalid User ID <#10620>
Submitted:  Fri 13 Sep 2002 05:22:36 PM UTC
   
 
Category:  API - Setup Item Group:  0.9.14 release
Severity:  3 - Normal Priority:  5 - Normal
Status:  None Privacy:  Public
Assigned to:  None Open/Closed:  Closed
Component Version:  ZIP Operating System:  GNU/Linux - RedHat/Fedora
Reproducibility:  Every Time Planned Release:  None
Fixed Release: 

Sun 30 May 2004 10:55:57 PM UTC, comment #2: 

Closed due to no response after 2 weeks of followup being posted

Dave Hall <skwashd>
Group administrator
Sun 24 Nov 2002 12:44:32 AM UTC, comment #1: 

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

Dave Hall <skwashd>
Group administrator
Fri 13 Sep 2002 05:22:36 PM UTC, 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.

-email is unavailable-


Invalid User ID <#10620>

 

(Note: upload size limit is set to 16384 kB, after insertion of the required escape characters.)

No files currently attached

 

Depends on the following items: None found

Items that depend on this one: None found

 

CC list is empty

 

There are 0 votes so far. Votes easily highlight which items people would like to see resolved in priority, independently of the priority of the item set by tracker managers.

 

Follows 1 latest change.

Date Changed by Updated Field Previous Value => Replaced by
2004-05-30 skwashd Open/ClosedOpen Closed

Back to the top

Powered by Savane 3.13-caa5.
Corresponding source code