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

Submitter:  Peter Bodnar <mexico>
Submitted:  Fri 23 Apr 2004 12:26:54 PM UTC
   
 
Category:  API - Setup Item Group:  0.9.16.000 release
Severity:  3 - Normal Priority:  7 - High
Status:  None Privacy:  Public
Assigned to:  None Open/Closed:  Open
Component Version:  SVN Operating System:  GNU/Linux - Debian
Reproducibility:  Every Time Planned 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>

 

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

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

 

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.

 

Follow 3 latest changes.

Date Changed by Updated Field Previous Value => Replaced by
2004-07-15 harriv Carbon-Copy- Added harriv
2004-04-23 mexico Attached File- Added infolog_tables_update.inc.diff, #1227
2004-04-23 mexico Attached File- Added infolog_tables_current.inc.diff, #1226

Back to the top

Powered by Savane 3.13-02a9.
Corresponding source code