Re: [CK-Ledger-users] CK-Ledger and MySQL
Status: Beta
Brought to you by:
ckwu
|
From: C K Wu <ck...@ch...> - 2002-04-29 08:03:55
|
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
|