As decribed, but all context and story:
I am implementing traccar for my enterprise. I need login with "login" field in "Users" table, and store a valid email in "email" field, to send email reports.
When i edit an user, from admin session, email data is overwritten by login field data, and login field data is blanked.
Before modify:
After modify:
After that, i edit traccar.xml file, adding this entry:
SELECT * FROM tc_users
WHERE login = :email
</entry>```
and this solve my problem (apparently): I edit whatever user, and no email overwritten, and no login blanked.
But, when I enter to "Account" or "Users" and modify my own account,
![Menu](https://user-images.githubusercontent.com/66650830/84092729-e854b500-a9bd-11ea-8b04-f9df5b021da9.png)
login data is "blanked", and email is preserved, and this is a big problem with data consistency, because this traccar users are logining by login, not email:
![login](https://user-images.githubusercontent.com/66650830/84091660-b7bf4c00-a9ba-11ea-93fb-6f0d5bf44ad9.png)
I've search throuhgout forums but no similar info to help me fix the problem, only references about LDAP integration, but my traccar isn't with it, so I think is convenient handle this as an important bug, unless a fix or solutions already exists.
Thanks a lot.
What happens if you do following:
- Manually set "login" in the database
- Restart Traccar service
- Edit email from the web app
Does the login get cleared?
Now, login was not cleared after restart Traccar service and editing email.
There was a a problem with my database consistency, because of manual setting in the table?
Yes, Traccar has internal cache which is not updated when you manually edit database.
Ok, i never did a traccar service restart on my previous tests.
Thank you again.
As decribed, but all context and story:
I am implementing traccar for my enterprise. I need login with "login" field in "Users" table, and store a valid email in "email" field, to send email reports.
When i edit an user, from admin session, email data is overwritten by login field data, and login field data is blanked.
Before modify:
After modify:
After that, i edit traccar.xml file, adding this entry: