TTS Error (New Ticket)
Steven Gilroy <[email protected]> Wed, 26 Jan 2011 12:53:17 -0700 (MST)
| Newsgroups | gmane.comp.web.phpgroupware.general |
|---|---|
| Organization | phpGroupware Forums |
| Message-ID | <[email protected]> |
I just recently migrated from a Linux server to a Windows 2008 R2 server =
running IIS, PHP5 and MySQL 5.1.
Whenever a user tries to create a new trouble ticket they get the followi=
ng:
Database error: Invalid SQL: insert into phpgw_tts_tickets (ticket_group,=
ticket_priority,ticket_owner,ticket_assignedto,ticket_subject,ticket_cate=
gory,ticket_billable_hours,ticket_billable_rate,ticket_status,ticket_dead=
line,ticket_effort,ticket_type,ticket_platform,ticket_attachment,ticket_d=
etails) values ('1','5','4','7','test','7','0','0','O','0--0','','0','0',=
'0','test')
MySQL Error: 1364 (Field 'ticket_lastmod' doesn't have a default value)
File: C:\inetpub\wwwroot\intranet\tts
ewticket.php
Line: 97
Session halted.Sent from the phpGroupWare forums @ http://forums.phpGroup=
Ware.org