Failed to create indexes on tc_positions.fixTime

Malouda Dona year ago

I get the following database error

#1067 - Invalid default value for 'devicetime'"  on executing the query "CREATE INDEX idx_positions_fixtime ON tc_positions (fixtime);

the devicetime column structure is

Type: TIMESTAMP
default: 0000-00-00 00:00:00

Anton Tananaeva year ago

You have to set sql_mode=''.