Sun 27 Jun 2004 08:35:29 PM UTC, 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.
|