WARN: Scheduled reports error - Table 'traccar.tc_reports' doesn't exist

Tyson 3 years ago

I'm getting this warning on my server. The table doesn't exist, but I can't find this table even on a fresh installation.

WARN: Scheduled reports error - Table 'traccar.tc_reports' doesn't exist - SQLSyntaxErrorException (... < QueryBuilder:413 < DatabaseStorage:76 < TaskReports:76 < ...)
Anton Tananaev 3 years ago

It probably means that you took the source code from master instead of installing an official release.

Craenista 3 years ago

I have too anton, i tryin to build from source (no editting) and sending to dummy server ( has have ip public ).
do I have to make it manually if so in that table there are any fields

Anton Tananaev 3 years ago

Unless you're an expert and know exactly what you're doing, you should use code from the stable version.

Craenista 3 years ago

hihihi....just copy from schema source to installer/server directory and just solved.....thanks You Traccar is pretty systematical source

Tyson 3 years ago

Right, I'm using a version assembled from the master branch. Thanks for clarifying.

jay 3 years ago

Craenista - do I have to copy this https://github.com/traccar/traccar/blob/master/schema/changelog-5.6.xml to where in traccar folder.

jay 3 years ago

I am getting this same issue

WARN: Scheduled reports error - Table 'traccar.tc_reports' doesn't exist - SQLSyntaxErrorException (... < QueryBuilder:413 < DatabaseStorage:76 < TaskReports:76 < ...)

Even though I have installed from the official release on traccar.org

Anton Tananaev 3 years ago

You probably messed up your database schema by not using official versions. Now you need to manually fix it.

jay 3 years ago

Must I copy the schema folder from github to my server folder /traccar/schema

Anton Tananaev 3 years ago

It's too late for that. You have to manually fix your database schema.

jay 3 years ago

any idea how to fix on mysql workbench