[Top][All Lists]
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Phpgroupware-tracker] [bugs #9474] Cannot save a new trouble ticket
From: |
Dave Hall |
Subject: |
[Phpgroupware-tracker] [bugs #9474] Cannot save a new trouble ticket |
Date: |
Wed, 30 Jun 2004 00:35:01 -0400 |
User-agent: |
Mozilla/5.0 (X11; U; Linux i686; en-US; rv:1.6) Gecko/20040602 Firefox/0.8 |
This mail is an automated notification from the bugs tracker
of the project: phpGroupWare.
/**************************************************************************/
[bugs #9474] Latest Modifications:
Changes by:
Dave Hall <address@hidden>
'Date:
Wed 06/30/2004 at 01:42 (Australia/Melbourne)
What | Removed | Added
---------------------------------------------------------------------------
Assigned to | None | lpiepho
/**************************************************************************/
[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 20:35
Category: tts
Item Group: 0.9.16.000 release
Severity: 5 - Average
Priority: 5 - Normal
Resolution: None
Assigned to: lpiepho
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/