Modify

Ticket #1265 (closed defect: fixed)

Opened 11 months ago

Last modified 11 months ago

lf_update crashes on issue without votes

Reported by: anonymous Owned by: jbe
Priority: major Milestone:
Component: Core Version: 2.0 beta
Keywords: Cc:

Description

As the title says.

Error while calling SQL function "check_issue"(...):
ERROR:  null value in column "winning_initiative_id" violates not-null constraint
CONTEXT:  SQL statement "INSERT INTO "battle" ( "issue_id", "winning_initiative_id", "losing_initiative_id", "count" ) SELECT "issue_id", "winning_initiative_id", "losing_initiative_id", "count" FROM "battle_view" WHERE "issue_id" =  $1 "
PL/pgSQL function "close_voting" line 46 at SQL statement
SQL statement "SELECT  "close_voting"( $1 )"
PL/pgSQL function "check_issue" line 118 at PERFORM

quickfix: removing not-null constraint from battle_view winning_initiative_id and losing_initiative_id

Attachments

Change History

comment:1 Changed 11 months ago by dark

  • Status changed from new to closed
  • Resolution set to fixed

This error is caused by a bug in the update script to core 2.0.0 and will be automatically fixed by updating to Core 2.0.9.

Please report again, if 2.0.9 or higher is affected for you.

View

Add a comment

Modify Ticket

Action
as closed
The resolution will be deleted. Next status will be 'reopened'
Author


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

 
Note: See TracTickets for help on using tickets.