Installing Omeka Classic Issues?

I followed these instructions to run Omeka Classic through Reclaim Cloud. As soon as I fill out the superuser form, the site crashes and defaults to this:

Zend_Db_Statement_Mysqli_Exception

Mysqli prepare error: Table ‘omekatest2.omeka_schema_migrations’ doesn’t exist

Zend_Db_Statement_Mysqli_Exception: Mysqli prepare error: Table 'omekatest2.omeka_schema_migrations' doesn't exist in /var/www/webroot/ROOT/application/libraries/Zend/Db/Statement/Mysqli.php:77 Stack trace: #0 /var/www/webroot/ROOT/application/libraries/Zend/Db/Statement.php(115): Zend_Db_Statement_Mysqli->_prepare('SELECT version ...') #1 /var/www/webroot/ROOT/application/libraries/Zend/Db/Adapter/Mysqli.php(388): Zend_Db_Statement->__construct(Object(Zend_Db_Adapter_Mysqli), 'SELECT version ...') #2 /var/www/webroot/ROOT/application/libraries/Zend/Db/Adapter/Abstract.php(479): Zend_Db_Adapter_Mysqli->prepare('SELECT version ...') #3 /var/www/webroot/ROOT/application/libraries/Zend/Db/Adapter/Abstract.php(794): Zend_Db_Adapter_Abstract->query('SELECT version ...', Array) #4 /var/www/webroot/ROOT/application/libraries/Omeka/Db.php(80): Zend_Db_Adapter_Abstract->fetchCol('SELECT version ...') #5 /var/www/webroot/ROOT/application/libraries/Omeka/Db/Migration/Manager.php(178): Omeka_Db->__call('fetchCol', Array) #6 /var/www/webroot/ROOT/application/libraries/Omeka/Db/Migration/Manager.php(268): Omeka_Db_Migration_Manager->_getAllMigratedVersions() #7 /var/www/webroot/ROOT/application/libraries/Omeka/Db/Migration/Manager.php(120): Omeka_Db_Migration_Manager->_getPendingMigrations(Object(DateTime)) #8 /var/www/webroot/ROOT/application/libraries/Omeka/Db/Migration/Manager.php(134): Omeka_Db_Migration_Manager->canUpgrade() #9 /var/www/webroot/ROOT/application/libraries/Omeka/Controller/Plugin/Upgrade.php(55): Omeka_Db_Migration_Manager->dbNeedsUpgrade() #10 /var/www/webroot/ROOT/application/libraries/Omeka/Controller/Plugin/Upgrade.php(39): Omeka_Controller_Plugin_Upgrade->_dbNeedsUpgrade() #11 /var/www/webroot/ROOT/application/libraries/Zend/Controller/Plugin/Broker.php(287): Omeka_Controller_Plugin_Upgrade->dispatchLoopStartup(Object(Zend_Controller_Request_Http)) #12 /var/www/webroot/ROOT/application/libraries/Zend/Controller/Front.php(928): Zend_Controller_Plugin_Broker->dispatchLoopStartup(Object(Zend_Controller_Request_Http)) #13 /var/www/webroot/ROOT/application/libraries/Zend/Application/Bootstrap/Bootstrap.php(105): Zend_Controller_Front->dispatch() #14 /var/www/webroot/ROOT/application/libraries/Zend/Application.php(384): Zend_Application_Bootstrap_Bootstrap->run() #15 /var/www/webroot/ROOT/application/libraries/Omeka/Application.php(73): Zend_Application->run() #16 /var/www/webroot/ROOT/index.php(23): Omeka_Application->run() #17 {main}

I’ve tried creating the table manually via PHPMyAdmin, but that creates a different issue. It seems like the issue might be on Omeka’s side, but I want to confirm before asking there.

Hello Judaica_DH,

Apologies for the trouble you are experiencing. Would it be possible for you to provide me with the name of your environment so I can take a look at this issue.

Thank you.

Gordon Hawley
Customer Support Specialist

Hi Gordon! I’m working on env-8932640.us.reclaim.cloud.

Hello Judaica_DH,

Initially I tried installing a fresh copy of Omeka under my own cloud account however I received a slightly different error than you provided. I noticed looking at your installation that you’ve used a MariaDB instead of MySQL. I wonder if this could be the problem? Under my own installation I also tried changing the PHP version from 8 to 7.4 however then I couldn’t get the application to run no matter what I tried. I destroyed the environment and will give try again later. If you do reach out to Omeka please let me know what they say. Hopefully it will help us track down the source of these errors.

Gordon Hawley
Customer Support Specialist

Hi Gordon,

Thanks. I reached out to the Omeka folks on their forums but didn’t get much more - I couldn’t get it to run under MySQL or PHP version 7.4 either, and had the best success with MariaDB.

edit: Success! With the following configurations:

  • Apache 2.4.46
  • PHP 7.4.13
  • MySQL CE 5.7.32

Hello Judaica_DH,

Thank you for the information. Much appreciated!

Gordon Hawley
Customer Support Specialist