Re: [CK-Ledger-users] CK-Ledger and MySQL

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

Hello, Jim,

Thanks for trying out ck-ledger.

I probably should have modified the installation manual when I
made ck-ledger runnable with MySQL.  The manual was
wriiten with Postgresql in mind.

The error message "Database error:  Invalid SQL: select * from
phpgw_inv_statuslist"

was most likely caused by a problem in earlier releases of
phpgroupware of not having created the db table "phpgw_inv_statuslist",
during  phpgroupware's setup process.  This has been rectified in
the latest, phpgroupware-0.9.14.RC3, release.

To fix the problem, try the following,

1.    Make sure that you have a working phpgroupware installation
        with the DB Type set to mysql.  (I presume you had already
        accomplished this, as you had login to phpgroupware)

2.    # mysql phpgroupware    (assuming that the DB name used is
phpgroupware)
        mysql> describe phpgw_inv_statuslist ;

3.    If the phpgw_inv_statuslist is indeed missing, then create it via,

        mysql> source
/var/www/html/phpgroupware/inv/doc/create_tables.mysql
        (the "...../create_tables.pgsql" file is for use with
postgresql).
        Then, retry adminsetup from the ck-ledadmin icon .

4.    However, as you were not able to locate
        /var/www/html/phpgroupware/inv/doc/create_tables.pgsql, it could
mean
        that the "..../inv/doc/" folder was somehow corrupted.  In this
case, you
        may like to download phpgroupware-0.9.14.RC3 from
www.phpgroupware.org
        and re-do the entire phpgroupware/ck-ledger installation
process.  With this
        release, there should not be a problem of missing
phpgw_inv_statuslits table.

Please give me and the ck-ledger-users list a reply whether the steps
above help.

Best Regards,
CK



Jim Roden wrote:

> Hi
> I am trying to get ck-ledger to work and have the following
> problem.
> When installing the software the documentation suggests the
> following
> su -l -c "psql phpgroupware <
> /var/www/html/phpgroupware/inv/doc/create_tables.pgsql"
> I use MySQL but there id no information on how to create the
> tables using MySQ;  also there is no
> /inv/doc/create_tables.pgsql file.
> when I login to phpgroupware after creating the application
> files for ck-ledger I get the following error if I try to run
> groupware/ck-ledadmin/adminsetup.php.
> Database error: Invalid SQL: select * from
> phpgw_inv_statuslist
> Session halted.
> Warning: 1 is not a valid MySQL-Link resource in
> /usr/local/httpd/htdocs/phpgroupware/phpgwapi/inc/phpg
> w_db_mysql.inc.php on line 92
>
> --
> Best regards
> Jim Roden
> Logicomm 2000
> Tel: +44 1543 273 690
> Fax: +44 1543 273 691
> http://www.logicomm.co.uk
>
> The information contained in this e-mail is intended for
> the named recipients only, it may also be privileged and
> confidential. If you are  not the intended recipient you must
> not copy, distribute or take any action or reliance upon it.
> No warranties or assurances are made or given as  to the
> accuracy or currency of the information given or in relation
> to the safety of this e-mail and any attachments.
> No liability whatsoever is accepted for any consequences
> arising from it.
> * * * Viruses * * *
> Although we have checked this e-mail and attachments with
> the  Norton AntiVirus software for all presently known
> viruses,
> we advise that in keeping  with good  computing practice the
> recipient should ensure they are actually virus free.
> Thought for the Day:
> God is not dead, he just moved to a better neighborhood.
>
> _______________________________________________
> CK-Ledger-users mailing list
> CK-...@li...
> https://lists.sourceforge.net/lists/listinfo/ck-ledger-users