Error on backup/restore

camro 2006-12-12 23:23:11 UTC #1

hi,
i tried it with the last cvs 12.12.2006 and the last stable version 1.2.105

i installed all thnings and create some users.
then i do a backup.
these backup i want to restore

then i got message:

Database error: Invalid SQL: INSERT INTO egw_accounts (account_id,account_lid,account_pwd,account_lastlogin,account_lastloginfrom,account_lastpwd_change,account_status,account_expires,account_type,account_primary_group,account_challenge,account_response) VALUES (1,‘Default’,’’,NULL,NULL,NULL,‘A’,-1,‘g’,0,NULL,NULL)
pgsql Error: -1 (FEHLER: aktuelle Transaktion wurde abgebrochen, Befehle werden bis zum Ende der Transaktion ignoriert)

File: /var/www/www.xxx.biz/htdocs/egroupware/phpgwapi/inc/class.db_backup.inc.php
Line: 243
Function: egw_db::insert / db_backup::restore / include(/setup/db_backup.php) / admin_db_backup::index / ExecMethod(admin.admin_db_backup.index)

some ideas whats going on ?

ralfbecker_dr 2006-12-13 06:55:01 UTC #2

Hi,

unfortunately this messages only says something went wrong before.

Postgres uses transactions and one of the SQL statements before this one
was not ok, so all further SQL gets ignored 'til the end of the transaction.

So I guess this was not the first error message …

Ralf

Camel schrieb:

hi,
i tried it with the last cvs 12.12.2006 and the last stable version 1.2.105

i installed all thnings and create some users.
then i do a backup.
these backup i want to restore

then i got message:

Database error: Invalid SQL: INSERT INTO egw_accounts
(account_id,account_lid,account_pwd,account_lastlogin,account_lastloginfrom,account_lastpwd_change,account_status,account_expires,account_type,account_primary_group,account_challenge,account_response)
VALUES (1,‘Default’,’’,NULL,NULL,NULL,‘A’,-1,‘g’,0,NULL,NULL)
pgsql Error: -1 (FEHLER: aktuelle Transaktion wurde abgebrochen, Befehle
werden bis zum Ende der Transaktion ignoriert)

File:
/var/www/www.xxx.biz/htdocs/egroupware/phpgwapi/inc/class.db_backup.inc.php
Line: 243
Function: egw_db::insert / db_backup::restore /
include(/setup/db_backup.php) / admin_db_backup::index /
ExecMethod(admin.admin_db_backup.index)

some ideas whats going on ?

–
eGroupWare Training & Support ==> http://www.egroupware-support.de
1.2 Release Offer: 250Euro for a Standard Update or Installation
including 1h Telefonsupport und ein gedrucktes deutsches Handbuch

Take Surveys. Earn Cash. Influence the Future of IT
Join SourceForge.net’s Techsay panel and you’ll get the chance to share your
opinions on IT & business topics through brief surveys - and earn cash
http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV

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

camro 2006-12-13 11:32:23 UTC #3

well - maybe you’re right.
but for me i show the full message - and only there i found an error.
maybe you can find this better.

as attached the full msg which comeback from the browser.
thank’s - cu camel

Hi,