phpgroupware-users
[Top][All Lists]
Advanced

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Re: [phpGroupWare-users] TTS Error (New Ticket)


From: Sigurd Nes
Subject: Re: [phpGroupWare-users] TTS Error (New Ticket)
Date: Thu, 27 Jan 2011 21:12:23 +0100
User-agent: Mozilla/5.0 (X11; U; Linux i686; en-US; rv:1.9.2.13) Gecko/20101208 Lightning/1.0b2 Thunderbird/3.1.7

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



reply via email to

[Prev in Thread] Current Thread [Next in Thread]