Sandra Yates
Aug 24, 2020, 1:54:30 PM8/24/20
to AtoM Users
Hi,
I'm trying to run the upgrade task to version 2.6 (from 2.5.3), and I'm getting the error: SQLSTATE[42S01]: Base table or view already exists: 1050 Table 'function_object' already exists.
Seems to be the same issue addressed in Bug# 13365.
Not sure if I can proceed with the upgrade.
Thanks for your help,
Sandra
Dan Gillean
Aug 24, 2020, 3:39:42 PM8/24/20
to ICA-AtoM Users
Hi Sandra,
It appears that the issue ticket in question was fixed before the release, so I'm hoping this won't be a blocker for you. A couple questions to see if we can identify what's going on here:
First, is this a standard installation - i.e. have you followed our recommended 2.6 installation instructions, or have you made changes at any point? Have you installed a new system alongside your old one, or are you trying to upgrade in place? Please note, for example, that we've switched to MySQL 8.0 in the 2.6 release, and this also comes with a change in the default database collation, as well as a changes to our recommended SQL modes.
For the SQL modes, see for example the last part of this section of the installation docs:
You can check, and possibly change, your SQL modes with the following:
Additionally, a key part of the upgrade process is dropping and recreating the database prior to loading your legacy data - this is where we get to define the updated collation format for MySQL 8. See steps 4 and 5 in this section of the upgrade docs:
Once that's done and you load your data, don't forget to go back and still run the upgrade task - this is a critical part of the upgrade process, as the task handles database schema changes between versions. See:
We did have another user recently report the exact same error, and it was resolved by running the upgrade task. See:
Even if you did all this the first time, I'd suggest trying these steps again (starting with making sure your data is backed up, then dropping and recreating the database, loading your data, and running the upgrade task), just to ensure everything is working as expected. I'm really hoping that a drop and create will allow the upgrade task to run successfully.
One thing you could try as well, just to be sure - running the tools:purge task after dropping and re-creating the database:
- php symfony tools:purge
- See: https://www.accesstomemory.org/docs/latest/admin-manual/maintenance/cli-tools/#purging-all-data
It shouldn't be necessary, but in practice I've sometimes found that it helps users when something about the upgrade task isn't working. This task will purge all data in the site, then walk you through the process of giving your site a new title, description, and admin user. Since your data should at this point be backed up outside of AtoM, it won't be affected - and it won't matter what credentials you enter after running the purge task, since everything will be overwritten once we load your backed up data and try the upgrade task again.
If that still doesn't work, please tell us more about your installation, and I'll see what further suggestions I can gather from our team.
Cheers,
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/02d40bc6-1e84-4ed9-b1e0-bb330547a437n%40googlegroups.com.
Sandra Yates
Aug 25, 2020, 10:28:26 AM8/25/20
to AtoM Users
Hi Dan,
I had skipped the Drop and Create the atom database step. Of course that was it! I was able to run the upgrade task after loading into the new database.
Thanks!
Sandra
Dan Gillean
Aug 25, 2020, 1:24:28 PM8/25/20
to ICA-AtoM Users
Great! I'm glad you've managed to solve this issue and upgrade successfully, Sandra. Thank you for posting an update to the thread so we know what the solution was!
Cheers,
he / him
To view this discussion on the web visit https://groups.google.com/d/msgid/ica-atom-users/4253eda1-67df-4660-9935-4870b8e0bc78n%40googlegroups.com.
Reply all
Reply to author
Forward
0 new messages