Zend_Db_Statement_Mysqli_Exception error

Hi all,

We're getting the following error:

Mysqli prepare error: Table 'omeka_db.omeka_simple_pages_pages' doesn't exist

The following is the log:
exception 'Zend_Db_Statement_Mysqli_Exception' with message 'Mysqli prepare error: Table 'omeka_db.omeka_simple_pages_pages' doesn't exist' in /var/www/html/spcol/postcards/application/libraries/Zend/Db/Statement/Mysqli.php:77
Stack trace:
#0 /var/www/html/spcol/postcards/application/libraries/Zend/Db/Statement.php(115): Zend_Db_Statement_Mysqli->_prepare('SELECT s.* FR...')
#1 /var/www/html/spcol/postcards/application/libraries/Zend/Db/Adapter/Mysqli.php(381): Zend_Db_Statement->__construct(Object(Zend_Db_Adapter_Mysqli), 'SELECT s.* FR...')
#2 /var/www/html/spcol/postcards/application/libraries/Zend/Db/Adapter/Abstract.php(478): Zend_Db_Adapter_Mysqli->prepare('SELECT s.* FR...')
#3 [internal function]: Zend_Db_Adapter_Abstract->query(Object(Omeka_Db_Select), Array)
#4 /var/www/html/spcol/postcards/application/libraries/Omeka/Db.php(84): call_user_func_array(Array, Array)
#5 /var/www/html/spcol/postcards/application/libraries/Omeka/Db/Table.php(479): Omeka_Db->__call('query', Array)
#6 /var/www/html/spcol/postcards/application/libraries/Omeka/Db/Table.php(479): Omeka_Db->query(Object(Omeka_Db_Select), Array)
#7 /var/www/html/spcol/postcards/application/libraries/Omeka/Db/Table.php(233): Omeka_Db_Table->fetchObjects(Object(Omeka_Db_Select))
#8 /var/www/html/spcol/postcards/plugins/SimplePages/functions.php(291): Omeka_Db_Table->findAll()
#9 /var/www/html/spcol/postcards/application/libraries/Zend/Controller/Plugin/Broker.php(237): SimplePagesControllerPlugin->routeStartup(Object(Zend_Controller_Request_Http))
#10 /var/www/html/spcol/postcards/application/libraries/Zend/Controller/Front.php(908): Zend_Controller_Plugin_Broker->routeStartup(Object(Zend_Controller_Request_Http))
#11 /var/www/html/spcol/postcards/application/libraries/Zend/Application/Bootstrap/Bootstrap.php(97): Zend_Controller_Front->dispatch()
#12 /var/www/html/spcol/postcards/application/libraries/Zend/Application.php(366): Zend_Application_Bootstrap_Bootstrap->run()
#13 /var/www/html/spcol/postcards/application/libraries/Omeka/Core.php(166): Zend_Application->run()
#14 /var/www/html/spcol/postcards/admin/index.php(45): Omeka_Core->run()
#15 {main}

Don't understand this because the instance was working the last time we check (been a while), but no changes have been made. Using Omeka 1.5.

Any help or suggestions will be
gratefully appreciated.

Thanks in advance - Russ

That looks like a table, simple_pages_pages, has mysteriously disappeared from the database. If you haven't made changes, it might be that the db was corrupted somehow. If you have a backup of the database, I'd try restoring from that.

Another route would be to uninstall and reinstall the Simple Pages plugin. However, that would lose all of your pages, and you'd have to recreate them, so hopefully we can avoid that.

Hi Patrick,

Thanks for the quick reply! Do you think adding the simple_pages_pages table to the db would work? If not, I'll go with your suggestions first.

Thanks - Russ

If that table isn't there, then that would mean the data is gone anyway, and the quickest thing in that case would be uninstall and reinstall the plugin, then rewrite those pages. If the table is there, then there might be some way to repair or recover the data.

Ok, great -

Thanks for your pointing me in the right direction. Best -

Removed the Simple Pages plugin and that fixed the issue without effect to the site. Apparently, we had no simple pages associated with the site. So I'm thinking that if your not utilizing the plugin, Omeka is looking for something that doesn't exist, which throws the error.

Thanks for the help.
Ps. I'm NOT an Omeka guru - just a fan.