[CK-Ledger-users] [Fwd: Re: Minor problem]

[C K Wu <ck...@ch...>]

-------- Original Message --------
   Subject: Re: Minor problem
      Date: Sun, 17 Feb 2002 19:50:37 +0800
      From: C K Wu <ck...@ch...>
        To: admin <ad...@qu...>
References: <002401c1b792$9f0b4a30$c4ec2acb@geoff>

Hi, Geoff,

This is an error coming from phpgw's api module, and is probably caused
by some unreported/logical error occurring prior to entering the api
module.

So, just to clarify,

1.    Were you able to see the eight abacus icons in the navbar?
2.    Were you able to see the welcome page of ledadmin ?
3.    Were you able to see the welcome page of the other 7 modules ?
4.    If the answer to Q.2 is yes, when did the error pop up ?

a.    After you clicked Admin/Setup choice at the top left hand corner ?

b.    After choosing action 4 -- Delete all data and data tables ?
c.    After choosing action 1 -- Setup Data Table ?
d.    After choosing Build Chart of Accounts and other Master Data ?
e.    After choosing Create Test Data ?

If you could provide the info above, it will be clearer where the hidden

error is.  [Could be a programming error in the code itself  : (   ]
I'll go jogging now.  Be back in an hour.

Oh.  By the way.  phpgw_inv_statuslist is a table used by the phpgw's
native inventory module.  It should be created during phpgw's setup
process.  I have it appearing in a clean phpgw 0.9.14RC1 install.
You may like to check if you have accidentally activated phpgw's
native inventory module, which is included in subdirectory named "inv"
as opposed to CK-Ledger's which is housed in a subdirectory named
"inventory".

Best Regards,
CK



admin wrote:

> Hi, After using sql-ledger but developing in php not perlwas
> interested in giving ck-ledger a run. Not using phpgroupware before I
> now have it workingas advertised with postgres. After going through
> the install procedure for new applicationsI run up against this error
> when initiating ledadmin from groupware Warning: PostgreSQL query
> failed: ERROR: Relation 'phpgw_inv_statuslist' does not exist in
> /var/www/phpgroupware/phpgwapi/inc/class.db_pgsql.inc.php on line 96
> Database error: Invalid SQL: select * from phpgw_inv_statuslist
> PostgreSQL Error: 1 (ERROR: Relation 'phpgw_inv_statuslist' does not
> exist )This table definitely does not exist A little baffled - if you
> have the time and its shortand easy would appreciatea a lead Regards
> Geoff