Modify

Opened 20 months ago

Last modified 15 months ago

#10764 assigned defect

Not able to create new TestPlans with 1.5.2 and Trac 0.12 and PostgreSQL

Reported by: michael.kroell@… Owned by: seccanj
Priority: normal Component: TestManagerForTracPlugin
Severity: normal Keywords:
Cc: Trac Release: 0.12

Description

With Trac 0.12 and PostgreSQL there is a datatype issue. For example when trying to create a TestPlan Pg won't store it because the value for the "time" column does not fit into the integer type range.

As a work-around I changed the data type on my local instance using "alter table testplan alter column time type bigint;" but I guess resorting to bigint is not the nicest resolution.

Looks like

tracgenericclass/trunk/tracgenericclass/util.py:66 to_utimestamp(date_obj)

generate those too large values

INSERT INTO testplan (id,catid,page_name,name,author,time,contains_all,freeze_tc_versions) VALUES (E'42',E'43',E'TC_TT43',E'testtestplan',E'mkroell',1357563642946958,1,0)

Attachments (0)

Change History (3)

comment:1 Changed 20 months ago by michael.kroell@…

Btw, just had to convert the type of testcasehistory.time too ;-)

comment:2 Changed 19 months ago by seccanj

  • Status changed from new to assigned

Thanks Michael :D

I'll add your fix into next release.

comment:3 Changed 19 months ago by michael.kroell@…

I think there were more time related columns to be updated. Also, is it really a fix and not a workaround? Is it really required to have bigint there?

~michael

Add Comment

Modify Ticket

Action
as assigned .
Author


E-mail address and user name can be saved in the Preferences.

 
Note: See TracTickets for help on using tickets.