Recovering Plugins

A few months ago our server became egregiously infested with malware. We had to create a whole new site for our organization, and I salvaged our Omeka database and put it into a new install. It has worked fairly smoothly and most things work fine, but some of my plugins have never really recovered.

I have been unable to reinstall and delete unwanted plugins that currently say "not a valid plugin." But worse is my inability to upgrade 2.0 compatible plugins that I'd really like to keep and use including: Item Order, My Omeka, and Terms of Service.

Here is the error I got after attempting to install and upgrade My Omeka...

Notice: Use of undefined constant HELPER_DIR - assumed 'HELPER_DIR' in /home3/wdchuman/public_html/dcdm/plugins/MyOmeka/plugin.php on line 22

Warning: require_once(HELPER_DIR/all.php): failed to open stream: No such file or directory in /home3/wdchuman/public_html/dcdm/plugins/MyOmeka/plugin.php on line 22

Fatal error: require_once(): Failed opening required 'HELPER_DIR/all.php' (include_path='/home3/wdchuman/public_html/dcdm/application/libraries:/home3/wdchuman/public_html/dcdm/application/models:.:/usr/php/54/usr/lib64:/usr/php/54/usr/share/pear:/home3/wdchuman/public_html/dcdm/plugins/Geolocation/models:/home3/wdchuman/public_html/dcdm/plugins/CsvImport/models:/home3/wdchuman/public_html/dcdm/plugins/ExhibitBuilder/models:/home3/wdchuman/public_html/dcdm/plugins/SimplePages/models:/home3/wdchuman/public_html/dcdm/plugins/Commenting/models:/home3/wdchuman/public_html/dcdm/plugins/LcSuggest/models:/home3/wdchuman/public_html/dcdm/plugins/LcSuggest/libraries:/home3/wdchuman/public_html/dcdm/plugins/MyOmeka/models') in /home3/wdchuman/public_html/dcdm/plugins/MyOmeka/plugin.php on line 22

Any assistance would be greatly appreciated.

MyOmeka and Terms of Service are not compatible with Omeka 2.0, which is probably the source of the problem

Could have sworn I saw the Omeka 2.0 compatible tag on them. Must have just been wishful thinking.

Here is the message returned after upgrading Item Order...


Mysqli statement execute error : Table 'wdchuman_omeka.omeka_item_orders' doesn't exist
#0 /home3/wdchuman/public_html/dcdm/application/libraries/Zend/Db/Statement.php(303): Zend_Db_Statement_Mysqli->_execute(Array)
#1 /home3/wdchuman/public_html/dcdm/application/libraries/Zend/Db/Adapter/Abstract.php(480): Zend_Db_Statement->execute(Array)
#2 [internal function]: Zend_Db_Adapter_Abstract->query('ALTER TABLE `om...')
#3 /home3/wdchuman/public_html/dcdm/application/libraries/Omeka/Db.php(79): call_user_func_array(Array, Array)
#4 /home3/wdchuman/public_html/dcdm/plugins/ItemOrder/ItemOrderPlugin.php(80): Omeka_Db->__call('query', Array)
#5 /home3/wdchuman/public_html/dcdm/plugins/ItemOrder/ItemOrderPlugin.php(80): Omeka_Db->query('ALTER TABLE `om...')
#6 [internal function]: ItemOrderPlugin->hookUpgrade(Array)
#7 /home3/wdchuman/public_html/dcdm/application/libraries/Omeka/Plugin/Broker.php(145): call_user_func(Array, Array)
#8 /home3/wdchuman/public_html/dcdm/application/libraries/Omeka/Plugin/Installer.php(99): Omeka_Plugin_Broker->callHook('upgrade', Array, Object(Plugin))
#9 /home3/wdchuman/public_html/dcdm/application/controllers/PluginsController.php(185): Omeka_Plugin_Installer->upgrade(Object(Plugin))
#10 /home3/wdchuman/public_html/dcdm/application/libraries/Zend/Controller/Action.php(516): PluginsController->upgradeAction()
#11 /home3/wdchuman/public_html/dcdm/application/libraries/Zend/Controller/Dispatcher/Standard.php(308): Zend_Controller_Action->dispatch('upgradeAction')
#12 /home3/wdchuman/public_html/dcdm/application/libraries/Zend/Controller/Front.php(954): Zend_Controller_Dispatcher_Standard->dispatch(Object(Zend_Controller_Request_Http), Object(Zend_Controller_Response_Http))
#13 /home3/wdchuman/public_html/dcdm/application/libraries/Zend/Application/Bootstrap/Bootstrap.php(97): Zend_Controller_Front->dispatch()
#14 /home3/wdchuman/public_html/dcdm/application/libraries/Zend/Application.php(366): Zend_Application_Bootstrap_Bootstrap->run()
#15 /home3/wdchuman/public_html/dcdm/application/libraries/Omeka/Application.php(79): Zend_Application->run()
#16 /home3/wdchuman/public_html/dcdm/admin/index.php(28): Omeka_Application->run()
#17 {main}

Any thoughts on that one?



The first line says that the table item_orders doesn't exist. So the plugin item order is not upgraded or not enabled.


Daniel Berthereau
Infodoc & Knowledge management

Hi Daniel,

I am running Omeka 2.1.3 on a shared server (Bluehost). I had installed the Item Order plugin on my previous iteration of Omeka, but when I installed the new version and connected my old database, Item Order was among the plugins that stopped working. This was not a surprise, as I did not immediately reinstall Item Order, but it still showed up in my plugins list despite not actually being there.

Yesterday, I started trying to recover the plugins I want and get rid of those I do not. Patrick pointed out that several of the ones I'd hoped to save have not been made compatible with 2.x, but Item Order should be. I downloaded it, unzipped it, and uploaded it to the plugins directory. It then, as expected, Omeka gave me the option to upgrade it. When I clicked upgrade, it returned the above message indicating that the item order table does not exist in the database.

I'm guessing that the table it is looking for would be created by the plugin install, but because it thinks it only needs to upgrade, it is looking for something that is not there. I obviously don't know much of anything about making manual changes to these things, but is there some way I can create the table it's looking for or set the plugin to do a full install rather than an upgrade?

I would definitely appreciate any help. It would be great to be able to use some of these plugins again!



Uninstall the old plugin, and reinstall new one, so there will not be problem to recreate the table.


Daniel Berthereau
Infodoc & Knowledge management