Mysql Backup Import Failure

smsoousa 9 years ago

Hello Anton.
I had a small problem with the system, I had to reinstall. I made the backup of the database for complete, I installed the system from scratch, I imported the backup, however only the devices return, the users do not appear, the system settings are zero, everything is as a start, only with the previously registered devices . The strangest thing is that the data is in the database, like all users, the system settings, and so on. Can you tell me what it can be?

smsoousa 9 years ago
database sistema
smsoousa 9 years ago

When I try to access with the data of one of the users registered, I get this error:

error
Anton Tananaev 9 years ago

Most likely you have some foreign keys problem in the database. You have references to non-existing objects, so some service call fails with null pointer exception.

smsoousa 9 years ago

Could you suggest some solution? I made the backup through mysqldump, and restored it, but as the image does not appear.

Anton Tananaev 9 years ago

I don't even know what version of Traccar you are using.

smsoousa 9 years ago

Version 3.11

Anton Tananaev 9 years ago

The error indicated that user doesn't exist. Usually it means that you have manually tempered with database and Traccar internal cache is out of date. I would recommend restarting service.

smsoousa 9 years ago

Yes, I have tried the reboot but it continues the same way.

Anton Tananaev 9 years ago

Then back to my previous comment. You have to find wrong references in the database and remove them.