Error when search using boolean /exact match | Omeka 2.7.0
Nobody has claimed this yet.
Assessment
- Difficulty
- 3/5
- Estimated time
- 1-2 days
- Newbie friendliness
- 35/100
Research direction
Start by reproducing the boolean or exact-match search failure in Omeka 2.7.0 with the Reports plugin enabled, then inspect application/views/scripts/search/index.php and the Reports plugin code involved in get_record_by_id('Reports_Report', 1). Confirm which table lookup produces the missing omeka_reports_reports error; done means the search completes without that database exception and existing report tables remain usable.
Written by the indexing model from the issue text.
Description
When searching with these option form the home page, it brokes. Deactiving the plugin works fine
The plugins seems to work fine, but the next table reports_reports is not in the DB. The existing plugin tables are:
| omeka_reports
| omeka_reports_files
| omeka_reports_items
ERROR:
Zend_Db_Statement_Mysqli_Exception
Mysqli prepare error: Table 'db.omeka_reports_reports' doesn't exist
Zend_Db_Statement_Mysqli_Exception: Mysqli prepare error: Table 'db.omeka_reports_reports' doesn't exist in /var/www/html/application/libraries/Zend/Db/Statement/Mysqli.php:77
Stack trace:
#0 /var/www/html/application/libraries/Zend/Db/Statement.php(115): Zend_Db_Statement_Mysqli->_prepare('SELECT `reports...')
#1 /var/www/html/application/libraries/Zend/Db/Adapter/Mysqli.php(388): Zend_Db_Statement->__construct(Object(Zend_Db_Adapter_Mysqli), 'SELECT `reports...')
#2 /var/www/html/application/libraries/Zend/Db/Adapter/Abstract.php(479): Zend_Db_Adapter_Mysqli->prepare('SELECT `reports...')
#3 /var/www/html/application/libraries/Zend/Db/Adapter/Abstract.php(756): Zend_Db_Adapter_Abstract->query('SELECT `reports...', Array)
#4 /var/www/html/application/libraries/Omeka/Db.php(80): Zend_Db_Adapter_Abstract->fetchRow(Object(Omeka_Db_Select), Array)
#5 /var/www/html/application/libraries/Omeka/Db/Table.php(669): Omeka_Db->__call('fetchRow', Array)
#6 /var/www/html/application/libraries/Omeka/Db/Table.php(214): Omeka_Db_Table->fetchObject(Object(Omeka_Db_Select), Array)
#7 /var/www/html/application/libraries/globals.php(1879): Omeka_Db_Table->find(1)
#8 /var/www/html/application/views/scripts/search/index.php(20): get_record_by_id('Reports_Report', 1)
#9 /var/www/html/application/libraries/Omeka/View.php(114): include('/var/www/html/a...')
#10 /var/www/html/application/libraries/Zend/View/Abstract.php(888): Omeka_View->_run('/var/www/html/a...')
#11 /var/www/html/application/libraries/Zend/Controller/Action/Helper/ViewRenderer.php(912): Zend_View_Abstract->render(NULL)
#12 /var/www/html/application/libraries/Zend/Controller/Action/Helper/ViewRenderer.php(933): Zend_Controller_Action_Helper_ViewRenderer->renderScript('search/index.ph...', NULL)
#13 /var/www/html/application/libraries/Zend/Controller/Action/Helper/ViewRenderer.php(972): Zend_Controller_Action_Helper_ViewRenderer->render()
#14 /var/www/html/application/libraries/Zend/Controller/Action/HelperBroker.php(277): Zend_Controller_Action_Helper_ViewRenderer->postDispatch()
#15 /var/www/html/application/libraries/Zend/Controller/Action.php(527): Zend_Controller_Action_HelperBroker->notifyPostDispatch()
#16 /var/www/html/application/libraries/Zend/Controller/Dispatcher/Standard.php(308): Zend_Controller_Action->dispatch('indexAction')
#17 /var/www/html/application/libraries/Zend/Controller/Front.php(954): Zend_Controller_Dispatcher_Standard->dispatch(Object(Zend_Controller_Request_Http), Object(Zend_Controller_Response_Http))
#18 /var/www/html/application/libraries/Zend/Application/Bootstrap/Bootstrap.php(105): Zend_Controller_Front->dispatch()
#19 /var/www/html/application/libraries/Zend/Application.php(384): Zend_Application_Bootstrap_Bootstrap->run()
#20 /var/www/html/application/libraries/Omeka/Application.php(73): Zend_Application->run()
#21 /var/www/html/index.php(23): Omeka_Application->run()
#22 {main}
- Dominant language
- PHP
- Stars
- 6
- Forks
- 6
- PR merge metrics
- No merged PRs in 30d
Getting set up
This project ships no dev container, Dockerfile or contributing guide, so setting up is up to you: start from its README, and see our first-contribution guide for the general steps.
First steps
- Read the whole issue, then the project's contributing guide.
- Comment on the issue to say you are picking it up — it saves two people doing the same work.
- Fork the repository and make your change on a branch.
- Open a pull request that references the issue number.
More from omeka/plugin-Reports
-
Difficulty 3/5 1-2 days Newbie friendliness 45/100
omeka/plugin-Reports#18 ·
-
Difficulty 3/5 1-2 days Newbie friendliness 35/100
omeka/plugin-Reports#8 ·
-
Difficulty 4/5 3-5 days Newbie friendliness 25/100
omeka/plugin-Reports#2 · 3 comments ·
-
Difficulty 5/5 Over a week Newbie friendliness 30/100
omeka/plugin-Reports#1 · 2 comments ·
All issues in omeka/plugin-Reports
Similar issues
-
Difficulty 2/5 1-3 hours Newbie friendliness 72/100
Maintainers usually reply within 1 day
-
sync-en
Difficulty 1/5 Under an hour Newbie friendliness 85/100
Maintainers usually reply within 1 day
-
sync-en
Difficulty 1/5 Under an hour Newbie friendliness 85/100
Maintainers usually reply within 1 day
-
Перевод устарел
Difficulty 2/5 1-3 hours Newbie friendliness 70/100
Maintainers usually reply within 1 day
-
bug
Difficulty 2/5 1-3 hours Newbie friendliness 72/100
nplhse/collaborative-ivena-statistics#1464 · 1 comment ·
Maintainers usually reply within 1 day