I've just completed an upgrade from 2.3 to 2.3.1, and everything went smoothly...except for a problem which seems to lie with Exhibit Builder. I installed the new version of Omeka and was prompted to upgrade the database; then I updated Exhibit Builder. Since then, when trying to view the public pages of items, I get this error:
exception 'Zend_Db_Statement_Mysqli_Exception' with message 'Mysqli prepare error: Table 'omeka_cppdigitallibrary.omeka_exhibit_page_entries' doesn't exist'
Any suggestions are appreciated! I found this thread (http://omeka.org/forums/topic/exhibit-builder-31-upgrade-issue) and manually updated the version of Exhibit Builder as suggested, but no luck. Thanks.
Can you post more of that error? There should be a traceback showing the line numbers of the code involved.
exhibit_page_entries is a table from a much older version of Exhibit Builder. What version of Exhibit Builder are you using now?
I am using version 3.2.1 - I'm not sure what the previous version installed was. The rest of the error:
exception 'Zend_Db_Statement_Mysqli_Exception' with message 'Mysqli prepare error: Table 'omeka_cppdigitallibrary.omeka_exhibit_page_entries' doesn't exist' in /home/josephdavidanderson/omeka/application/libraries/Zend/Db/Statement/Mysqli.php:77
Stack trace:
#0 /home/josephdavidanderson/omeka/application/libraries/Zend/Db/Statement.php(115): Zend_Db_Statement_Mysqli->_prepare('? SELECT e.*...')
#1 /home/josephdavidanderson/omeka/application/libraries/Zend/Db/Adapter/Mysqli.php(388): Zend_Db_Statement->__construct(Object(Zend_Db_Adapter_Mysqli), '? SELECT e.*...')
#2 /home/josephdavidanderson/omeka/application/libraries/Zend/Db/Adapter/Abstract.php(479): Zend_Db_Adapter_Mysqli->prepare('? SELECT e.*...')
#3 [internal function]: Zend_Db_Adapter_Abstract->query('? SELECT e.*...', Array)
#4 /home/josephdavidanderson/omeka/application/libraries/Omeka/Db.php(79): call_user_func_array(Array, Array)
#5 /home/josephdavidanderson/omeka/application/libraries/Omeka/Db/Table.php(648): Omeka_Db->__call('query', Array)
#6 /home/josephdavidanderson/omeka/application/libraries/Omeka/Db/Table.php(648): Omeka_Db->query('? SELECT e.*...', Array)
#7 /home/josephdavidanderson/omeka/themes/mutter/custom.php(341): Omeka_Db_Table->fetchObjects('? SELECT e.*...', Array)
#8 /home/josephdavidanderson/omeka/themes/mutter/items/show.php(32): link_to_related_exhibits(Object(Item))
#9 /home/josephdavidanderson/omeka/application/libraries/Omeka/View.php(117): include('/home/josephdav...')
#10 /home/josephdavidanderson/omeka/application/libraries/Zend/View/Abstract.php(888): Omeka_View->_run('/home/josephdav...')
#11 /home/josephdavidanderson/omeka/application/libraries/Zend/Controller/Action/Helper/ViewRenderer.php(905): Zend_View_Abstract->render('items/show.php')
#12 /home/josephdavidanderson/omeka/application/libraries/Zend/Controller/Action/Helper/ViewRenderer.php(926): Zend_Controller_Action_Helper_ViewRenderer->renderScript('items/show.php', NULL)
#13 /home/josephdavidanderson/omeka/application/libraries/Zend/Controller/Action/Helper/ViewRenderer.php(965): Zend_Controller_Action_Helper_ViewRenderer->render()
#14 /home/josephdavidanderson/omeka/application/libraries/Zend/Controller/Action/HelperBroker.php(277): Zend_Controller_Action_Helper_ViewRenderer->postDispatch()
#15 /home/josephdavidanderson/omeka/application/libraries/Zend/Controller/Action.php(527): Zend_Controller_Action_HelperBroker->notifyPostDispatch()
#16 /home/josephdavidanderson/omeka/application/libraries/Zend/Controller/Dispatcher/Standard.php(308): Zend_Controller_Action->dispatch('showAction')
#17 /home/josephdavidanderson/omeka/application/libraries/Zend/Controller/Front.php(954): Zend_Controller_Dispatcher_Standard->dispatch(Object(Zend_Controller_Request_Http), Object(Zend_Controller_Response_Http))
#18 /home/josephdavidanderson/omeka/application/libraries/Zend/Application/Bootstrap/Bootstrap.php(105): Zend_Controller_Front->dispatch()
#19 /home/josephdavidanderson/omeka/application/libraries/Zend/Application.php(382): Zend_Application_Bootstrap_Bootstrap->run()
#20 /home/josephdavidanderson/omeka/application/libraries/Omeka/Application.php(79): Zend_Application->run()
#21 /home/josephdavidanderson/omeka/index.php(23): Omeka_Application->run()
#22 {main}
The trace you posted indicates the problem is in the custom function link_to_related_exhibits in the custom.php from your theme named "mutter."
I mentioned that "exhibit_page_entries" is an old table from an older Exhibit Builder, and that function in the theme is written to work with the old version only.
You can resolve the error by either updating that function (and another member of the forums has posted an updated version you could use), or removing it and the call to it in items/show.php.
Thank you so much! Our digital projects librarian left before I started and didn't leave much in the way of documentation. I myself know very little about programming. I really appreciate your help! Everything is now up and running.