[Phpgroupware-tracker] [bug #6278] Failed upgrade infolog to v0.9.15.001 (phgroupware 0.9.14.007 to 0.9.14.512)

[nobody]

=================== BUG #6278: FULL BUG SNAPSHOT ===================
http://savannah.gnu.org/bugs/?func=detailbug&bug_id=6278&group_id=509

Submitted by: mexico                  Project: phpGroupWare                 
Submitted on: Fri 10/31/03 at 23:40
Category:  infolog                    Bug Group:  0.9.16RC1                 
Severity:  5 - Major                  Priority:  High                       
Resolution:  None                     Assigned to:  None                    
Status:  Open                         Component Version:  CVS               
Platform Version:  None               Reproducibility:  Every Time          

Summary:  Failed upgrade infolog to v0.9.15.001 (phgroupware 0.9.14.007 to 
0.9.14.512)

Original Submission:  after upgrading phpgwapi (with new CVS table_baseline all 
working fine, thx ;-), there is needing to manulay install etemplate - working 
fine. after that, infolog is in version 0.9.11, new version is 0.9.15.001 - 
when I try upgrade aplication, this ends with error:



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, that new table phpgw_links is filled with data from old 
phpgw_infolog and phpgw_infolog contain column link_from with specification 
varchar(64), but column in phpgw_link, where data is stored (named 
link_remark), is declared only as varchar(50)



No Followups Have Been Posted


CC list is empty


No files currently attached


For detailed info, follow this link:
http://savannah.gnu.org/bugs/?func=detailbug&bug_id=6278&group_id=509

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