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/
