Event save error - Unknown column 'eventTime' in 'field list' 4.12
... traccar-web built from github repo https://github.com/traccar/traccar-web.git (do have some servertime replaced with eventTime, but web ui still not working)
Server installed on linux: traccar-linux-64-4.12.zip
as per changelog 4.13
These two statement seem to contradict each other. I think we are missing some context here.
Yes. actually I work locally on my PC with the latest version from Github, which I compile and copy to linux server, but I forgot to upload the /schema and /templates folders, also the new default.xml file, where <entry key='database.selectEvents'> was modified to replace servertime with eventTime.
But shouldn't also the index key
event_deviceid_servertime
be modified
to event_deviceid_eventtime
as well?
All working now. Thx.
Hello,
Server installed on linux: traccar-linux-64-4.12.zip downloaded from traccar.org
table tc_events, is created with column name servertime instead of eventTime , as per changelog 4.13:
<renameColumn tableName="tc_events" columnDataType="TIMESTAMP" oldColumnName="servertime" newColumnName="eventtime" />If rename column to eventtime, the events are saved, but the web ui crashes and does not show the events report.
Any advice where to change servertime to eventTime in web ui ?
Thx