error at CREATE INDEX for fixtime

Alejandro10 months 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 Tananaev10 months ago

Set SQL mode to empty.

Alejandro10 months ago

Thank you, It worked now!