Database "propel" does not exist.

[steve.walk...@gmail.com]

Hi -

I am upgrading our Atom installation from 2.5 to 2.6.2.  I created a new file location on my server and downloaded the tarball.  I then followed the upgrade steps and upgraded MySQL to version 8.  I ran the scripts in the upgrade document to create a new database and then uploaded my 2.5 database into the new database.

I then changed directories to /usr/share/nginx/atom$  and ran sudo php -d memory_limit=-1 symfony tools:upgrade-sql.  It responds Database "propel" does not exist.

Any suggestions on how to resolve this?

Thanks -

Steve Walker

Colorado Alliance of Research Libraries

[Dan Gillean]

Hi Steve, 

I've found at least 2 other threads in our forum that include a similar error message. In both cases, the advice from our developers was to check the config/config.php file for typos or other errors, or otherwise delete it, run the web installer again. See for example: 

• https://groups.google.com/g/ica-atom-users/c/i0j2OxUSK4E/m/ngQo-wdgAgAJ
  
• https://groups.google.com/g/ica-atom-users/c/Cii7aUUSs-g/m/kCPzYVyGeqgJ
  

 Some other notes and suggestions: 

First, make sure the filesystem permissions are properly set. AtoM expects the www-data user to be the owner of all files in the root AtoM directory. You can make sure they are properly applied by running the following: 

• sudo chown -R www-data:www-data /usr/share/nginx/atom

Was the new installation working before you tried loading your data? Our upgrade process recommends basically performing a new installation alongside the old one, and then migrating the database. That means you should have been able to get through the final installation steps, including running the web installer. The second thread linked above will be more helpful if you haven't successfully installed the second AtoM site, to the point you can access it successfully in a web browser (even if it has no content loaded yet). 

One thing that occurred to me was that if you're installing a new instance of AtoM on the same server, then you may need to give the second site a different database and search index name - possibly also a different Nginx configuration block name as well - to avoid conflicts with the previous installation. Something to try out!

Finally, you can always try repeating the steps - sometimes something doesn't quite take, or a small step is missed along the way. If something's gone wrong after you've tried loading your data, then using AtoM's tools:purge command can also help flush out any data remnants. I've previously given instructions on this in the following thread: 

• https://groups.google.com/g/ica-atom-users/c/U5bqJGlQ4X4/m/Ki17ZhLPAAAJ
  

Let us know if these suggestions help!

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/f008cd9c-88ab-476b-a017-d831c5e7472bn%40googlegroups.com.

[Steve Walker]

Thanks for the info, Dan.  I'll review it and be in touch.

Steve

To view this discussion on the web visit https://groups.google.com/d/msgid/ica-atom-users/CAC1FhZLF%3DBbj1Efo_UJRTB4pX6tBcTh%3DjCknPFmJ%3DDMyrdrwZg%40mail.gmail.com.

--

-----

Steve Walker

 "Work Hard, Rock Hard, Eat Hard, Sleep Hard,
Grow Big, Wear Glasses If You Need 'Em" - Webb Wilder

[Steve Walker]

Dan - It was a typo.  Site is up and running now. 

Thanks -

Steve

[Dan Gillean]

Glad to hear it, Steve! 

While I'm sure that was a frustrating situation for you, I'm personally always relieved when errors like these have a simple solution! 

Cheers, 

Dan Gillean, MAS, MLIS
AtoM Program Manager
Artefactual Systems, Inc.
604-527-2056

@accesstomemory

he / him

To view this discussion on the web visit https://groups.google.com/d/msgid/ica-atom-users/CADJn6S8-RR2e5g7vta%2Bj3sybqpvpTvL7Hxp5gbQ4eA1hwd6TBg%40mail.gmail.com.