[eGroupWare-users] problem while upgrading

[pedro b. g. <ga...@re...>]

**//
I have just upgraded eGW from .13 to .14. During the upgrade I had a 
small problem as follows:

You appear to be running version 0.9.99.013 of eGroupWare.
We will automatically update your tables/records to 0.9.99.014 but we 
_highly recommend backing up_ your tables in case the script causes 
damage to your data.
*These automated scripts can easily destroy your data.*
/Please backup before going any further!
//
/After clicking on UPGRADE, I got the following:

*Database error:* Invalid SQL: INSERT INTO phpgw_anglemail 
(account_id,data_key,content) VALUES 
('5','0;phpgw_header;INBOX;31','O:8:\"stdClass\":25:{s:4:\"date\";s:31:\"Sat, 
24 Jan 2004 15:31:01 -0200\";s:4:\"Date\";s:31:\"Sat, 24 Jan 2004 
15:31:01 -0200\";s:7:\"subject\";s:34:\"ENC: 
MailingSemCadastro_240104.txt\";s:7:\"Subject\";s:34:\"ENC: 
MailingSemCadastro_240104.txt\";s:10:\"message_id\";s:53:\"<007501c3e29f$d67d7710$924...@te...>\";s:9:\"toaddress\";s:18:\"ch...@re...\";s:2:\"to\";a:1:{i:0;O:8:\"stdClass\":2:{s:7:\"mailbox\";s:4:\"chau\";s:4:\"host\";s:13:\"reckon.com.br\";}}s:11:\"fromaddress\";s:49:\"\"primesys\\\\dac_spo02\" 
\";s:4:\"from\";a:1:{i:0;O:8:\"stdClass\":3:{s:8:\"personal\";s:18:\"primesys\\dac_spo02\";s:7:\"mailbox\";s:9:\"dac_spo02\";s:4:\"host\";s:15:\"primesys.com.br\";}}s:15:\"reply_toaddress\";s:25:\"dac...@pr...\";s:8:\"reply_to\";a:1:{i:0;O:8:\"stdClass\":2:{s:7:\"mailbox\";s:9:\"dac_spo02\";s:4:\"host\";s:15:\"primesys.com.br\";}}s:13:\"senderaddress\";s:49:\"\"primesys\\\\dac_spo02\" 
\";s:6:\"sender\";a:1:{i:0;O:8:\"stdClass\":3:{s:8:\"personal\";s:18:\"primesys\\dac_spo02\";s:7:\"mailbox\";s:9:\"dac_spo02\";s:4:\"host\";s:15:\"primesys.com.br\";}}s:6:\"Recent\";s:1:\"N\";s:6:\"Unseen\";s:1:\" 
\";s:7:\"Flagged\";s:1:\" \";s:8:\"Answered\";s:1:\" 
\";s:7:\"Deleted\";s:1:\" \";s:5:\"Draft\";s:1:\" 
\";s:5:\"Msgno\";s:4:\" 31\";s:8:\"MailDate\";s:26:\"24-Jan-2004 
15:31:01 
-0200\";s:4:\"Size\";s:6:\"414211\";s:5:\"udate\";i:1074965461;s:9:\"fetchfrom\";s:0:\"\";s:12:\"fetchsubject\";s:0:\"\";}')
*PostgreSQL Error*: 1 (ERROR: Bad input string for type bytea )

*Function/Module:* /setup/index.php

I returned to my backup, asked the user to clear his email cache, and 
tried again, this time successfully.

I suggest that the upgrade script clears the caches previous to the db 
alterations in the next versions.

The platform is debian woody on Intel.

regards,

Pedro

/
/