anonymous wrote on Monday, December 27, 2010:
I offer this as both a “How I did it” doc and also to ask a question.
Finally I have everything moved to a new server after the following process:
1. OpenEMR ver 3.01 on old CentOS 4
2. Backed this up to emr_backup_tar file through “Admin menu”
3. Copied this file to new server along with “restore” script. New server Ubuntu 10.04 LTS
4. Ran “restore” script.
5. Changed version number in “var/www/openemr/interface/globals.php” file as from experience the old restore script screwed things up and gave me a blank “globals.php” file and when I overwrote this with an old one the version number was in the “2’s” which will not allow Ubuntu package to upgrade it.
6 Downloaded and installed new OpenEMR 3.2 package using Gebi.
7. Went off without a hitch.
Now everything works except the “Notes” in the new install. Now I get:
ERROR: query failed: SELECT id,date,body,user,title,assigned_to FROM pnotes AS p WHERE date LIKE ‘%%’ AND pid LIKE ‘944’ AND deleted != 1 AND activity = ‘1’ ORDER BY date DESC
Error: Unknown column ‘deleted’ in ‘where clause’
I realize this has something to do with the fact that the acl and mysql tables need to be upgraded however whenever I run the acl_upgrade.php and sql_uprgrade.php pages nothing loads in the browser window. It is blank. When I try to run these in a terminal obvious nothing happens because they stop at Line 1 at the “? php” because it is being run in a terminal.
Any ideas?
Thought about changing the "openemr/library/sqlconf.php file, set the $config variable to 0 ($config = 0;) but figured running setup on the Ubuntu package may really screw things up.
Any help would be appreciated and hopefully my help some others moving to a different server.
Thanks,
Clif