[Phpgroupware-tracker] [bugs #9474] Cannot save a new trouble ticket

[Dave Hall]

This is an automated notification sent by Savannah.
It relates to:
                bugs #9474, project phpGroupWare

==============================================================================
 LATEST MODIFICATIONS of bugs #9474:
==============================================================================

               Posted by: Dave Hall <skwashd>
               Posted on: 2005-01-16 20:24 (Australia/Melbourne)
    _______________________________________________________

             Assigned to:                 lpiepho -> fipsfuchs              


==============================================================================
 OVERVIEW of bugs #9474:
==============================================================================

URL:
  <http://savannah.gnu.org/bugs/?func=detailitem&item_id=9474>

                 Summary: Cannot save a new trouble ticket
                 Project: phpGroupWare
            Submitted by: None
            Submitted on: Sun 06/27/2004 at 20:35
              Item Group: 0.9.16.000 release
                Category: tts
                Severity: 5 - Average
                Priority: 5 - Normal
                  Status: None
                 Privacy: Public
             Assigned to: fipsfuchs
             Open/Closed: Open
       Component Version: MDK
        Platform Version: GNU/Linux - Mandrake
         Reproducibility: Every Time
         Planned Release: None
           Fixed Release: 

    _______________________________________________________


Attempt to save a new troubleticket gives this error msg:

"
Database error: Invalid SQL: insert into phpgw_tts_tickets * * * *
(ticket_group,ticket_priority,ticket_owner,ticket_assignedto,ticket_subject,ticket_category,ticket_billable_hours,ticket_billable_rate,ticket_status,ticket_deadline,ticket_effort,ticket_type,ticket_platform,ticket_attachment,ticket_details)
values ('7','8','13','13','a
test','2','0.00','0.00','O','--','','','','','test data ')
 MySQL Error: 1064 (You have an error in your SQL syntax. Check the manual
that corresponds to your MySQL server version for the right syntax to use
near '* * * * (ticket_group,ticket_priority,ticket_owner,ticket_assi)
 
File: /var/www/html/phpgroupware/tts/newticket.php
Line: 88

Session halted. "



phpgw_tts_tickets does not have some of the fields referenced by the insert.
I made the following change at ~line 70 to remedy the problem: 

                $GLOBALS['phpgw']->db->query("insert into phpgw_tts_tickets
(ticket_group,ticket_priority,ticket_owner,"
                        .
"ticket_assignedto,ticket_subject,ticket_category,ticket_billable_hours,"
                        . "ticket_billable_rate,ticket_status,ticket_details) 
values ('"
                        . $_POST['ticket']['group'] . "','"
                        . $_POST['ticket']['priority'] . "','"
                        . $GLOBALS['phpgw_info']['user']['account_id'] . "','"
                        . $_POST['ticket']['assignedto'] . "','"
                        . $_POST['ticket']['subject'] . "','"
                        . $_POST['ticket']['category'] . "','"
                        . $_POST['ticket']['billable_hours'] . "','"
                        . $_POST['ticket']['billable_rate'] . "','O','"
                        . addslashes($ticket['details']) . 
"')",__LINE__,__FILE__);


Note that I removed the offending field references. I assume that those
fields represent planned but not yet implemented new functionality.






==============================================================================

This item URL is:
  <http://savannah.gnu.org/bugs/?func=detailitem&item_id=9474>

_______________________________________________
  Message sent via/by Savannah
  http://savannah.gnu.org/