Also note that we are using SQL CE for our db. I think this is probably the culprit as I keep getting connection timeouts. I have tried increasing the connection timeout as well and I still get timeouts. Then I have to copy the database over the partially updated one and start all over again on each try. Its extremely cumbersome and I still have not been able to get umbraco to update. Any suggestions?
Thanks Dan. So I was able to actually go all the way up to 7.4.3. However when going from 7.4.3 to 7.5 it crashes everytime and trying to execute this SQL migration script:
DELETE FROM cmsPropertyData WHERE id NOT IN (SELECT MIN(id) FROM cmsPropertyData GROUP BY contentNodeId, versionId, propertytypeid HAVING MIN(id) IS NOT NULL)
I downloaded a sql CE editor and ran the statement directly and that also dead locks the editor so this SQL seems to be problematic. I dont see how I can get around this. If I attempt to upgrade to 7.5 it will execute this statement implicility. I have tried increasing the connection string timeout and that doesnt help either.
Out of interest, can you run the statement as a select to see how many rows you get back - something like:
SELECT COUNT(*) FROM cmsPropertyData WHERE id NOT IN (SELECT MIN(id) FROM cmsPropertyData GROUP BY contentNodeId, versionId, propertytypeid HAVING MIN(id) IS NOT NULL)
(Not sure of SQL CE syntax so might need to tweak).
So with a lot of blood sweat and tears, doing the incremental upgrade was the only way I could get up to the latest. Took a whole day, a couple of roll backs and starting over but I finally got there.
I think your issues must be related to using SQL-CE. I've upgraded sites from 7.2 to 7.7 using SQL Server and they have been OK.
Sometimes it's useful to prune Umbraco - especially the previous versions of pages (as Umbraco stores a version of a page for every publish). This can get huge.
There's a few SQL scripts around to do this - but I'm not sure if they work with SQL-CE, but maybe worth investigating:
Upgrading from 7.2.8 to 7.74
I have been spent a day now trying to upgrade Umbraco from 7.2.8 to 7.7.4 I have tried enableLegacy = True
along with all these tips:
https://our.umbraco.org/forum/getting-started/installing-umbraco/74654-from-manual-to-nuget-upgrade#comment-256084
https://our.umbraco.org/forum/using-umbraco-and-getting-started/80031-journey-to-upgrade-umbraco-from-728-to-latest
https://our.umbraco.org/forum/using-umbraco-and-getting-started/85496-help-cant-login-after-upgrading-to-v76
Also note that we are using SQL CE for our db. I think this is probably the culprit as I keep getting connection timeouts. I have tried increasing the connection timeout as well and I still get timeouts. Then I have to copy the database over the partially updated one and start all over again on each try. Its extremely cumbersome and I still have not been able to get umbraco to update. Any suggestions?
Just a suggestion, but maybe upgrade it incrementally? So try upgrading to (say) 7.4 then to 7.6 then to 7.7.4 or some other steps in between?
Thanks Dan. So I was able to actually go all the way up to 7.4.3. However when going from 7.4.3 to 7.5 it crashes everytime and trying to execute this SQL migration script:
DELETE FROM cmsPropertyData WHERE id NOT IN (SELECT MIN(id) FROM cmsPropertyData GROUP BY contentNodeId, versionId, propertytypeid HAVING MIN(id) IS NOT NULL)
I downloaded a sql CE editor and ran the statement directly and that also dead locks the editor so this SQL seems to be problematic. I dont see how I can get around this. If I attempt to upgrade to 7.5 it will execute this statement implicility. I have tried increasing the connection string timeout and that doesnt help either.
Hmmm, I think the best thing would be to report an issue on the official Issue Tracker:
http://issues.umbraco.org/issues/U4
Out of interest, can you run the statement as a select to see how many rows you get back - something like:
(Not sure of SQL CE syntax so might need to tweak).
So with a lot of blood sweat and tears, doing the incremental upgrade was the only way I could get up to the latest. Took a whole day, a couple of roll backs and starting over but I finally got there.
Excellent! Glad to hear it.
I think your issues must be related to using SQL-CE. I've upgraded sites from 7.2 to 7.7 using SQL Server and they have been OK.
Sometimes it's useful to prune Umbraco - especially the previous versions of pages (as Umbraco stores a version of a page for every publish). This can get huge.
There's a few SQL scripts around to do this - but I'm not sure if they work with SQL-CE, but maybe worth investigating:
https://gist.github.com/Hendy/1686288f7242cf4fdfab
is working on a reply...