Ticket modified by Frank Schmied at 2010/06/21 21:32
Tracking System: Bugs
Category: Admin
Version: Trunk
Status: Open
Resolution: None
Completed: 0%
Priority: 5 - medium
Created By: Lars Boegild Thomsen
Assigned to: Ralf Becker
Summary: #2478 - Backup no longer working
Trunk with postgresql - db backup no longer working (has been a while).
The backup file is created. Unpacking it - it contains this:
eGroupWare backup from 2010-02-05 15:37:35
version: 1.7.003
charset: utf-8
$phpgw_baseline = array(
);
schema: a:0:{}
And that is all.
No error messages in apache’s logs.
Comment by Frank Schmied at 2010/06/21 21:32:
Hi,
I can confirm this issue with egw 1.6.003-2 and Postgresql 8.3.
Postgre log:
WARNING: nonstandard use of escape in a string literal at character 62
HINT: Use the escape string syntax for escapes, e.g., E’\r\n’.
WARNING: nonstandard use of escape in a string literal at character 208
HINT: Use the escape string syntax for escapes, e.g., E’\r\n’.
Content of created backup file:
eGroupWare backup from 2010-06-19 17:52:35
version: 1.6.003
charset: utf-8
$phpgw_baseline = array(
);
schema: a:0:{}
Cheers,
Frank
Comment by Carlos Alberto at 2010/02/15 17:59:
I’m having the same problem with 1.6.003.
In my database server this message is logged:
Feb 15 14:52:33 010-255-255-250 postgres[11093]: [6-1] AVISO: uso de escape fora do padrão em cadeia de caracteres no caracter 208
Feb 15 14:52:33 010-255-255-250 postgres[11093]: [6-2] DICA: Utilize a sintaxe de escape de cadeia de caracteres para escapes, i.e., E’\r\n’
it seems to be using an invalid escape sequence in some character when obtainning data from database.
database version:
postgresql-server-8.3.3
I’m trying to migrate to mysql backing up database and then restoring it into mysql.
linked entries:
http://www.egroupware.org/egroupware/index.php?menuaction=tracker.tracker_ui.edit&tr_id=2478&no_popup=1