Errors when using admin-cli.php

Hello

I’d like to manage groups in egroupware by script instead of using the web interface .
It seems that the script admin-cli.php with option edit-group is made fotr this .
However i meet 2 difficulties when i try to use it :

first the creation of group goes well but When i try to modify an existing one , i’ve got this error :
Database error: Invalid SQL: INSERT INTO egw_addressbook (contact_tid,contact_owner,contact_private,n_family,n_given,contact_email,contact_created,contact_creator,contact_modified,contact_modifier,account_id) VALUES (‘n’,0,0,NULL,NULL,‘toto’,1252664338,6,1252664338,6,-1608961):

it seems that admin-cli try to insert a new record in addressbook table where account_id is declared index unique , instead of update ?

The second problem is when in the list members
, there is an inexisting member , the command fails with message unknow_account , it will be better if the unknow_account was ignored and that the others members were proceeded .

greetings

Hi Marc,

marc.patouillard schrieb:

Hello

I’d like to manage groups in egroupware by script instead of using the web
interface .
It seems that the script admin-cli.php with option edit-group is made fotr
this .
However i meet 2 difficulties when i try to use it :

first the creation of group goes well but When i try to modify an existing
one , i’ve got this error :
Database error: Invalid SQL: INSERT INTO egw_addressbook
(contact_tid,contact_owner,contact_private,n_family,n_given,contact_email,contact_created,contact_creator,contact_modified,contact_modifier,account_id)
VALUES (‘n’,0,0,NULL,NULL,‘toto’,1252664338,6,1252664338,6,-1608961):

Looks like a bug, please report it to our bug tracker
(www.egroupware.org/bugs) incl. the exact command used to produce the error.

it seems that admin-cli try to insert a new record in addressbook table
where account_id is declared index unique , instead of update ?

The second problem is when in the list members
, there is an inexisting member , the command fails with message
unknow_account , it will be better if the unknow_account was ignored and
that the others members were proceeded .

Maybe, I prefer to get the error reported and not ignored.

Ralf

Ralf Becker
Director Software Development

Stylite GmbH
[open style of IT]

Morschheimer Strasse 15
67292 Kirchheimbolanden

fon +49 (0) 6352 70629-0
fax +49 (0) 6352 70629-30
mailto: rb@stylite.de

www.stylite.de
www.egroupware.org


Geschäftsführer Andre Keller, Gudrun Müller,
Nigel Vickers und Ralf Becker
Registergericht Kaiserslautern HRB 30575
Umsatzsteuer-Id / VAT-Id: DE214280951


Come build with us! The BlackBerry® Developer Conference in SF, CA
is the only developer event you need to attend this year. Jumpstart your
developing skills, take BlackBerry mobile applications to market and stay
ahead of the curve. Join us from November 9-12, 2009. Register now!
http://p.sf.net/sfu/devconf


eGroupWare-users mailing list
eGroupWare-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/egroupware-users