[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: |
Sun, 16 Jan 2005 20:24:03 +0000 |
User-agent: |
Mozilla/5.0 (X11; U; Linux i686; en-US; rv:1.7.5) Gecko/20041128 Firefox/1.0 (Debian package 1.0-4) |
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/
[Prev in Thread] |
Current Thread |
[Next in Thread] |
- [Phpgroupware-tracker] [bugs #9474] Cannot save a new trouble ticket,
Dave Hall <=