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: mailto:david.zauss@russellcellular.com david.zauss@russellcellular.com cid:image001.jpg@01CA6D1D.DA52F770 LOGO.gif Corporate Office: 5624 S State Hwy FF Battlefield, MO 65619 Office: 417.886.7542 Fax: 417.888.5011 http://www.russellcellular.com www.russellcellular.com
