Bug #163

Opening a new project ticket fails on SQL insert.

Added by Oscar Bajner over 2 years ago. Updated over 2 years ago.

Status:Closed Start:08/08/2009
Priority:Normal Due date:
Assigned to:Jeremy Bush % Done:

100%
Category:Projects
Target version:0.7.3
Resolution:fixed

Description

Reproduce: Select Projects and add a new ticket.

Error message:

There was an SQL error: Incorrect integer value: '' for column 'close_date' at row 1 - INSERT INTO `AI_tickets` (`id`, `user_id`, `created_by`, `project_id`, `description`, `creation_date`, `close_date`, `complete`, `billable`, `invoiced`, `invoice_id`, `operation_type_id`, `rate`) VALUES (NULL, '1', '1', '1', 'Setup website for prez.', 1249741848, '', 0, '1', 0, NULL, '1', 0)
./htdocs/argentumsvn/system/libraries/drivers/Database/Mysql.php [392]:

Setup: Windows Vista, Apache 2.2.6, PHP 5.2.6, MySQL 5.1.0, argentum svn trunk

Proposed solution: Patch attached. (patch04.diff)
Inital _dates must be set to integer values in the model.
in ./models/ticket.php

patch04.diff (646 Bytes) Oscar Bajner, 08/08/2009 11:49 am

Associated revisions

Revision 261
Added by Jeremy Bush over 2 years ago

Fixing #163.

History

#1
Updated by Jeremy Bush over 2 years ago

  • Status changed from New to Closed
  • % Done changed from 0 to 100

Applied in changeset r260.

#2
Updated by Jeremy Bush over 2 years ago

  • Resolution set to fixed

Also available in: Atom PDF