Geolocation 2.0 DB Issue

I recently installed the Geolocation 2.0 to my Omeka 2.0 installation. Items showed up in my list of items but clicking on the link to the item came back with an error that the *_locations table in the DB could not be found. I don't see that anyone else is having the issue but I uninstalled the plugin and I'm no longer getting the error. I really need that plugin - any suggestions?

Fingers crossed, but it might be that the table didn't get properly created when you installed the plugin. First guess is probably to try installing the plugin again.

Thanks fro the reply. I just reactivated and when I click on an item link I get:

#0 /var/www/html/studentOmeka/application/libraries/Zend/Db/Statement.php(115): Zend_Db_Statement_Mysqli->_prepare('SELECT `locatio...')
#1 /var/www/html/studentOmeka/application/libraries/Zend/Db/Adapter/Mysqli.php(381): Zend_Db_Statement->__construct(Object(Zend_Db_Adapter_Mysqli), 'SELECT `locatio...')
#2 /var/www/html/studentOmeka/application/libraries/Zend/Db/Adapter/Abstract.php(478): Zend_Db_Adapter_Mysqli->prepare('SELECT `locatio...')
#3 [internal function]: Zend_Db_Adapter_Abstract->query(Object(Zend_Db_Select), Array)
#4 /var/www/html/studentOmeka/application/libraries/Omeka/Db.php(79): call_user_func_array(Array, Array)
#5 /var/www/html/studentOmeka/application/libraries/Omeka/Db/Table.php(484): Omeka_Db->__call('query', Array)
#6 /var/www/html/studentOmeka/application/libraries/Omeka/Db/Table.php(484): Omeka_Db->query(Object(Zend_Db_Select), Array)
#7 /var/www/html/studentOmeka/plugins/Geolocation/models/Table/Location.php(36): Omeka_Db_Table->fetchObjects(Object(Zend_Db_Select))
#8 /var/www/html/studentOmeka/plugins/Geolocation/GeolocationPlugin.php(205): Table_Location->findLocationByItem(Object(Item), true)
#9 [internal function]: GeolocationPlugin->hookAdminItemsShowSidebar(Array)
#10 /var/www/html/studentOmeka/application/libraries/Omeka/Plugin/Broker.php(157): call_user_func(Array, Array)
#11 /var/www/html/studentOmeka/application/libraries/globals.php(188): Omeka_Plugin_Broker->callHook('admin_items_sho...', Array)
#12 /var/www/html/studentOmeka/admin/themes/default/items/show.php(97): fire_plugin_hook('admin_items_sho...', Array)
#13 /var/www/html/studentOmeka/application/libraries/Omeka/View.php(117): include('/var/www/html/s...')
#14 /var/www/html/studentOmeka/application/libraries/Zend/View/Abstract.php(888): Omeka_View->_run('/var/www/html/s...')
#15 /var/www/html/studentOmeka/application/libraries/Zend/Controller/Action/Helper/ViewRenderer.php(900): Zend_View_Abstract->render('items/show.php')
#16 /var/www/html/studentOmeka/application/libraries/Zend/Controller/Action/Helper/ViewRenderer.php(921): Zend_Controller_Action_Helper_ViewRenderer->renderScript('items/show.php', NULL)
#17 /var/www/html/studentOmeka/application/libraries/Zend/Controller/Action/Helper/ViewRenderer.php(960): Zend_Controller_Action_Helper_ViewRenderer->render()
#18 /var/www/html/studentOmeka/application/libraries/Zend/Controller/Action/HelperBroker.php(277): Zend_Controller_Action_Helper_ViewRenderer->postDispatch()
#19 /var/www/html/studentOmeka/application/libraries/Zend/Controller/Action.php(527): Zend_Controller_Action_HelperBroker->notifyPostDispatch()
#20 /var/www/html/studentOmeka/application/libraries/Zend/Controller/Dispatcher/Standard.php(308): Zend_Controller_Action->dispatch('showAction')
#21 /var/www/html/studentOmeka/application/libraries/Zend/Controller/Front.php(954): Zend_Controller_Dispatcher_Standard->dispatch(Object(Zend_Controller_Request_Http), Object(Zend_Controller_Response_Http))
#22 /var/www/html/studentOmeka/application/libraries/Zend/Application/Bootstrap/Bootstrap.php(97): Zend_Controller_Front->dispatch()
#23 /var/www/html/studentOmeka/application/libraries/Zend/Application.php(366): Zend_Application_Bootstrap_Bootstrap->run()
#24 /var/www/html/studentOmeka/application/libraries/Omeka/Application.php(79): Zend_Application->run()
#25 /var/www/html/studentOmeka/admin/index.php(28): Omeka_Application->run()
#26 {main}

Just to double-check -- did you uninstall and reinstall the plugin, or just deactivate and reactivate it? You'll want to do the uninstall and reinstall.

I deactivated, uninstalled, then reinstalled and activated

I guess the question here is what's meant by "uninstalled." Are you clicking "Uninstall" in the Omeka interface, or deleting the plugin's files?

A plugin is automatically activated when it's installed, so "reinstalled and activated" sounds confusing.

I'm clicking deactivate and then uninstall.

I guess I should uninstall and remove geolocation from my plugin dir?

I did this and reinstalled. All appears to be working now.