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

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

-------- Original Message --------
   Subject: Re: Minor problem
      Date: Mon, 18 Feb 2002 08:39:15 +1100
      From: "admin" <ad...@qu...>
        To: "C K Wu" <ck...@ch...>
References: <002401c1b792$9f0b4a30$c4ec2acb@geoff>
            <3C6...@ch...>

 Sorry CK should have been a little more explicit Debian and postgres
7.0 groupware 0.9.12 Install groupware - no errors calendar  /admin/etc
working ( but no phpgw_inv_statuslist table in DB) Untar ck-ledger
modules to same directory level as groupware modules -install ledadmin
and ar (didnt botherwith the whole 8 until I determined I could get to
ledadmin)through groupware admin. Create new user with permissionto
access both ) Into phpgroupware as new user - both icons visible
(ledadmin and ar) error occurs on clicking either icon.Which I guess you
would expect seeing the table is notthere and there has been nothing
done to change tabledata from initial install. I guess the question is -
should that table be created onevery groupware install regardless of
subsequent applications and if so why wasnt it - have i missed
somesubtlety in the groupware install and why do other
essentialgroupware tables appear to be in place except this
one. Certainly appreciate your effort and if I hadn't spent a daylooking
for clues wouldn't ask. Regards Geoff

     ----- Original Message -----
     From: C K Wu
     To: admin
     Sent: 17 February, 2002 10:50 PM
     Subject: Re: Minor problem
      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