DIsplay Items (Collections etc.) Error

Hi,
I have a test installation with a few records only which I upgraded to 1.5

The server is on Siteground.
Kernel Version 2.6.38.6-sg4-nomm-nogrsec
Program Version Apache: 1.3.42
Curl: 7.15.5
MySQL 5.0.92
PostgreSQL 8.4.5
Python: 2.4.3
ImageMagic: 6.4.3
Perl: 5.8.8
PHP: 5.2.5
ionCube Loader: 3.1.31
Zend Optimizer: 3.3.3
phpMyAdmin 3.3.10.2
OpenSSL: 0.9.8e-fips-rhel5

I now cannot display records except in administrative view.

I do not really understand php/mysql except to copy code devised by others.

Any ideas?

The error log is as follows:
2012-02-14T13:39:18-06:00 ERR (3): exception 'Zend_Db_Statement_Mysqli_Exception' with message 'Mysqli prepare error: Unknown column 'ct.record_id' in 'where clause'' in /home/jamesonl/public_html/omeka/application/libraries/Zend/Db/Statement/Mysqli.php:77
Stack trace:
#0 /home/jamesonl/public_html/omeka/application/libraries/Zend/Db/Statement.php(115): Zend_Db_Statement_Mysqli->_prepare('SELECT ct.* F...')
#1 /home/jamesonl/public_html/omeka/application/libraries/Zend/Db/Adapter/Mysqli.php(381): Zend_Db_Statement->__construct(Object(Zend_Db_Adapter_Mysqli), 'SELECT ct.* F...')
#2 /home/jamesonl/public_html/omeka/application/libraries/Zend/Db/Adapter/Abstract.php(478): Zend_Db_Adapter_Mysqli->prepare('SELECT ct.* F...')
#3 /home/jamesonl/public_html/omeka/application/libraries/Omeka/Db.php(83): Zend_Db_Adapter_Abstract->query(Object(Omeka_Db_Select), Array)
#4 /home/jamesonl/public_html/omeka/application/libraries/Omeka/Db/Table.php(478): Omeka_Db->__call(Array, Array)
#5 /home/jamesonl/public_html/omeka/application/libraries/Omeka/Db/Table.php(478): Omeka_Db->query('query', Array)
#6 /home/jamesonl/public_html/omeka/plugins/Commenting/helpers/commenting.php(71): Omeka_Db_Table->fetchObjects(Object(Omeka_Db_Select), Array)
#7 /home/jamesonl/public_html/omeka/plugins/Commenting/helpers/commenting.php(18): commenting_get_comments(Object(Omeka_Db_Select))
#8 /home/jamesonl/public_html/omeka/plugins/Commenting/CommentingPlugin.php(85): commenting_echo_comments('2', 'Collection', Array)
#9 /home/jamesonl/public_html/omeka/application/libraries/Omeka/Plugin/Broker.php(156): CommentingPlugin->hookPublicAppendToCollectionsShow(Array)
#10 /home/jamesonl/public_html/omeka/application/libraries/Omeka/Plugin/Broker.php(182): Omeka_Plugin_Broker->callHook()
#11 [internal function]: Omeka_Plugin_Broker->__call(Array, Array)
#12 /home/jamesonl/public_html/omeka/application/libraries/globals.php(215): Omeka_Plugin_Broker->public_append_to_collections_show('public_append_t...', Array)
#13 /home/jamesonl/public_html/omeka/application/libraries/globals.php(234): fire_plugin_hook('public_append_t...', Array)
#14 /home/jamesonl/public_html/omeka/application/helpers/PluginFunctions.php(123): get_plugin_hook_output()
#15 /home/jamesonl/public_html/omeka/application/views/scripts/collections/show.php(50): plugin_append_to_collections_show()
#16 /home/jamesonl/public_html/omeka/application/libraries/Omeka/View.php(113): include('/home/jamesonl/...')
#17 /home/jamesonl/public_html/omeka/application/libraries/Zend/View/Abstract.php(888): Omeka_View->_run()
#18 /home/jamesonl/public_html/omeka/application/libraries/Zend/Controller/Action/Helper/ViewRenderer.php(900): Zend_View_Abstract->render(Array, Array)
#19 /home/jamesonl/public_html/omeka/application/libraries/Zend/Controller/Action/Helper/ViewRenderer.php(921): Zend_Controller_Action_Helper_ViewRenderer->renderScript('public_append_t...')
#20 /home/jamesonl/public_html/omeka/application/libraries/Zend/Controller/Action/Helper/ViewRenderer.php(960): Zend_Controller_Action_Helper_ViewRenderer->render('fire_plugin_hoo...', Array)
#21 /home/jamesonl/public_html/omeka/application/libraries/Zend/Controller/Action/HelperBroker.php(277): Zend_Controller_Action_Helper_ViewRenderer->postDispatch('public_append_t...')
#22 /home/jamesonl/public_html/omeka/application/libraries/Zend/Controller/Action.php(527): Zend_Controller_Action_HelperBroker->notifyPostDispatch()
#23 /home/jamesonl/public_html/omeka/application/libraries/Zend/Controller/Dispatcher/Standard.php(295): Zend_Controller_Action->dispatch('/home/jamesonl/...')
#24 /home/jamesonl/public_html/omeka/application/libraries/Zend/Controller/Front.php(954): Zend_Controller_Dispatcher_Standard->dispatch('collections/sho...')
#25 /home/jamesonl/public_html/omeka/application/libraries/Zend/Application/Bootstrap/Bootstrap.php(97): Zend_Controller_Front->dispatch('collections/sho...', NULL)
#26 /home/jamesonl/public_html/omeka/application/libraries/Zend/Application.php(366): Zend_Application_Bootstrap_Bootstrap->run()
#27 /home/jamesonl/public_html/omeka/application/libraries/Omeka/Core.php(165): Zend_Application->run()
#28 /home/jamesonl/public_html/omeka/index.php(28): Omeka_Core->run()
#29 {main}
2012-02-14T13:39:28-06:00 ERR (3): exception 'Zend_Db_Statement_Mysqli_Exception' with message 'Mysqli prepare error: Unknown column 'ct.record_id' in 'where clause'' in /home/jamesonl/public_html/omeka/application/libraries/Zend/Db/Statement/Mysqli.php:77
Stack trace:
#0 /home/jamesonl/public_html/omeka/application/libraries/Zend/Db/Statement.php(115): Zend_Db_Statement_Mysqli->_prepare('SELECT ct.* F...')
#1 /home/jamesonl/public_html/omeka/application/libraries/Zend/Db/Adapter/Mysqli.php(381): Zend_Db_Statement->__construct(Object(Zend_Db_Adapter_Mysqli), 'SELECT ct.* F...')
#2 /home/jamesonl/public_html/omeka/application/libraries/Zend/Db/Adapter/Abstract.php(478): Zend_Db_Adapter_Mysqli->prepare('SELECT ct.* F...')
#3 /home/jamesonl/public_html/omeka/application/libraries/Omeka/Db.php(83): Zend_Db_Adapter_Abstract->query(Object(Omeka_Db_Select), Array)
#4 /home/jamesonl/public_html/omeka/application/libraries/Omeka/Db/Table.php(478): Omeka_Db->__call(Array, Array)
#5 /home/jamesonl/public_html/omeka/application/libraries/Omeka/Db/Table.php(478): Omeka_Db->query('query', Array)
#6 /home/jamesonl/public_html/omeka/plugins/Commenting/helpers/commenting.php(71): Omeka_Db_Table->fetchObjects(Object(Omeka_Db_Select), Array)
#7 /home/jamesonl/public_html/omeka/plugins/Commenting/helpers/commenting.php(18): commenting_get_comments(Object(Omeka_Db_Select))
#8 /home/jamesonl/public_html/omeka/plugins/Commenting/CommentingPlugin.php(85): commenting_echo_comments('22', 'Collection', Array)
#9 /home/jamesonl/public_html/omeka/application/libraries/Omeka/Plugin/Broker.php(156): CommentingPlugin->hookPublicAppendToCollectionsShow(Array)
#10 /home/jamesonl/public_html/omeka/application/libraries/Omeka/Plugin/Broker.php(182): Omeka_Plugin_Broker->callHook()
#11 [internal function]: Omeka_Plugin_Broker->__call(Array, Array)
#12 /home/jamesonl/public_html/omeka/application/libraries/globals.php(215): Omeka_Plugin_Broker->public_append_to_collections_show('public_append_t...', Array)
#13 /home/jamesonl/public_html/omeka/application/libraries/globals.php(234): fire_plugin_hook('public_append_t...', Array)
#14 /home/jamesonl/public_html/omeka/application/helpers/PluginFunctions.php(123): get_plugin_hook_output()
#15 /home/jamesonl/public_html/omeka/application/views/scripts/collections/show.php(50): plugin_append_to_collections_show()
#16 /home/jamesonl/public_html/omeka/application/libraries/Omeka/View.php(113): include('/home/jamesonl/...')
#17 /home/jamesonl/public_html/omeka/application/libraries/Zend/View/Abstract.php(888): Omeka_View->_run()
#18 /home/jamesonl/public_html/omeka/application/libraries/Zend/Controller/Action/Helper/ViewRenderer.php(900): Zend_View_Abstract->render(Array, Array)
#19 /home/jamesonl/public_html/omeka/application/libraries/Zend/Controller/Action/Helper/ViewRenderer.php(921): Zend_Controller_Action_Helper_ViewRenderer->renderScript('public_append_t...')
#20 /home/jamesonl/public_html/omeka/application/libraries/Zend/Controller/Action/Helper/ViewRenderer.php(960): Zend_Controller_Action_Helper_ViewRenderer->render('fire_plugin_hoo...', Array)
#21 /home/jamesonl/public_html/omeka/application/libraries/Zend/Controller/Action/HelperBroker.php(277): Zend_Controller_Action_Helper_ViewRenderer->postDispatch('public_append_t...')
#22 /home/jamesonl/public_html/omeka/application/libraries/Zend/Controller/Action.php(527): Zend_Controller_Action_HelperBroker->notifyPostDispatch()
#23 /home/jamesonl/public_html/omeka/application/libraries/Zend/Controller/Dispatcher/Standard.php(295): Zend_Controller_Action->dispatch('/home/jamesonl/...')
#24 /home/jamesonl/public_html/omeka/application/libraries/Zend/Controller/Front.php(954): Zend_Controller_Dispatcher_Standard->dispatch('collections/sho...')
#25 /home/jamesonl/public_html/omeka/application/libraries/Zend/Application/Bootstrap/Bootstrap.php(97): Zend_Controller_Front->dispatch('collections/sho...', NULL)
#26 /home/jamesonl/public_html/omeka/application/libraries/Zend/Application.php(366): Zend_Application_Bootstrap_Bootstrap->run()
#27 /home/jamesonl/public_html/omeka/application/libraries/Omeka/Core.php(165): Zend_Application->run()
#28 /home/jamesonl/public_html/omeka/index.php(28): Omeka_Core->run()
#29 {main}
2012-02-14T13:39:36-06:00 ERR (3): exception 'Zend_Db_Statement_Mysqli_Exception' with message 'Mysqli prepare error: Unknown column 'ct.record_id' in 'where clause'' in /home/jamesonl/public_html/omeka/application/libraries/Zend/Db/Statement/Mysqli.php:77
Stack trace:
#0 /home/jamesonl/public_html/omeka/application/libraries/Zend/Db/Statement.php(115): Zend_Db_Statement_Mysqli->_prepare('SELECT ct.* F...')
#1 /home/jamesonl/public_html/omeka/application/libraries/Zend/Db/Adapter/Mysqli.php(381): Zend_Db_Statement->__construct(Object(Zend_Db_Adapter_Mysqli), 'SELECT ct.* F...')
#2 /home/jamesonl/public_html/omeka/application/libraries/Zend/Db/Adapter/Abstract.php(478): Zend_Db_Adapter_Mysqli->prepare('SELECT ct.* F...')
#3 /home/jamesonl/public_html/omeka/application/libraries/Omeka/Db.php(83): Zend_Db_Adapter_Abstract->query(Object(Omeka_Db_Select), Array)
#4 /home/jamesonl/public_html/omeka/application/libraries/Omeka/Db/Table.php(478): Omeka_Db->__call(Array, Array)
#5 /home/jamesonl/public_html/omeka/application/libraries/Omeka/Db/Table.php(478): Omeka_Db->query('query', Array)
#6 /home/jamesonl/public_html/omeka/plugins/Commenting/helpers/commenting.php(71): Omeka_Db_Table->fetchObjects(Object(Omeka_Db_Select), Array)
#7 /home/jamesonl/public_html/omeka/plugins/Commenting/helpers/commenting.php(18): commenting_get_comments(Object(Omeka_Db_Select))
#8 /home/jamesonl/public_html/omeka/plugins/Commenting/CommentingPlugin.php(85): commenting_echo_comments('1', 'Collection', Array)
#9 /home/jamesonl/public_html/omeka/application/libraries/Omeka/Plugin/Broker.php(156): CommentingPlugin->hookPublicAppendToCollectionsShow(Array)
#10 /home/jamesonl/public_html/omeka/application/libraries/Omeka/Plugin/Broker.php(182): Omeka_Plugin_Broker->callHook()
#11 [internal function]: Omeka_Plugin_Broker->__call(Array, Array)
#12 /home/jamesonl/public_html/omeka/application/libraries/globals.php(215): Omeka_Plugin_Broker->public_append_to_collections_show('public_append_t...', Array)
#13 /home/jamesonl/public_html/omeka/application/libraries/globals.php(234): fire_plugin_hook('public_append_t...', Array)
#14 /home/jamesonl/public_html/omeka/application/helpers/PluginFunctions.php(123): get_plugin_hook_output()
#15 /home/jamesonl/public_html/omeka/application/views/scripts/collections/show.php(50): plugin_append_to_collections_show()
#16 /home/jamesonl/public_html/omeka/application/libraries/Omeka/View.php(113): include('/home/jamesonl/...')
#17 /home/jamesonl/public_html/omeka/application/libraries/Zend/View/Abstract.php(888): Omeka_View->_run()
#18 /home/jamesonl/public_html/omeka/application/libraries/Zend/Controller/Action/Helper/ViewRenderer.php(900): Zend_View_Abstract->render(Array, Array)
#19 /home/jamesonl/public_html/omeka/application/libraries/Zend/Controller/Action/Helper/ViewRenderer.php(921): Zend_Controller_Action_Helper_ViewRenderer->renderScript('public_append_t...')
#20 /home/jamesonl/public_html/omeka/application/libraries/Zend/Controller/Action/Helper/ViewRenderer.php(960): Zend_Controller_Action_Helper_ViewRenderer->render('fire_plugin_hoo...', Array)
#21 /home/jamesonl/public_html/omeka/application/libraries/Zend/Controller/Action/HelperBroker.php(277): Zend_Controller_Action_Helper_ViewRenderer->postDispatch('public_append_t...')
#22 /home/jamesonl/public_html/omeka/application/libraries/Zend/Controller/Action.php(527): Zend_Controller_Action_HelperBroker->notifyPostDispatch()
#23 /home/jamesonl/public_html/omeka/application/libraries/Zend/Controller/Dispatcher/Standard.php(295): Zend_Controller_Action->dispatch('/home/jamesonl/...')
#24 /home/jamesonl/public_html/omeka/application/libraries/Zend/Controller/Front.php(954): Zend_Controller_Dispatcher_Standard->dispatch('collections/sho...')
#25 /home/jamesonl/public_html/omeka/application/libraries/Zend/Application/Bootstrap/Bootstrap.php(97): Zend_Controller_Front->dispatch('collections/sho...', NULL)
#26 /home/jamesonl/public_html/omeka/application/libraries/Zend/Application.php(366): Zend_Application_Bootstrap_Bootstrap->run()
#27 /home/jamesonl/public_html/omeka/application/libraries/Omeka/Core.php(165): Zend_Application->run()
#28 /home/jamesonl/public_html/omeka/index.php(28): Omeka_Core->run()
#29 {main}
2012-02-14T13:46:29-06:00 ERR (3): exception 'Zend_Db_Statement_Mysqli_Exception' with message 'Mysqli prepare error: Unknown column 'ct.record_id' in 'where clause'' in /home/jamesonl/public_html/omeka/application/libraries/Zend/Db/Statement/Mysqli.php:77
Stack trace:
#0 /home/jamesonl/public_html/omeka/application/libraries/Zend/Db/Statement.php(115): Zend_Db_Statement_Mysqli->_prepare('SELECT ct.* F...')
#1 /home/jamesonl/public_html/omeka/application/libraries/Zend/Db/Adapter/Mysqli.php(381): Zend_Db_Statement->__construct(Object(Zend_Db_Adapter_Mysqli), 'SELECT ct.* F...')
#2 /home/jamesonl/public_html/omeka/application/libraries/Zend/Db/Adapter/Abstract.php(478): Zend_Db_Adapter_Mysqli->prepare('SELECT ct.* F...')
#3 /home/jamesonl/public_html/omeka/application/libraries/Omeka/Db.php(83): Zend_Db_Adapter_Abstract->query(Object(Omeka_Db_Select), Array)
#4 /home/jamesonl/public_html/omeka/application/libraries/Omeka/Db/Table.php(478): Omeka_Db->__call(Array, Array)
#5 /home/jamesonl/public_html/omeka/application/libraries/Omeka/Db/Table.php(478): Omeka_Db->query('query', Array)
#6 /home/jamesonl/public_html/omeka/plugins/Commenting/helpers/commenting.php(71): Omeka_Db_Table->fetchObjects(Object(Omeka_Db_Select), Array)
#7 /home/jamesonl/public_html/omeka/plugins/Commenting/helpers/commenting.php(18): commenting_get_comments(Object(Omeka_Db_Select))
#8 /home/jamesonl/public_html/omeka/plugins/Commenting/CommentingPlugin.php(78): commenting_echo_comments('5', 'Item', Array)
#9 /home/jamesonl/public_html/omeka/application/libraries/Omeka/Plugin/Broker.php(156): CommentingPlugin->hookPublicAppendToItemsShow(Array)
#10 /home/jamesonl/public_html/omeka/application/libraries/Omeka/Plugin/Broker.php(182): Omeka_Plugin_Broker->callHook()
#11 [internal function]: Omeka_Plugin_Broker->__call(Array, Array)
#12 /home/jamesonl/public_html/omeka/application/libraries/globals.php(215): Omeka_Plugin_Broker->public_append_to_items_show('public_append_t...', Array)
#13 /home/jamesonl/public_html/omeka/application/libraries/globals.php(234): fire_plugin_hook('public_append_t...', Array)
#14 /home/jamesonl/public_html/omeka/application/helpers/PluginFunctions.php(92): get_plugin_hook_output()
#15 /home/jamesonl/public_html/omeka/application/views/scripts/items/show.php(37): plugin_append_to_items_show()
#16 /home/jamesonl/public_html/omeka/application/libraries/Omeka/View.php(113): include('/home/jamesonl/...')
#17 /home/jamesonl/public_html/omeka/application/libraries/Zend/View/Abstract.php(888): Omeka_View->_run()
#18 /home/jamesonl/public_html/omeka/application/libraries/Zend/Controller/Action/Helper/ViewRenderer.php(900): Zend_View_Abstract->render(Array, Array)
#19 /home/jamesonl/public_html/omeka/application/libraries/Zend/Controller/Action/Helper/ViewRenderer.php(921): Zend_Controller_Action_Helper_ViewRenderer->renderScript('public_append_t...')
#20 /home/jamesonl/public_html/omeka/application/libraries/Zend/Controller/Action/Helper/ViewRenderer.php(960): Zend_Controller_Action_Helper_ViewRenderer->render('fire_plugin_hoo...', Array)
#21 /home/jamesonl/public_html/omeka/application/libraries/Zend/Controller/Action/HelperBroker.php(277): Zend_Controller_Action_Helper_ViewRenderer->postDispatch('public_append_t...')
#22 /home/jamesonl/public_html/omeka/application/libraries/Zend/Controller/Action.php(527): Zend_Controller_Action_HelperBroker->notifyPostDispatch()
#23 /home/jamesonl/public_html/omeka/application/libraries/Zend/Controller/Dispatcher/Standard.php(295): Zend_Controller_Action->dispatch('/home/jamesonl/...')
#24 /home/jamesonl/public_html/omeka/application/libraries/Zend/Controller/Front.php(954): Zend_Controller_Dispatcher_Standard->dispatch('items/show.php')
#25 /home/jamesonl/public_html/omeka/application/libraries/Zend/Application/Bootstrap/Bootstrap.php(97): Zend_Controller_Front->dispatch('items/show.php', NULL)
#26 /home/jamesonl/public_html/omeka/application/libraries/Zend/Application.php(366): Zend_Application_Bootstrap_Bootstrap->run()
#27 /home/jamesonl/public_html/omeka/application/libraries/Omeka/Core.php(165): Zend_Application->run()
#28 /home/jamesonl/public_html/omeka/index.php(28): Omeka_Core->run()
#29 {main}
2012-02-14T13:47:24-06:00 ERR (3): exception 'Zend_Db_Statement_Mysqli_Exception' with message 'Mysqli prepare error: Unknown column 'ct.record_id' in 'where clause'' in /home/jamesonl/public_html/omeka/application/libraries/Zend/Db/Statement/Mysqli.php:77
Stack trace:
#0 /home/jamesonl/public_html/omeka/application/libraries/Zend/Db/Statement.php(115): Zend_Db_Statement_Mysqli->_prepare('SELECT ct.* F...')
#1 /home/jamesonl/public_html/omeka/application/libraries/Zend/Db/Adapter/Mysqli.php(381): Zend_Db_Statement->__construct(Object(Zend_Db_Adapter_Mysqli), 'SELECT ct.* F...')
#2 /home/jamesonl/public_html/omeka/application/libraries/Zend/Db/Adapter/Abstract.php(478): Zend_Db_Adapter_Mysqli->prepare('SELECT ct.* F...')
#3 /home/jamesonl/public_html/omeka/application/libraries/Omeka/Db.php(83): Zend_Db_Adapter_Abstract->query(Object(Omeka_Db_Select), Array)
#4 /home/jamesonl/public_html/omeka/application/libraries/Omeka/Db/Table.php(478): Omeka_Db->__call(Array, Array)
#5 /home/jamesonl/public_html/omeka/application/libraries/Omeka/Db/Table.php(478): Omeka_Db->query('query', Array)
#6 /home/jamesonl/public_html/omeka/plugins/Commenting/helpers/commenting.php(71): Omeka_Db_Table->fetchObjects(Object(Omeka_Db_Select), Array)
#7 /home/jamesonl/public_html/omeka/plugins/Commenting/helpers/commenting.php(18): commenting_get_comments(Object(Omeka_Db_Select))
#8 /home/jamesonl/public_html/omeka/plugins/Commenting/CommentingPlugin.php(78): commenting_echo_comments('5', 'Item', Array)
#9 /home/jamesonl/public_html/omeka/application/libraries/Omeka/Plugin/Broker.php(156): CommentingPlugin->hookPublicAppendToItemsShow(Array)
#10 /home/jamesonl/public_html/omeka/application/libraries/Omeka/Plugin/Broker.php(182): Omeka_Plugin_Broker->callHook()
#11 [internal function]: Omeka_Plugin_Broker->__call(Array, Array)
#12 /home/jamesonl/public_html/omeka/application/libraries/globals.php(215): Omeka_Plugin_Broker->public_append_to_items_show('public_append_t...', Array)
#13 /home/jamesonl/public_html/omeka/application/libraries/globals.php(234): fire_plugin_hook('public_append_t...', Array)
#14 /home/jamesonl/public_html/omeka/application/helpers/PluginFunctions.php(92): get_plugin_hook_output()
#15 /home/jamesonl/public_html/omeka/application/views/scripts/items/show.php(37): plugin_append_to_items_show()
#16 /home/jamesonl/public_html/omeka/application/libraries/Omeka/View.php(113): include('/home/jamesonl/...')
#17 /home/jamesonl/public_html/omeka/application/libraries/Zend/View/Abstract.php(888): Omeka_View->_run()
#18 /home/jamesonl/public_html/omeka/application/libraries/Zend/Controller/Action/Helper/ViewRenderer.php(900): Zend_View_Abstract->render(Array, Array)
#19 /home/jamesonl/public_html/omeka/application/libraries/Zend/Controller/Action/Helper/ViewRenderer.php(921): Zend_Controller_Action_Helper_ViewRenderer->renderScript('public_append_t...')
#20 /home/jamesonl/public_html/omeka/application/libraries/Zend/Controller/Action/Helper/ViewRenderer.php(960): Zend_Controller_Action_Helper_ViewRenderer->render('fire_plugin_hoo...', Array)
#21 /home/jamesonl/public_html/omeka/application/libraries/Zend/Controller/Action/HelperBroker.php(277): Zend_Controller_Action_Helper_ViewRenderer->postDispatch('public_append_t...')
#22 /home/jamesonl/public_html/omeka/application/libraries/Zend/Controller/Action.php(527): Zend_Controller_Action_HelperBroker->notifyPostDispatch()
#23 /home/jamesonl/public_html/omeka/application/libraries/Zend/Controller/Dispatcher/Standard.php(295): Zend_Controller_Action->dispatch('/home/jamesonl/...')
#24 /home/jamesonl/public_html/omeka/application/libraries/Zend/Controller/Front.php(954): Zend_Controller_Dispatcher_Standard->dispatch('items/show.php')
#25 /home/jamesonl/public_html/omeka/application/libraries/Zend/Application/Bootstrap/Bootstrap.php(97): Zend_Controller_Front->dispatch('items/show.php', NULL)
#26 /home/jamesonl/public_html/omeka/application/libraries/Zend/Application.php(366): Zend_Application_Bootstrap_Bootstrap->run()
#27 /home/jamesonl/public_html/omeka/application/libraries/Omeka/Core.php(165): Zend_Application->run()
#28 /home/jamesonl/public_html/omeka/index.php(28): Omeka_Core->run()
#29 {main}
2012-02-14T13:50:13-06:00 ERR (3): exception 'Zend_Db_Statement_Mysqli_Exception' with message 'Mysqli prepare error: Unknown column 'ct.record_id' in 'where clause'' in /home/jamesonl/public_html/omeka/application/libraries/Zend/Db/Statement/Mysqli.php:77
Stack trace:
#0 /home/jamesonl/public_html/omeka/application/libraries/Zend/Db/Statement.php(115): Zend_Db_Statement_Mysqli->_prepare('SELECT ct.* F...')
#1 /home/jamesonl/public_html/omeka/application/libraries/Zend/Db/Adapter/Mysqli.php(381): Zend_Db_Statement->__construct(Object(Zend_Db_Adapter_Mysqli), 'SELECT ct.* F...')
#2 /home/jamesonl/public_html/omeka/application/libraries/Zend/Db/Adapter/Abstract.php(478): Zend_Db_Adapter_Mysqli->prepare('SELECT ct.* F...')
#3 /home/jamesonl/public_html/omeka/application/libraries/Omeka/Db.php(83): Zend_Db_Adapter_Abstract->query(Object(Omeka_Db_Select), Array)
#4 /home/jamesonl/public_html/omeka/application/libraries/Omeka/Db/Table.php(478): Omeka_Db->__call(Array, Array)
#5 /home/jamesonl/public_html/omeka/application/libraries/Omeka/Db/Table.php(478): Omeka_Db->query('query', Array)
#6 /home/jamesonl/public_html/omeka/plugins/Commenting/helpers/commenting.php(71): Omeka_Db_Table->fetchObjects(Object(Omeka_Db_Select), Array)
#7 /home/jamesonl/public_html/omeka/plugins/Commenting/helpers/commenting.php(18): commenting_get_comments(Object(Omeka_Db_Select))
#8 /home/jamesonl/public_html/omeka/plugins/Commenting/CommentingPlugin.php(78): commenting_echo_comments('3', 'Item', Array)
#9 /home/jamesonl/public_html/omeka/application/libraries/Omeka/Plugin/Broker.php(156): CommentingPlugin->hookPublicAppendToItemsShow(Array)
#10 /home/jamesonl/public_html/omeka/application/libraries/Omeka/Plugin/Broker.php(182): Omeka_Plugin_Broker->callHook()
#11 [internal function]: Omeka_Plugin_Broker->__call(Array, Array)
#12 /home/jamesonl/public_html/omeka/application/libraries/globals.php(215): Omeka_Plugin_Broker->public_append_to_items_show('public_append_t...', Array)
#13 /home/jamesonl/public_html/omeka/application/libraries/globals.php(234): fire_plugin_hook('public_append_t...', Array)
#14 /home/jamesonl/public_html/omeka/application/helpers/PluginFunctions.php(92): get_plugin_hook_output()
#15 /home/jamesonl/public_html/omeka/application/views/scripts/items/show.php(37): plugin_append_to_items_show()
#16 /home/jamesonl/public_html/omeka/application/libraries/Omeka/View.php(113): include('/home/jamesonl/...')
#17 /home/jamesonl/public_html/omeka/application/libraries/Zend/View/Abstract.php(888): Omeka_View->_run()
#18 /home/jamesonl/public_html/omeka/application/libraries/Zend/Controller/Action/Helper/ViewRenderer.php(900): Zend_View_Abstract->render(Array, Array)
#19 /home/jamesonl/public_html/omeka/application/libraries/Zend/Controller/Action/Helper/ViewRenderer.php(921): Zend_Controller_Action_Helper_ViewRenderer->renderScript('public_append_t...')
#20 /home/jamesonl/public_html/omeka/application/libraries/Zend/Controller/Action/Helper/ViewRenderer.php(960): Zend_Controller_Action_Helper_ViewRenderer->render('fire_plugin_hoo...', Array)
#21 /home/jamesonl/public_html/omeka/application/libraries/Zend/Controller/Action/HelperBroker.php(277): Zend_Controller_Action_Helper_ViewRenderer->postDispatch('public_append_t...')
#22 /home/jamesonl/public_html/omeka/application/libraries/Zend/Controller/Action.php(527): Zend_Controller_Action_HelperBroker->notifyPostDispatch()
#23 /home/jamesonl/public_html/omeka/application/libraries/Zend/Controller/Dispatcher/Standard.php(295): Zend_Controller_Action->dispatch('/home/jamesonl/...')
#24 /home/jamesonl/public_html/omeka/application/libraries/Zend/Controller/Front.php(954): Zend_Controller_Dispatcher_Standard->dispatch('items/show.php')
#25 /home/jamesonl/public_html/omeka/application/libraries/Zend/Application/Bootstrap/Bootstrap.php(97): Zend_Controller_Front->dispatch('items/show.php', NULL)
#26 /home/jamesonl/public_html/omeka/application/libraries/Zend/Application.php(366): Zend_Application_Bootstrap_Bootstrap->run()
#27 /home/jamesonl/public_html/omeka/application/libraries/Omeka/Core.php(165): Zend_Application->run()
#28 /home/jamesonl/public_html/omeka/index.php(28): Omeka_Core->run()
#29 {main}

Try temporarily disabling the Commenting plugin.

That seems to be what's causing those errors.

Hi John,
Thanks for the help, its working fine now. However, as you may remember from a previous post my people do want to use commenting, so is someone debugging the plugin, please...?
James

I'd try uninstalling and reinstalling the Commenting plugin.

That error looks like something may have gone wrong in the process of installing the plugin; uninstalling and reinstalling it might resolve that.

Thanks again, worked a treat.
James

I've been working on the Commenting plugin, so I'll see if I can recreate the problem and build in a fix. Thanks for the feedback!

Hi Patrick, you're welcome.
Great to be able to help a good product.
My repository team saw the old comment module which did the * ratings and were asking if that would come back. I said I would ask!
James

No current plans, but if there is demand it could pretty easily be built as a separate plugin.