I’ve been doing some other things so haven’t been on the forums much I a while. I want to upgrade my install which has been running quit happily on v12 for a loooong time. I have trolled for posts on how to do this but there’s a disturbing lack thereof.
The most common opinion seems to be “install v14 fresh and the migrate” - so I tried … install v14 (all fine - even used ubuntu 22 to match with the majority of the posts), and then data import of the v12 DB into v14 (also appears to go fine), but…
when I try bench update -- patch
Right after the Building search index for site1.local
I get errors like this…
pymysql.err.OperationalError: (1054, "Unknown column 'is_virtual' in 'field list'")
pymysql.err.OperationalError: (1054, "Unknown column 'website_search_field' in 'field list'")
I thought that the primary purpose of migrate/patch was to correct DB schema mismatches?
Admittedly I have been out of the loop a while but has anyone actually succeeded in a v12->v14?
Am I better off doing a v12 → v13 upgrade…and then a v13 → v14 upgrade?