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

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

-------- Original Message --------
   Subject: Re: Minor problem
      Date: Mon, 18 Feb 2002 13:17:25 +0800
      From: C K Wu <ck...@ch...>
        To: admin <ad...@qu...>
References: <002401c1b792$9f0b4a30$c4ec2acb@geoff>
            <3C6...@ch...>
            <004d01c1b7fb$8cb4fbb0$c4ec2acb@geoff>

Geoff,

No bother.  It is this kind of process that allows Open Source Software
to be
tested and experience accumulated.

Obviously, I have not tested phpgroupware and ck-ledger in a Debian
environment.
However, I have been able to re-trace your steps in RedHat7.2 and get
the exact
error message that you mentioned in your last email.

I performed a quick fix by creating the tables required by
phpgroupware's inventory
module manually and subsequently was able to access ledadmin and ar
normally.

Table creation steps:
# su -l postgres
$ psql phpgroupware
$ \i /var/www/html/phpgroupware/inv/doc/create_tables.pgsql

and if Debian support this, it could be done via a single command,
# su -l -c "psql phpgroupware <
/var/www/html/phpgroupware/inv/doc/create_tables.pgsql"

You may need to check and find out the exact path for
[phpgroupware base directory]/inv/doc/create_tables.pgsql in your
machine.

See if this works for your case.  Whatever's the outcome, please give me
a reply.
Would like to follow thru' and see how things go.

Best Regards,
CK


admin wrote:

>  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
>     > leadRegards Geoff
>