search

vitalidze / traccar-web

Traccar Web UI mod
http://traccar.litvak.su/
152 stars 145 forks source link

Remote procedure call error #1122 #1235

Open akmal1999 opened 3 years ago

akmal1999 commented 3 years ago

remote procedure call error.txt

Also, I can not see the devices in the list.

akmal1999 commented 3 years ago

I have attached error file.

akmal1999 commented 3 years ago

1 ---- Caused by: java.sql.SQLException: Field 'attributes' doesn't have a default value

2 --- INFO | jvm 1 | 2021/03/24 19:01:55 | SEVERE: Error during scheduled task execution INFO | jvm 1 | 2021/03/24 19:01:55 | javax.persistence.EntityNotFoundException: Unable to find org.traccar.web.shared.model.Position with id 13227048 INFO | jvm 1 | 2021/03/24 19:01:55 | at org.hibernate.jpa.boot.internal.EntityManagerFactoryBuilderImpl$JpaEntityNotFoundDelegate.handleEntityNotFound(EntityManagerFactoryBuilderImpl.java:183)

akmal1999 commented 3 years ago

Please note that I have cleand the positions table.

vitalidze commented 3 years ago

If you have cleaned the positions table then you have to update other tables, which have links to the positions table. For example, devices have a link to the latest position.

akmal1999 commented 3 years ago

What you mean is if delete positions, I need to delete the devices as well that has link to the positions?

Also, I how would clean positions safely without deleting the devices or how would decouple this process?

akmal1999 commented 3 years ago

What I am going through right now is all devices do not show up and I get a remote procedure call error. I recreated the database by dropping it from mysql and tried: I get Remote Procedure call error when I:

  1. create users
  2. creating devices

I attached the errors at the top of the page.

akmal1999 commented 3 years ago

If you have cleaned the positions table then you have to update other tables, which have links to the positions table. For example, devices have a link to the latest position.

where do I need to clean the links to the positions from the devices so devices do not look in the link that calls for the positions?

vitalidze commented 3 years ago

You can get an idea from this https://github.com/vitalidze/traccar-web/issues/820#issue-172532093