1
The system is on a common host with the following config:
- Apache 2.4.25
- PHP 5.4.45
- Mysql 5.5.58-cll
It is intended for O.S. control and each user has a login with his password.
During the development and testing was all OK, but it has been happening, now that it has been released to users, from the system mixing data from the O.S. At first I suspected something involving the sessions, but reading about, ended up not making much sense, because it also occurs among users who are not even on the same network.
Ex.:
- User X is editing O.S 01
- User Y is editing O.S 02
When X saves his O.S. (AJAX prepares the data and sends via POST to save.php) the page reloads with some data from O.S of Y It’s not always the same data and it doesn’t always happen.
I don’t know where/how to look for the problem, so much so that I would like to provide the code for analysis, but I don’t even imagine what part of it I could include here.
The problem may even be the session?
Could be some server limitation?
Or it may even be in the save.php script being used simultaneously?
I was also wary of config.php (access to the database), because it uses a single user. This has some relation or what differs access is the session?
Can you give an example or print of truncated, unbtruncated data? To try to verify if there is a pattern. Truncating would be cutting information or it would be that as there are 2 users moving the same record ends up overwriting the other?
– Don't Panic
images
– Diogo Muniz
The trunc03.jpg image is a case where the problem occurred.
– Diogo Muniz
@Everson "Would trunking be cutting a piece of information or would it be that as there are 2 users moving the same record ends up overwriting the other one?" From what I could understand, the editing was not simultaneous....
– Diogo Muniz