Run the upgrade task

[Sir Luigi]

I encountered this error when running the following task:

• php -d memory_limit=-1 symfony tools:upgrade-sql

           SQLSTATE[42S01]: Base table or view already exists: 1050 Table 'clipboard_save' already exists

This is an upgrade to version 2.2.1 on a new server that we have fully installed with all the requirements of version 2.6.4 and then followed up with the upgrade documentation.

Can you help me find the solution to this problem?

Thank you.

[Dan Gillean]

Hello there, 

Usually when we see this error, it's because the database was not dropped and recreated before loading the sqldump and running the upgrade task. Please see step 4 in this section of the upgrade instructions: 

• https://www.accesstomemory.org/docs/2.6/admin-manual/installation/upgrading/#copy-your-old-data
  

If you want to clear any residual data from previous attempts to load your backup, you can also run the tools:purge task. This task deletes ALL DATA from the database, so be sure that you still have your backup before using it! See: 

• https://www.accesstomemory.org/docs/latest/admin-manual/maintenance/cli-tools/#purging-all-data
  

Let us know if that helps! 

Dan Gillean, MAS, MLIS

AtoM Program Manager
Artefactual Systems, Inc.
604-527-2056

@accesstomemory

he / him

--
You received this message because you are subscribed to the Google Groups "AtoM Users" group.
To unsubscribe from this group and stop receiving emails from it, send an email to ica-atom-user...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/ica-atom-users/86ecae7b-ca18-411c-bd88-993880fa4249n%40googlegroups.com.

[Sir Luigi]

Indeed, we had skipped deleting the database because it was a new installation, thinking that the restore would replace everything, but it must be that this is not the case, and that it is therefore necessary to do a deletion.

We have managed to finish the process and with it all the other steps of the upgrade.

Thank you very much for your help.