Mysql Backup Import Failure

smsoousa8 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?

smsoousa8 years ago
database sistema
smsoousa8 years ago

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

error
Anton Tananaev8 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.

smsoousa8 years ago

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

Anton Tananaev8 years ago

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

smsoousa8 years ago

Version 3.11

Anton Tananaev8 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.

smsoousa8 years ago

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

Anton Tananaev8 years ago

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