error at CREATE INDEX for fixtime

Alejandro9 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 Tananaev9 months ago

Set SQL mode to empty.

Alejandro9 months ago

Thank you, It worked now!