Failed to create indexes on tc_positions.fixTime

Malouda Don8 months 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 Tananaev8 months ago

You have to set sql_mode=''.