8 to 10 Database upgrade error
# help-with-umbraco
s
I am trying to connect to a version 8 database in a clean v10 Umbraco, to allow the wizard to do the upgrade for me, but I run into this error

https://i.imgur.com/eYlJWkD.png

Setting the connectionstring to attach to a working v10 Database works fine, but on the v8 it gives the above error - Isn't there supposed to be a wizard?
Upon swapping to the 10 that works, and back to the 8 that I want to have upgraded, it won't even let me run the site anymore; https://cdn.discordapp.com/attachments/1261260850446995537/1261261973174358136/image.png?ex=6692513f&is=6690ffbf&hm=5e8817db6b5e0f2b2ba650ca091d01444b231c95b8b73a264c0a2f05202d937d&
The v8 database is a copy of an in-production database
k
Don't hotswap databases, it will confuse Umbraco and its indices and caches I think.
Did you upgrade to 8.latest first? I think that's a must.
Did you follow the 8-to-latest-guide @User mentioned the other day?
When you say "clean Umbraco v10", did you run the clean v10 first on a 10 database to make sure it works? If not, do that. But remove all indices and temp/cache files before attaching the 8abase.
Did you enable unattended upgrades? If so, disable it.
Yes, there is supposed to be a wizard. 🧙‍♂️
s
I used a clean installation that was already set up with a clean new database --- How do I remove those?
Where do I do this? - I don't recall going out of my way to make it enabled
I was assured that the Umbraco setup that the database was pulled from, was 8.latest
k
It's an appSetting. Default is disabled
Stop the iisexpress/kestrel, delete the index folder on disk, delete the temp folder on disk
s
Are both of those in the Data TEMP folder?
k
I think so. Delete the whole
umbraco\Data\TEMP
s
Right, done - Then what?
k
Make sure all kestrels and iisexpresses are shutdown, connectionstring the 8abase, F5
If you get an error again, read the whole error message and check all Umbraco logs
s

https://i.imgur.com/IK0qycT.png

k
Inspect the entire callstack, and all Umbraco logs
s
I think this goes beyond my competence, as far as I am aware there's only a callstack that refers to a lot of "external code" but it starts and ends in the main function - And there are no errors in the logs from Umbraco
s
Maybe I am misreading this but, I believe the thing we recommend in the docs is: - do a clean v10 install - stop the v10 site - change the now existing connection string (in appsettings.Development.json) on the v10 site to the v8 database - start the v10 site again - you should now see the upgrade wizard - provided that unattended upgrades are not configured in the v10 appsettings It might actually be beneficial to set unattended upgrades to true, I've seen one problem being avoided by that recently (can't remember exactly what). Note: make sure that the v8 database is on the very latest: 8.18.14
s
I created a new project based on the 10.latest template, and created a database for it to go through the installation process with, I then closed the project to a production-based database from a v8 project that is currently live (So that database works), and when I start the project with the V10, connected to the V8 database, I run into the above error
s
Another option is to use uSync - Install uSync on v8 site, export everything. Then create a brand new v10 site with db, install uSync and import the previous v8 export. Maybe less paid unless you need all the v8 history
s
Yeah I can't quite tell from the error what might be the problem. Indeed, as Simon says, my next option would be to use uSync to export from 8 and import to 10! 👍 It's a very excellent tool.
s
Does the database have a string for version?
s
Kinda. It's a string for which migration has been performed last, in the UmbracoKeyValue table. It's a migration GUID though, you'd need to look at the Umbraco source code to figure out which GUID corresponds to which version.
Try uSync 😉
4 Views