Error while creating new ticket

Your database is running in strict mode. Either switch the database to the old sql_mode (set sql_mode='') or change the definition of the field updated in table project_tickets.

To change the field updated, open phpMyAdmin on your database and paste the SQL below in an SQL window, change PP086_ to your prefix and press Go in the SQL window:

ALTER TABLE `PP086_project_tickets` CHANGE `updated` `updated` VARCHAR( 20 ) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL DEFAULT NULL

Background info:

Switch database to strict mode, perform insert, check warnings:

set sql_mode=strict_all_tables;
INSERT INTO `PP086_project_tickets` VALUES (8, 36, 5, 0, 0, 'projectcategoryt', 'defect', 'mafmmsfaDLFMSDFD''SLF''L''gds''v,ds,v''ls''v,sd,V''DLv''lDS', 'minor', 'opened', 0, '0000-00-00 00:00:00', 0, '2010-11-25 16:11:47', 1, '2010-12-14 21:44:50', 1, '');
show warnings;

Result:

Error
SQL query:
INSERT INTO `PP086_project_tickets`
VALUES ( 7, 36, 5, 0, 0, 'projectcategoryt', 'defect', 'mafmmsfaDLFMSDFD''SLF''L''gds''v,ds,v''ls''v,sd,V''DLv''lDS', 'minor', 'opened', 0, '0000-00-00 00:00:00', 0, '2010-11-25 16:11:47', 1, '2010-12-14 21:44:50', 1, '' ) ;

MySQL said: Documentation #1265 - Data truncated for column 'updated' at row 1

Switch strict mode off and try again

set sql_mode='';
INSERT INTO `PP086_project_tickets` VALUES (9, 36, 5, 0, 0, 'projectcategoryt', 'defect', 'mafmmsfaDLFMSDFD''SLF''L''gds''v,ds,v''ls''v,sd,V''DLv''lDS', 'minor', 'opened', 0, '0000-00-00 00:00:00', 0, '2010-11-25 16:11:47', 1, '2010-12-14 21:44:50', 1, '');
show warnings;

Result:

Your SQL query has been executed successfully (Query took 0.0003 sec)

Error while creating new ticket

Search

User login