try insert into ticket_state_type (name, comments, create_time, create_by, change_time, change_by) values (’own’,’Own state type’, sysdate(), 1, sysdate(), 1); On Tue, Feb 23, 2010 at 9:04 PM, David Zauss < david.zauss@russellcellular.com> wrote:

I am attempting to add a Ticket State Type but keep getting the error “ERROR 1364 (HY000): Field ‘create_time” doesn’t have a default value”.

I’m following the directions in the admin book:

linux:~# mysql -p

Enter password:

Welcome to the MySQL monitor. Commands end with ; or \g.

Your MySQL connection id is 23 to server version: 5.0.16-Debian_1-log

Type ’help;’ or ’\h’ for help. Type ’\c’ to clear the buffer.

mysql> use otrs;

Reading table information for completion of table and column names

You can turn off this feature to get a quicker startup with -A

Database changed

mysql> insert into ticket_state_type (name,comments) values (’own’,’Own

state type’);

Query OK, 1 row affected (0.00 sec)

mysql> quit

Bye

linux:~#

I’m running OTRS v2.4.7 in a Windows environment. I had to install MySQL Server v5.1 before installing OTRS just to get access to the database. I’m using the MySQL Command Line Client to attempt the change.

I have no Linux or SQL knowledge so any help would be greatly appreciated. If you need any additional information please let me know.

*David Zauss*

Senior Office Assistant

Information Technology

*Main: *417.886.7542 ext 1201

*Email: *david.zauss@russellcellular.com

* *

* *

* *

* **[image: cid:image001.jpg@01CA6D1D.DA52F770]***

*[image: LOGO.gif] **Corporate Office:*

*5624 S State Hwy FF*

*Battlefield, MO 65619 *

*Office: *417.886.7542 **

*Fax: *417.888.5011

www.russellcellular.com

--------------------------------------------------------------------- OTRS mailing list: otrs - Webpage: http://otrs.org/ Archive: http://lists.otrs.org/pipermail/otrs To unsubscribe: http://lists.otrs.org/cgi-bin/listinfo/otrs

NEW! ENTERPRISE SUBSCRIPTION - Get more information NOW! http://www.otrs.com/en/support/enterprise-subscription/