by timr » Tue Feb 12, 2013 6:18 pm
I'm aware of that and didn't use the online update. These are the steps I took.
Been using OpenEMM 2011 since shortly after it was released with no problems.
UPGRADE to 2013 Steps
1. Renamed current folder to OpenEMMOLD.
2. Downloaded OpenEMM 2013 for Windows.
3. Unzipped and copied folders to c:/OpenEMM
4. Applied update script update_openemm-2011-2013.sql (located in USR_SHARE) directly to MySQL database.
5. Logged into OpenEMM. All data (mailings, customer data, etc.) available but get error (documented in previous post) when trying to view email or create new email.
6. Not mentioned in Windows Install Guide but applied openemm-2013.sql directly to database since above was not working.
7. Logged into OpenEMM. All current data from OpenEMM 2011 gone, but can create, view and send test emails.
From looking at the openemm-2013.sql script, it looks like it has statements with LOCK and UNLOCK to reload current data:
-- Dumping data for table `admin_group_permission_tbl`
but after openemm-2013.sql is ran on the database, none of the current data is restored. If I then, restore a backup from OpenEMM 2011, problem #5 re-occurs. I don't know why restoring data would roll back changes put in by openemm-2013.sql but it seems like that OpenEMM 2013 can't read emails created by OpenEmm2011 and I did not have this problem when I upgraded from 6.2 to 2011.