Forum OpenACS Q&A: Response to problems with new-ticket

Collapse
Posted by Al Walworth on
The earlier response was too superficial. The underlying problem is that ticket_project_id isn't getting set in im_projects, so intranet/customers/view.tcl finds nothing there and concludes it should invite you to "create a ticket tracker" for the project, when it ought to be giving you a link to a list of the project's tickets. The same happens with intranet/projects/view.tcl.

You can fix the problem by adding the following at the end of the "if {$check == 0} { " block in intranet/projects/ticket-edit.tcl (before the '}'):

ns_db dml $db "update im_projects set ticket_project_id = $new_id where group_id = $group_id"
That will give you correct behavior for future projects. For ones you've already created (and for which you've "created a ticket tracker" with the deficient code), you can manually add the missing data as follows:

  1. In psql, use "select * from ticket_projects;" to find the project's project_id.
  2. Use "select * from ticket_project_teams;" to determine the corresponding team_id.
  3. Finally, supposing the project_id is 10 and the team_id is 38, use "update im_projects set ticket_project_id = 10 where group_id = 38;" to fix that project's entry.