Query not provided when database.generateQueries = false on traccar 3.14

E-Solution6 years ago

Hi Anton,

I want to set custom table name on traccar 3.14 so i set database.generateQueries as false on the default.xml

<entry key='database.generateQueries'>false</entry>

after that i got below info on log

INFO: Query not provided: database.selectUsers
INFO: Query not provided: database.selectUserUsers
INFO: Query not provided: database.selectGroups
INFO: Query not provided: database.selectDevices
INFO: Query not provided: database.selectServers
INFO: Query not provided: database.selectGroups
INFO: Query not provided: database.selectDevices
INFO: Query not provided: database.selectUserGroups
INFO: Query not provided: database.selectUserDevices
INFO: Query not provided: database.selectGroups
INFO: Query not provided: database.selectGeofences
INFO: Query not provided: database.selectUserGeofences
INFO: Query not provided: database.selectGroupGeofences
INFO: Query not provided: database.selectDeviceGeofences
INFO: Query not provided: database.selectDevices
INFO: Query not provided: database.selectDevices
INFO: Query not provided: database.selectCalendars
INFO: Query not provided: database.selectUserCalendars
INFO: Query not provided: database.selectNotifications
INFO: Query not provided: database.selectAttributes
INFO: Query not provided: database.selectUserAttributes
INFO: Query not provided: database.selectGroupAttributes
INFO: Query not provided: database.selectDeviceAttributes
INFO: Query not provided: database.selectDevices
INFO: Query not provided: database.selectDrivers
INFO: Query not provided: database.selectUserDrivers
INFO: Query not provided: database.selectGroupDrivers
INFO: Query not provided: database.selectDeviceDrivers
INFO: Query not provided: database.selectDevices

Can you advice what query that i need to set on config?

Anton Tananaev6 years ago

I'm not sure what you are trying to do.

E-Solution6 years ago

Hi Anton,

Thanks for reply, I want to change table name on the query manually on config, below is the example

Original query on config:

<entry key='database.deleteEvents'>
        DELETE FROM events WHERE serverTime &lt; :serverTime
</entry>

Custom query on config

<entry key='database.deleteEvents'>
        DELETE FROM bf_events WHERE serverTime &lt; :serverTime
</entry>

I want to know whats the original query that you set for:

database.selectUsers
database.selectUserUsers
database.selectGroups
database.selectDevices
database.selectServers
database.selectGroups
database.selectDevices
database.selectUserGroups
database.selectUserDevices
database.selectGroups
database.selectGeofences
database.selectUserGeofences
database.selectGroupGeofences
database.selectDeviceGeofences
database.selectDevices
database.selectDevices
database.selectCalendars
database.selectUserCalendars
database.selectNotifications
database.selectAttributes
database.selectUserAttributes
database.selectGroupAttributes
database.selectDeviceAttributes
database.selectDevices
database.selectDrivers
database.selectUserDrivers
database.selectGroupDrivers
database.selectDeviceDrivers
database.selectDevices

I already try to check old version config too but cannot found it

Anton Tananaev6 years ago

You can find most queries in the old config:

https://github.com/tananaev/traccar/blob/v3.13/setup/default.xml