I installed Omeka 2.3 on my Mac OS X 10.10 Yosemite. I would like to add a plugin directly from the admin dashboard site that comes up when you access Omeka from the localhost. I clicked on the plugin for "Exhibit Builder" and received the following error message:

Mysqli prepare error: CREATE command denied to user 'omeka'@'localhost' for table 'omeka_exhibits'

Omeka also gave me the following code (I assume this is where I have to look for something?):

exception 'Zend_Db_Statement_Mysqli_Exception' with message 'Mysqli prepare error: CREATE command denied to user 'omeka'@'localhost' for table 'omeka_exhibits'' in /Library/WebServer/Documents/omeka/application/libraries/Zend/Db/Statement/Mysqli.php:77
Stack trace:
#0 /Library/WebServer/Documents/omeka/application/libraries/Zend/Db/Statement.php(115): Zend_Db_Statement_Mysqli->_prepare('CREATE TABLE IF...')
#1 /Library/WebServer/Documents/omeka/application/libraries/Zend/Db/Adapter/Mysqli.php(388): Zend_Db_Statement->__construct(Object(Zend_Db_Adapter_Mysqli), 'CREATE TABLE IF...')
#2 /Library/WebServer/Documents/omeka/application/libraries/Zend/Db/Adapter/Abstract.php(479): Zend_Db_Adapter_Mysqli->prepare('CREATE TABLE IF...')
#3 [internal function]: Zend_Db_Adapter_Abstract->query('CREATE TABLE IF...')
#4 /Library/WebServer/Documents/omeka/application/libraries/Omeka/Db.php(79): call_user_func_array(Array, Array)
#5 /Library/WebServer/Documents/omeka/plugins/ExhibitBuilder/functions.php(45): Omeka_Db->__call('query', Array)
#6 /Library/WebServer/Documents/omeka/plugins/ExhibitBuilder/functions.php(45): Omeka_Db->query('CREATE TABLE IF...')
#7 [internal function]: exhibit_builder_install(Array)
#8 /Library/WebServer/Documents/omeka/application/libraries/Omeka/Plugin/Broker.php(145): call_user_func('exhibit_builder...', Array)
#9 /Library/WebServer/Documents/omeka/application/libraries/Omeka/Plugin/Installer.php(130): Omeka_Plugin_Broker->callHook('install', Array, Object(Plugin))
#10 /Library/WebServer/Documents/omeka/application/controllers/PluginsController.php(97): Omeka_Plugin_Installer->install(Object(Plugin))
#11 /Library/WebServer/Documents/omeka/application/libraries/Zend/Controller/Action.php(516): PluginsController->installAction()
#12 /Library/WebServer/Documents/omeka/application/libraries/Zend/Controller/Dispatcher/Standard.php(308): Zend_Controller_Action->dispatch('installAction')
#13 /Library/WebServer/Documents/omeka/application/libraries/Zend/Controller/Front.php(954): Zend_Controller_Dispatcher_Standard->dispatch(Object(Zend_Controller_Request_Http), Object(Zend_Controller_Response_Http))
#14 /Library/WebServer/Documents/omeka/application/libraries/Zend/Application/Bootstrap/Bootstrap.php(105): Zend_Controller_Front->dispatch()
#15 /Library/WebServer/Documents/omeka/application/libraries/Zend/Application.php(382): Zend_Application_Bootstrap_Bootstrap->run()
#16 /Library/WebServer/Documents/omeka/application/libraries/Omeka/Application.php(79): Zend_Application->run()
#17 /Library/WebServer/Documents/omeka/admin/index.php(28): Omeka_Application->run()
#18 {main}

I am using MySQL Workbench and checked my permissions--I should have permissions to create databases and tables in Omeka, but apparently not.

So my questions are:
1. How do I fix this error message?
1. Will one fix apply to all of the rest of the plugins that I want to add?

Thank you!


That is a bit perplexing. If the MySQL user didn't have permissions to create tables, I would have expected that the installation would have failed, because it couldn't create the core Omeka tables.

Thus, I'm not sure if one fix would apply to the rest of the plugins. But, it might be a helpful experiment to see if you can install the Simple Pages plugin, which is also part of the packaged distribution. That might help us see if there's something oddly specific to Exhibit Builder, or if it is something deeper in some MySQL setting.

Thank you patrickmj. Here was another wrinkle--when I started the installation process for Omeka I used Safari as my browser. For some reason Safari encountered a glitch and would not run any websites even though I had wireless connectivity, so I changed to Google Chrome and did not have a problem with the rest of the Omeka installation. At the same time Google Chrome would not allow me to add Simple Pages OR Exhibit Builder to Omeka. I went off the Mac for a while and switched to my PC laptop where I read your response to my question, then went back to my Mac so I could continue to work on it. When I restarted my computer the Safari icon was bouncing up and down, and I clicked on it, refreshed my Omeka page, and it said that it successfully installed the Exhibit Builder plugin, so I clicked on "Install" for Simple Pages and that also worked without hassle.

Now I am going to try and install the plugins that I added from the list of plugins that Omeka provides from its website. Wish me luck--I will be back here with any further questions!


I think i have a similar problem... was this ever resolved?