localprojects/Change-By-Us — Issue #21: Unknown column 'project_need.subtype' in 'field list'
Author: cvee
Created: 2012-01-06 21:19:59+00:00
State: open

Creating a project results in the error:

(OperationalError) (1054, "Unknown column 'project_need.subtype' in 'field list'") 'SELECT project_need.id AS project_need_id, project_need.type AS project_need_type, project_need.subtype AS project_need_subtype, project_need.request AS project_need_request, project_need.quantity AS project_need_quantity, project_need.description AS project_need_description, project_need.address AS project_need_address, project_need.date AS project_need_date, project_need.time AS project_need_time, project_need.duration AS project_need_duration, project_need.project_id AS project_need_project_id, project_need.event_id AS project_need_event_id \nFROM project_need \nWHERE %(param_1)s = project_need.project_id ORDER BY project_need.id DESC' {'param_1': 1L}

Python	/home/cbu/cbudc/.env/local/lib/python2.7/site-packages/MySQLdb/connections.py in defaulterrorhandler, line 35
Web	GET http://cbudc.istrategylabs.com:8080/project/1

In sql/models.sql the CREATE TABLE `project_need` block is missing the definition of the `subtype` column.