Re: TTS Error (New Ticket)

On 01/26/2011 08:53 PM, Steven Gilroy wrote:
>
>
> 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 following:
>
> 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 ('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.phpGroupWare.org
>

Hi Steven

You could try to set the default value for the column 'ticket_lastmod' in table 
'phpgw_tts_tickets' to 0.

Regards

Sigurd