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 < [email protected]> 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: *[email protected] > > * * > > * * > > * * > > * **[image: cid:[email protected]]*** > > *[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/ >
<<image001.jpg>>
<<image003.png>>
--------------------------------------------------------------------- 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/
