I just ran the patch on my TEST server last night and it caused some issues. It made changes to the payment table and caused my fees to not function. I had to reload the table to repair this.
I see that it also makes some changes to the calendar. Unfortunately, I did not have any test appts on my test server to see the changes the patch would make prior to running the patch (dumb, I know). I have just hand entered over 200 appts that I don’t want to lose. I am also having a script written to upload my old appts (over 600), and I don’t want to have to do this twice.
How can I run the patches without losing data or undergoing unwanted changes in the SQL tables? Of course, I need this patch for the 5010 updates.
Before you do anything else I suggest that you learn how to backup and restore your system! That way your “TEST” server could also be your backup server and you can see how things change.
One option is the “Backup” function under administration. However, people have had problems with that in the past
An understanding of how to use mysqldump from the command line would be a good start.
That said, also be aware that X12 claim generation is currently broken in patch 8.
I did see that there were some issues with the backup function running under Windows, so I did do an xcopy of my entire server (test server) folder as suggested by Joe Holzer in the OpenEMR manual under “Windows OpenEMR Backup and Recovery” with the following arguments ( /d /e /c /i /f /h /k /y) prior to installing the patch.
I will look into how to use the mysqldump command, and I am waiting for the X12 claim generation to be resolved prior to updating my office server.
My orginal question still stands, however, which is what is the best way to apply a patch to cause the least amount of problems on your existing installation?
So, to control what sql_patch.php script does to the database, you could always hack away at the sql/patch.php script (this isn’t really recommended, but looking through this script will give you a good idea of the database changes).
Hi everybody
I have problem installing updates in 4.1.0 9. I use Ubuntu sever 10.4. First I couldn’t copy the zip file to the openemr directory so I had to activate root user and I was able to do it. When I run the sqlpatch Apache doesn’ t find anything.I tried to update patches before in openemr and I thought I succeed but I was wrong.Last week I realized of this when I updated the xampp version without any problem .Since I upgraded from version 3 to 4.1 I decided to uninstall the openemr and I ereinstalled it in graphical Mode but without luck. It is still the same problem. Since the upgrade zip file doesn’t unzip the sql_patch.php I copied from the xamp update but It didn’ t work anyway. I would appreciate any help on this issue