bugphpGroupWare - Bugs: bug #8667, infolog upgrade failed

 
 

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

bug #8667: infolog upgrade failed

Submitted by:  Peter Bodnar <mexico>
Submitted on:  Fri 23 Apr 2004 12:26:54 PM UTC  
 
Item Group: 0.9.16.000 releaseCategory: API - Setup
Severity: 3 - NormalPriority: 7 - High
Status: NonePrivacy: Public
Assigned to: NoneOpen/Closed: Open
Component Version: SVNOperating System: GNU/Linux - Debian
Reproducibility: Every TimePlanned Release: None
Fixed Release: 

Fri 23 Apr 2004 12:26:54 PM UTC, 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)

Peter Bodnar <mexico>

 

Attached Files
file #1243:  infolog_tables_update.inc.diff added by mexico (788B - text/x-diff - patch2)
file #1242:  infolog_tables_current.inc.diff added by mexico (790B - text/x-diff - patch1)

 

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):

 

 

Follow 3 latest changes.

Date Changed By Updated Field Previous Value => Replaced By
Thu 15 Jul 2004 09:46:57 AM UTCharrivCarbon-Copy-=>Added harriv
Fri 23 Apr 2004 12:29:19 PM UTCmexicoAttached File-=>Added infolog_tables_update.inc.diff, #1227
Fri 23 Apr 2004 12:26:54 PM UTCmexicoAttached File-=>Added infolog_tables_current.inc.diff, #1226

Back to the top


Powered by Savane 3.1-cleanup1