[CK-Ledger-users] Re: Mysql

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

Hello, Geoff,

Earlier on, Jim had the same problem with the "phpgw_inv_statuslist"
error.
I have pasted below the reply that I made to Jim.  I am still checking
out
your earlier backup/restore problem.

Best Regards,
CK


C K Wu wrote:

> 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
>
admin wrote:

> Hi Ck, Not going to make a habit of this but an installof the latest
> groupware and ck-ledger using mysqlbrings up the following error on
> the groupware pagewhen you try and initiate a ck module Database
> error: Invalid SQL: select * from phpgw_inv_statuslist Have tried it a
> few times same result Regards geoff Note have done some code to
> download /uploadbackup files to a remote host - think this is
> preferableto backing up on the same server will forward code-its not
> brain surgery but it works