error at CREATE INDEX for fixtime

Alejandro2 years ago

when trying to create index for fixtime with sql command:

CREATE INDEX idx_positions_fixtime ON tc_positions (fixtime);

I got this error:

SQL create index `idx_positions_fixtime` on `tc_positions` (`fixtime`) failed : Invalid default value for 'devicetime'

Please need help

Anton Tananaev2 years ago

Set SQL mode to empty.

Alejandro2 years ago

Thank you, It worked now!