Error when upgrating exhibit builder

I upgrated from omeka 2.5.1 to omeka 2.6. Things went well. ButI find difficulties to upgrate exhibit builder to the version 3.4.1. A error message appear sayinf that "Omeka encounters a problem’. can you help me please?

Have you tried to follow the “Display Error Messages” instructions on the linked manual page?

All the instructions (.htaccess and config.ini) do not work. Still the same error message.

Okay, if that’s not working then try the “Activate Error Logging” instructions below. That should make it log the message to application/logs/errors.log.

2018-05-01T20:15:49+00:00 ERR (3): exception ‘Zend_Db_Statement_Mysqli_Exception’ with message ‘Mysqli statement execute error : Duplicate column name ‘cover_image_file_id’’ in /home/bncici/public_html/omeka/application/libraries/Zend/Db/Statement/Mysqli.php:214
Stack trace:
#0 /home/bncici/public_html/omeka/application/libraries/Zend/Db/Statement.php(303): Zend_Db_Statement_Mysqli->_execute(Array)
#1 /home/bncici/public_html/omeka/application/libraries/Zend/Db/Adapter/Abstract.php(480): Zend_Db_Statement->execute(Array)
#2 [internal function]: Zend_Db_Adapter_Abstract->query(‘ALTER TABLE ak...') #3 /home/bncici/public_html/omeka/application/libraries/Omeka/Db.php(79): call_user_func_array(Array, Array) #4 /home/bncici/public_html/omeka/plugins/ExhibitBuilder/functions.php(296): Omeka_Db->__call('query', Array) #5 /home/bncici/public_html/omeka/plugins/ExhibitBuilder/functions.php(296): Omeka_Db->query('ALTER TABLEak…’)
#6 [internal function]: exhibit_builder_upgrade(Array)
#7 /home/bncici/public_html/omeka/application/libraries/Omeka/Plugin/Broker.php(142): call_user_func(‘exhibit_builder…’, Array)
#8 /home/bncici/public_html/omeka/application/libraries/Omeka/Plugin/Installer.php(96): Omeka_Plugin_Broker->callHook(‘upgrade’, Array, Object(Plugin))
#9 /home/bncici/public_html/omeka/application/controllers/PluginsController.php(231): Omeka_Plugin_Installer->upgrade(Object(Plugin))
#10 /home/bncici/public_html/omeka/application/libraries/Zend/Controller/Action.php(516): PluginsController->upgradeAction()
#11 /home/bncici/public_html/omeka/application/libraries/Zend/Controller/Dispatcher/Standard.php(308): Zend_Controller_Action->dispatch(‘upgradeAction’)
#12 /home/bncici/public_html/omeka/application/libraries/Zend/Controller/Front.php(954): Zend_Controller_Dispatcher_Standard->dispatch(Object(Zend_Controller_Request_Http), Object(Zend_Controller_Response_Http))
#13 /home/bncici/public_html/omeka/application/libraries/Zend/Application/Bootstrap/Bootstrap.php(105): Zend_Controller_Front->dispatch()
#14 /home/bncici/public_html/omeka/application/libraries/Zend/Application.php(384): Zend_Application_Bootstrap_Bootstrap->run()
#15 /home/bncici/public_html/omeka/application/libraries/Omeka/Application.php(73): Zend_Application->run()
#16 /home/bncici/public_html/omeka/admin/index.php(28): Omeka_Application->run()
#17 {main}
2018-05-01T20:16:26+00:00 ERR (3): exception ‘Zend_Db_Statement_Mysqli_Exception’ with message ‘Mysqli statement execute error : Duplicate column name ‘cover_image_file_id’’ in /home/bncici/public_html/omeka/application/libraries/Zend/Db/Statement/Mysqli.php:214
Stack trace:
#0 /home/bncici/public_html/omeka/application/libraries/Zend/Db/Statement.php(303): Zend_Db_Statement_Mysqli->_execute(Array)
#1 /home/bncici/public_html/omeka/application/libraries/Zend/Db/Adapter/Abstract.php(480): Zend_Db_Statement->execute(Array)
#2 [internal function]: Zend_Db_Adapter_Abstract->query(‘ALTER TABLE ak...') #3 /home/bncici/public_html/omeka/application/libraries/Omeka/Db.php(79): call_user_func_array(Array, Array) #4 /home/bncici/public_html/omeka/plugins/ExhibitBuilder/functions.php(296): Omeka_Db->__call('query', Array) #5 /home/bncici/public_html/omeka/plugins/ExhibitBuilder/functions.php(296): Omeka_Db->query('ALTER TABLEak…’)
#6 [internal function]: exhibit_builder_upgrade(Array)
#7 /home/bncici/public_html/omeka/application/libraries/Omeka/Plugin/Broker.php(142): call_user_func(‘exhibit_builder…’, Array)
#8 /home/bncici/public_html/omeka/application/libraries/Omeka/Plugin/Installer.php(96): Omeka_Plugin_Broker->callHook(‘upgrade’, Array, Object(Plugin))
#9 /home/bncici/public_html/omeka/application/controllers/PluginsController.php(231): Omeka_Plugin_Installer->upgrade(Object(Plugin))
#10 /home/bncici/public_html/omeka/application/libraries/Zend/Controller/Action.php(516): PluginsController->upgradeAction()
#11 /home/bncici/public_html/omeka/application/libraries/Zend/Controller/Dispatcher/Standard.php(308): Zend_Controller_Action->dispatch(‘upgradeAction’)
#12 /home/bncici/public_html/omeka/application/libraries/Zend/Controller/Front.php(954): Zend_Controller_Dispatcher_Standard->dispatch(Object(Zend_Controller_Request_Http), Object(Zend_Controller_Response_Http))
#13 /home/bncici/public_html/omeka/application/libraries/Zend/Application/Bootstrap/Bootstrap.php(105): Zend_Controller_Front->dispatch()
#14 /home/bncici/public_html/omeka/application/libraries/Zend/Application.php(384): Zend_Application_Bootstrap_Bootstrap->run()
#15 /home/bncici/public_html/omeka/application/libraries/Omeka/Application.php(73): Zend_Application->run()
#16 /home/bncici/public_html/omeka/admin/index.php(28): Omeka_Application->run()
#17 {main}

You’re probably hitting a problem here that you’ve run the upgrade several times now, so you’re seeing kind of an “in between” state: the error now is saying there’s a “cover_image_file_id” column we’re trying to create, but it already exists. This probably happened because the first time you tried to upgrade Exhibit Builder, we got past this part of the upgrade process, so the column is already there.

Do you know what version of Exhibit Builder you were using before? We have a couple options for moving forward, which could include restoring to a pre-upgrade backup to start fresh, or altering the version for Exhibit Builder that’s stored in the plugins table.

The version I was using is Exhibit-Builder-3.1.2.

Okay, I think you’ve got 2 good options pretty much:

  1. Restore from your database backup and do the upgrade again, since you now have error logging turned on you’ll be sure of logging the “real” error. You could either restore everything (thereby needing to do the core upgrade again as well), or just the Exhibit Builder tables exhibits, exhibit_pages, exhibit_page_blocks, and exhibit_block_attachments.
  2. Set the version for ExhibitBuilder in your database’s plugins table to 3.3 , which will let Omeka know that the exhibit tables have already been upgraded that far (which we know because you already have the cover_image_file_id column it’s complaining about.

This topic was automatically closed after 250 days. New replies are no longer allowed.