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

Tyson2 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 Tananaev2 years ago

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

Craenista2 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 Tananaev2 years ago

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

Craenista2 years ago

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

Tyson2 years ago

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

jay2 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.

jay2 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 Tananaev2 years ago

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

jay2 years ago

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

Anton Tananaev2 years ago

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

jay2 years ago

any idea how to fix on mysql workbench