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)

Submitted by:  Peter Bodnar <mexico>
Submitted on:  Fri 31 Oct 2003 11:40:55 PM UTC  
 
Item Group: 0.9.16RC1Category: 129(Error - Not Found)
Severity: 3 - NormalPriority: 5 - Normal
Status: NonePrivacy: Public
Assigned to: NoneOpen/Closed: Open
Component Version: SVNOperating System: None
Reproducibility: Every TimePlanned 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>

 

No files currently attached

 

Depends on the following items: None found

Items that depend on this one: None found

 

CC list is empty

 

Do you think this task is very important?
If so, you can click here to add your encouragement to it.
This task has 0 encouragements so far.

Only logged-in users can vote.

 

Please enter the title of George Orwell's famous dystopian book (it's a date):

 

 

No Changes Have Been Made to This Item

Back to the top


Powered by Savane 3.1-cleanup1