[Phpgroupware-tracker] [bugs #8667] infolog upgrade failed

[Peter Bodnar]

This mail is an automated notification from the bugs tracker
 of the project: phpGroupWare.




/**************************************************************************/
[bugs #8667] Full Item Snapshot:

URL: <http://savannah.gnu.org/bugs/?func=detailitem&item_id=8667>
Project: phpGroupWare
Submitted by: Peter Bodnar
On: Fri 04/23/04 at 12:26

Category:  API - Setup
Item Group:  0.9.16.000 release
Severity:  5 - Average
Priority:  7 - High
Resolution:  None
Assigned to:  None
Status:  Open
Component Version:  CVS
Platform Version:  GNU/Linux - Debian
Reproducibility:  Every Time


Summary:  infolog upgrade failed

Original Submission:  upgrade infolog from older (0.9.14) to new (0.9.15) 
version is failed with error message:
Database error: Invalid SQL: INSERT INTO phpgw_links 
(link_app1,link_id1,link_app2,link_id2,link_remark,link_lastmod,link_owner) 
SELECT 
'infolog',info_id,'addressbook',info_addr_id,info_from,info_datemodified,info_owner
 FROM phpgw_infolog WHERE info_addr_id != 0 
 PostgreSQL Error: 1 (ERROR: value too long for type character varying(50) ) 

problem is : old table has column info_from with definition varchar(64), new 
table have column link_remark with definition varchar (40)







File Attachments
-------------------

-------------------------------------------------------
Date: Fri 04/23/04 at 12:26  Name: infolog_tables_current.inc.diff  Size: 790KB 
  By: mexico
patch1
http://savannah.gnu.org/bugs/download.php?item_id=8667&amp;item_file_id=1226






For detailed info, follow this link:
<http://savannah.gnu.org/bugs/?func=detailitem&item_id=8667>

_______________________________________________
  Message sent via/by Savannah
  http://savannah.gnu.org/