search in omeka and getting error : Table 'omeka3.omeka_s' doesn't exist

Hi
i have imported some data into solr and that data not exist in omeka. then i import data in omeka but when i search that data (exists in solr and omeka) by omeka plug in solr search i get error this error:
Mysqli prepare error: Table 'omeka3.omeka_s' doesn't exist

what is omeka_s table? what information stored in it?

in the debug mode:

DEBUG (7): SELECT name, value FROM omeka_options

DEBUG (7): SELECT plugins.* FROM omeka_plugins AS plugins

DEBUG (7): SELECT users.* FROM omeka_users AS users WHERE (users.id = 1) AND (active = 1) LIMIT 1

DEBUG (7): SELECT solr_search_fields.* FROM omeka_solr_search_fields AS solr_search_fields WHERE (is_facet=?)

DEBUG (7): SELECT s.* FROM omeka_s AS s WHERE (s.id = 0) LIMIT 1

There's no table in Omeka itself called just "s", and probably not one in any plugin either, at least not by design.

Does this happen only when you're trying to do a Solr search, or anywhere else? If it's just Solr, then you'd probably want to contact the SolrSearch plugin developers for help diagnosing the problem.

In addition, it'll be helpful in figuring out what's going wrong if you record the full error output, including the traceback, of the error you were receiving. The traceback in particular should show what's trying to access the "s" table.

thank's john!

for more detail of my problem another topic exists:

http://omeka.org/forums/topic/import-to-solr-and-seaech-by-omeka

Stack trace:
#0 [omekaHome]\application\libraries\Zend\Db\Statement.php(115): Zend_Db_Statement_Mysqli->_prepare('SELECT s.* FR...')

#1 [omekaHome]\application\libraries\Zend\Db\Adapter\Mysqli.php(388): Zend_Db_Statement->__construct(Object(Zend_Db_Adapter_Mysqli), 'SELECT s.* FR...')

#2 [omekaHome]\application\libraries\Zend\Db\Adapter\Abstract.php(479): Zend_Db_Adapter_Mysqli->prepare('SELECT s.* FR...')

#3 [omekaHome]\application\libraries\Zend\Db\Adapter\Abstract.php(756): Zend_Db_Adapter_Abstract->query(Object(Omeka_Db_Select), Array)

#4 [internal function]: Zend_Db_Adapter_Abstract->fetchRow(Object(Omeka_Db_Select), Array)

#5 [omekaHome]\application\libraries\Omeka\Db.php(79): call_user_func_array(Array, Array)

#6 [omekaHome]\application\libraries\Omeka\Db\Table.php(670): Omeka_Db->__call('fetchRow', Array)

#7 [omekaHome]\application\libraries\Omeka\Db\Table.php(670): Omeka_Db->fetchRow(Object(Omeka_Db_Select), Array)

#8 [omekaHome]\application\libraries\Omeka\Db\Table.php(214): Omeka_Db_Table->fetchObject(Object(Omeka_Db_Select), Array)

#9 [omekaHome]\plugins\SolrSearch\helpers\SolrSearch_Helpers_View.php(92): Omeka_Db_Table->find(NULL)

#10 [omekaHome]\plugins\SolrSearch\views\shared\results\index.php(116): SolrSearch_Helpers_View::getDocumentUrl(Object(Apache_Solr_Document))

#11 [omekaHome]\application\libraries\Omeka\View.php(117): include('C:\\wamp\\www\\ome...')

#12 [omekaHome]\application\libraries\Zend\View\Abstract.php(888): Omeka_View->_run('C:\\wamp\\www\\ome...')

#13 [omekaHome]\application\libraries\Zend\Controller\Action\Helper\ViewRenderer.php(905): Zend_View_Abstract->render('results/index.p...')

#14 [omekaHome]\application\libraries\Zend\Controller\Action\Helper\ViewRenderer.php(926): Zend_Controller_Action_Helper_ViewRenderer->renderScript('results/index.p...', NULL)

#15 [omekaHome]\application\libraries\Zend\Controller\Action\Helper\ViewRenderer.php(965): Zend_Controller_Action_Helper_ViewRenderer->render()

#16 [omekaHome]\application\libraries\Zend\Controller\Action\HelperBroker.php(277): Zend_Controller_Action_Helper_ViewRenderer->postDispatch()

#17 [omekaHome]\application\libraries\Zend\Controller\Action.php(527): Zend_Controller_Action_HelperBroker->notifyPostDispatch()

#18 [omekaHome]\application\libraries\Zend\Controller\Dispatcher\Standard.php(308): Zend_Controller_Action->dispatch('indexAction')

#19 [omekaHome]\application\libraries\Zend\Controller\Front.php(954): Zend_Controller_Dispatcher_Standard->dispatch(Object(Zend_Controller_Request_Http), Object(Zend_Controller_Response_Http))

#20 [omekaHome]\application\libraries\Zend\Application\Bootstrap\Bootstrap.php(105): Zend_Controller_Front->dispatch()

#21 [omekaHome]\application\libraries\Zend\Application.php(382): Zend_Application_Bootstrap_Bootstrap->run()

#22 [omekaHome]\application\libraries\Omeka\Application.php(79): Zend_Application->run()

#23 [omekaHome]\index.php(23): Omeka_Application->run()

#24 {main}

From what you posted, it looks like the problem is with the "model" field on the Solr document(s) you inserted yourself.

The SolrSearch plugin reads that and uses it to try to look up the corresponding Omeka object (so, the "model" field is usually something like "Item"). It looks like the document you manually added had a value of "s" for the "model" field, and that's what's causing this error.

problem resolved!

we should set model and modelid fields in solr.

thank's a lot john!