bugphpGroupWare - Bugs: bug #6278, Failed upgrade infolog to...

 
 

You are not allowed to post comments on this tracker with your current authentication level.

bug #6278: Failed upgrade infolog to v0.9.15.001 (phgroupware 0.9.14.007 to 0.9.14.512)

Submitter:  Peter Bodnar <mexico>
Submitted:  Fri 31 Oct 2003 11:40:55 PM UTC
   
 
Category:  129 (Error - Not Found) Item Group:  0.9.16RC1
Severity:  3 - Normal Priority:  5 - Normal
Status:  None Privacy:  Public
Assigned to:  None Open/Closed:  Open
Component Version:  SVN Operating System:  None
Reproducibility:  Every Time Planned Release:  None
Fixed Release: 

Fri 23 Apr 2004 12:07:10 PM UTC, comment #2: 

this bug still exist in 0.9.16 - link_remark declared as varchar(50), but old phpgw_infolog info_from is defined as varchar(64)

Peter Bodnar <mexico>
Fri 31 Oct 2003 11:47:39 PM UTC, comment #1: 

ok, i change infolog/setup/tables_current.inc.php
and infolog/setup/tables_update.inc.php
with declaration line_remark as varchar(64) and upgrade work fine

Peter Bodnar <mexico>
Fri 31 Oct 2003 11:40:55 PM UTC, 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)

Peter Bodnar <mexico>

 

(Note: upload size limit is set to 16384 kB, after insertion of the required escape characters.)

No files currently attached

 

Depends on the following items: None found

Items that depend on this one: None found

 

CC list is empty

 

There are 0 votes so far. Votes easily highlight which items people would like to see resolved in priority, independently of the priority of the item set by tracker managers.

 

No changes have been made to this item

Back to the top

Powered by Savane 3.15-f85b.
Corresponding source code