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

[anonymous]

This mail is an automated notification from the bugs tracker
 of the project: phpGroupWare.




/**************************************************************************/
[bugs #9474] Full Item Snapshot:

URL: <http://savannah.gnu.org/bugs/?func=detailitem&item_id=9474>
Project: phpGroupWare
Submitted by: 0
On: Sun 06/27/2004 at 16:35

Category:  tts
Item Group:  0.9.16.000 release
Severity:  5 - Average
Priority:  5 - Normal
Resolution:  None
Assigned to:  None
Status:  Open
Component Version:  MDK
Platform Version:  GNU/Linux - Mandrake
Reproducibility:  Every Time


Summary:  Cannot save a new trouble ticket

Original Submission:  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.











For detailed info, follow this link:
<http://savannah.gnu.org/bugs/?func=detailitem&item_id=9474>

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