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

Corporate Office:

5624 S State Hwy FF

Battlefield, MO 65619

Office: 417.886.7542

Fax: 417.888.5011