Error to Run the upgrade task from Atom 2.5 to 2.6.4

[marcelo....@gmail.com]

Hello community,

I am upgrading from version 2.5 to 2.6.4, when I run the command "php -d memory_limit = -1 symfony tools: upgrade-sql" it gives me the error in the image.

Should I run this command? This since I installed the application with the new version and created the database "" CREATE DATABASE atom CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci; "then load the atom database from the previous version and run the update command.

Any help would be appreciated.

" SQLSTATE[42S01]: Base table or view already exists: 1050 Table 'function_object' already exists".

Any help would be appreciated

Best regard

Marcelo

[Dan Gillean]

Hi Marcelo, 

These types of errors typically happen either when a step of the upgrade process has been missed, or occasionally just because one of the steps did not complete properly. 

I would recommend that you try dropping and recreating the database, before loading your sqldump and and trying again. Here's a sample command that assumes your database is named atom - obviously you will need to swap in your MySQL username as well! 

• mysql -u username -p -e "DROP DATABASE IF EXISTS atom;"
• mysql -u username -p -e "CREATE DATABASE atom CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci;"
  

Let us know if that helps.

Cheers, 

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/0e25ba2c-a64f-4f68-99ec-dbcb6772d4bfn%40googlegroups.com.