Error when attempting to generate "Home" tab

Bug #988454 reported by Chris Gregan
6
This bug affects 1 person
Affects Status Importance Assigned to Milestone
bugtimetracker
New
Undecided
Unassigned

Bug Description

Build Version/Date: 0.2~rev32

Environment used for testing: Precise

Summary:
sql alchemy error when trying to generate the home tab on the Dell and Sutton projects

Steps to Reproduce:
1) Load the sqlite db for dell or sutton
2) Click the home button

Expected result:
Home tab is generated

Actual result:
sqlalchemy.exc.OperationalError: (OperationalError) no such column: bugtask.date_reopened u'SELECT bugtask.id AS bugtask_id, bugtask.bug_id AS bugtask_bug_id, bugtask.project_id AS bugtask_project_id, bugtask.date_created AS bugtask_date_created, bugtask.date_closed AS bugtask_date_closed, bugtask.date_reopened AS bugtask_date_reopened \nFROM bugtask \nWHERE ? = bugtask.bug_id' (15396,)

Revision history for this message
Javier Collado (javier.collado) wrote :

This is because the database schema has been updated recently and an attempt to open a database that was generated with a previous revision of the code has been made.

I'm afraid there's no database migration path for now, so the solution for this is to regenerate the database. Anyway, I'll keep this bug opened and think about adding a clearer error message in the future.

To post a comment you must log in.
This report contains Public information  
Everyone can see this information.

Other bug subscribers

Remote bug watches

Bug watches keep track of this bug in other bug trackers.