Migrate and Upgrade 2.4 to 2.10

[Jonathan Sinclair]

I have an installation of 2.4 on Ubuntu 16.04, which I am trying to migrate to 2.10 on Ubuntu 24.04. Following the install guide, I have a working install of 2.10 on a separate VM , and I copied the digital objects at /usr/share/nginx/atom/uploads/ and /usr/share/nginx/atom/downloads/ to the respective directories on the new server. I have also backed up/restored the MySQL database.

Running "php -d memory_limit=-1 symfony tools:upgrade-sql" gives the error:
SQLSTATE[42S01]: Base table or view already exists: 1050 Table 'clipboard_save' already exists

If I try again, I get "There is no active transaction", however if I run this without importing the previous database, AtoM upgrades successfully. 

[mic...@buchmann.ruhr]

I had a similar case some monthes ago from 2.6 to 2.10.  I also saw "There is no active transaction". The result had mysterious bugs here and there.

Finally I install all intermediate versions and migrated 2.6 -> 2.7 -> 2.8 ...

No problem afterwards