doubt in update 5.0 to 5.3
Indeed, I made a backup of my version 5.0 database and installed it in versions 5.1 and 5.2, I changed the information of the traccar xml in both versions with the information of my mysql of version 5.0 and I connected without problem, but when I went to carried out in 5.3 does not work for me, it should be noted that I tried to do several tests.
- I was improving from tracking from 5.0 > 5.1 after 5.1 > 5.2 and without a problem when I went to update from 5.2 > 5.3 without a doubt and the same mysql parameters that worked for me for 5.1 and 5.2 do not work for me in 5.3
https://prnt.sc/ltXN5MBgaHvt
I am totally grateful to someone who can guide me.
Have you synchronized the structure of database from 5.0 to 5.3?
Did you take a backup from old database including data and structure or only from your data(rows)?
colleague answering your question the bakup performed is the normal one that is done I will leave the command used also it loads me well in version 51. and 5.2 --> mysqldump -u root -p traccarDB > traccarDB.sql <-- I load it, what generated doubt in me is the synchronization that you are talking about although I don't think so but there is the possibility, I am attentive to a more precise suggestion to investigate and thus give a solution, thank you very much for your time
cordial greeting thank you very much for your contribution, make the backup which when I update to 5.1 or 5.2 there is no problem.
I also tried to do it progressively from 5.0 > 5.1 > 5.2 but in 5.3 it gives me a connection problem, I will attach an image of the log.
I emphasize that the problem in 5.3 I use the same backup in 5.1 and 5.2 without problem, it should be noted that in 5.3 it does not start when I leave the configuration of the traccar.xml file as it was in 5.1 and 5.2 since that is not touched when update, but in 5.3 it precisely gives me an error I will attach a photo of the mysql configuration in version 5.3
https://prnt.sc/4hKU19m1zJIF
and it is solved by changing the database configuration in taccar xml to h2 but that solution does not work because I lose all the information..
I look forward to any input.
Your last log shows that you're not using MySQL database. You should be more careful.
You don't need to update versions one by one. Upgrade to 5.3 and provide logs.
Kind regards Anton, sorry for the delay I was doing tests but I didn't find a solution, following your suggestion I installed version 5.3 directly but the service doesn't start,
I did the same test of 5.0 > 5.2 and there was no problem
I will attach an image of the traccar log
This image is missing.
I restart the virtual machine and now this throws me an error saying that the filex email table is duplicated, I will have to delete it manually in mysql, which I can solve.
another suggestion would also not be bad if what I thought is wrong
Column fixedemail was added only in version 5.3. Why do you already have it?
NO, I have not created or duplicated anything, maybe it was done automatically during the update, the only thing I did was update it from v 5.0 > 5.3 nothing else.
I even did it on the test machine as is and it is created automatically because if I go from version 5.0 to 5.3 it does not present any problem.
It means the first upgrade has failed. You need to figure out that original issue, not the issue with the duplicate column.
images of the error logs after having passed from 5.0 > 5.3
The second screenshot is showing that Traccar is running fine.
Kind regards, I write the post because I am planning to upgrade the server I currently have it in 5.0 and in a test vps install 5.3 and load the mysql copy of my 5.0 server in 5.3 place the updated database information Just as I have it in 5.0 but it doesn't load me when I go to place the information in the traccar.xml file, even the version 5.3 server stops working from mysql to access and I restart the service and it stops working.
How to upgrade visualize in the documentation and I'm not doing anything wrong since if I install version 5.0 and put the mysql information in the test vps it works for me without any problem.
I kindly request your support in case you have to place other parameters, I would be totally grateful for some guidance so as not to start the database from scratch.
https://prnt.sc/Y3E1OVVJMk4r
https://prnt.sc/bJKqz1Ix7G6r
https://prnt.sc/CAss3MzH3jjc
the information is not relevant since it is a test