Hello,
We recently upgraded our reference module to 3.4.55 on our Omeka S instance of 4.1.1. and seem to have run into a problem generating our reference blocks. The error that we get is:
🗙
PDOException: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'value.property' in 'where clause' in /data/ibali/omeka-s/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOStatement.php:117
Stack trace:
#0 /data/ibali/omeka-s/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOStatement.php(117): PDOStatement->execute()
#1 /data/ibali/omeka-s/vendor/doctrine/dbal/lib/Doctrine/DBAL/Connection.php(1304): Doctrine\DBAL\Driver\PDOStatement->execute()
#2 /data/ibali/omeka-s/vendor/doctrine/dbal/lib/Doctrine/DBAL/Query/QueryBuilder.php(212): Doctrine\DBAL\Connection->executeQuery()
#3 /data/ibali/omeka-s/modules/Reference/src/Mvc/Controller/Plugin/References.php(2399): Doctrine\DBAL\Query\QueryBuilder->execute()
#4 /data/ibali/omeka-s/modules/Reference/src/Mvc/Controller/Plugin/References.php(606): Reference\Mvc\Controller\Plugin\References->countResourcesForProperties()
#5 /data/ibali/omeka-s/modules/Reference/src/View/Helper/References.php(151): Reference\Mvc\Controller\Plugin\References->count()
#6 /data/ibali/omeka-s/modules/Reference/view/common/block-layout/reference.phtml(16): Reference\View\Helper\References->count()
#7 /data/ibali/omeka-s/vendor/laminas/laminas-view/src/Renderer/PhpRenderer.php(519): include('...')
#8 /data/ibali/omeka-s/vendor/laminas/laminas-view/src/Helper/Partial.php(63): Laminas\View\Renderer\PhpRenderer->render()
#9 /data/ibali/omeka-s/vendor/laminas/laminas-view/src/Renderer/PhpRenderer.php(407): Laminas\View\Helper\Partial->__invoke()
#10 /data/ibali/omeka-s/modules/Reference/src/Site/BlockLayout/Reference.php(183): Laminas\View\Renderer\PhpRenderer->__call()
#11 /data/ibali/omeka-s/application/src/View/Helper/BlockLayout.php(158): Reference\Site\BlockLayout\Reference->render()
#12 /data/ibali/omeka-s/application/src/View/Helper/PageLayout.php(85): Omeka\View\Helper\BlockLayout->render()
#13 /data/ibali/omeka-s/application/view/omeka/site/page/content.phtml(1): Omeka\View\Helper\PageLayout->render()
#14 /data/ibali/omeka-s/vendor/laminas/laminas-view/src/Renderer/PhpRenderer.php(519): include('...')
#15 /data/ibali/omeka-s/vendor/laminas/laminas-view/src/View.php(194): Laminas\View\Renderer\PhpRenderer->render()
#16 /data/ibali/omeka-s/vendor/laminas/laminas-view/src/View.php(222): Laminas\View\View->render()
#17 /data/ibali/omeka-s/vendor/laminas/laminas-view/src/View.php(187): Laminas\View\View->renderChildren()
#18 /data/ibali/omeka-s/vendor/laminas/laminas-view/src/View.php(222): Laminas\View\View->render()
#19 /data/ibali/omeka-s/vendor/laminas/laminas-view/src/View.php(187): Laminas\View\View->renderChildren()
#20 /data/ibali/omeka-s/vendor/laminas/laminas-mvc/src/View/Http/DefaultRenderingStrategy.php(98): Laminas\View\View->render()
#21 /data/ibali/omeka-s/vendor/laminas/laminas-eventmanager/src/EventManager.php(319): Laminas\Mvc\View\Http\DefaultRenderingStrategy->render()
#22 /data/ibali/omeka-s/vendor/laminas/laminas-eventmanager/src/EventManager.php(171): Laminas\EventManager\EventManager->triggerListeners()
#23 /data/ibali/omeka-s/vendor/laminas/laminas-mvc/src/Application.php(360): Laminas\EventManager\EventManager->triggerEvent()
#24 /data/ibali/omeka-s/vendor/laminas/laminas-mvc/src/Application.php(341): Laminas\Mvc\Application->completeRequest()
#25 /data/ibali/omeka-s/index.php(21): Laminas\Mvc\Application->run()
#26 {main}
Next Doctrine\DBAL\Driver\PDO\Exception: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'value.property' in 'where clause' in /data/ibali/omeka-s/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDO/Exception.php:18
Stack trace:
#0 /data/ibali/omeka-s/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOStatement.php(119): Doctrine\DBAL\Driver\PDO\Exception::new()
#1 /data/ibali/omeka-s/vendor/doctrine/dbal/lib/Doctrine/DBAL/Connection.php(1304): Doctrine\DBAL\Driver\PDOStatement->execute()
#2 /data/ibali/omeka-s/vendor/doctrine/dbal/lib/Doctrine/DBAL/Query/QueryBuilder.php(212): Doctrine\DBAL\Connection->executeQuery()
#3 /data/ibali/omeka-s/modules/Reference/src/Mvc/Controller/Plugin/References.php(2399): Doctrine\DBAL\Query\QueryBuilder->execute()
#4 /data/ibali/omeka-s/modules/Reference/src/Mvc/Controller/Plugin/References.php(606): Reference\Mvc\Controller\Plugin\References->countResourcesForProperties()
#5 /data/ibali/omeka-s/modules/Reference/src/View/Helper/References.php(151): Reference\Mvc\Controller\Plugin\References->count()
#6 /data/ibali/omeka-s/modules/Reference/view/common/block-layout/reference.phtml(16): Reference\View\Helper\References->count()
#7 /data/ibali/omeka-s/vendor/laminas/laminas-view/src/Renderer/PhpRenderer.php(519): include('...')
#8 /data/ibali/omeka-s/vendor/laminas/laminas-view/src/Helper/Partial.php(63): Laminas\View\Renderer\PhpRenderer->render()
#9 /data/ibali/omeka-s/vendor/laminas/laminas-view/src/Renderer/PhpRenderer.php(407): Laminas\View\Helper\Partial->__invoke()
#10 /data/ibali/omeka-s/modules/Reference/src/Site/BlockLayout/Reference.php(183): Laminas\View\Renderer\PhpRenderer->__call()
#11 /data/ibali/omeka-s/application/src/View/Helper/BlockLayout.php(158): Reference\Site\BlockLayout\Reference->render()
#12 /data/ibali/omeka-s/application/src/View/Helper/PageLayout.php(85): Omeka\View\Helper\BlockLayout->render()
#13 /data/ibali/omeka-s/application/view/omeka/site/page/content.phtml(1): Omeka\View\Helper\PageLayout->render()
#14 /data/ibali/omeka-s/vendor/laminas/laminas-view/src/Renderer/PhpRenderer.php(519): include('...')
#15 /data/ibali/omeka-s/vendor/laminas/laminas-view/src/View.php(194): Laminas\View\Renderer\PhpRenderer->render()
#16 /data/ibali/omeka-s/vendor/laminas/laminas-view/src/View.php(222): Laminas\View\View->render()
#17 /data/ibali/omeka-s/vendor/laminas/laminas-view/src/View.php(187): Laminas\View\View->renderChildren()
#18 /data/ibali/omeka-s/vendor/laminas/laminas-view/src/View.php(222): Laminas\View\View->render()
#19 /data/ibali/omeka-s/vendor/laminas/laminas-view/src/View.php(187): Laminas\View\View->renderChildren()
#20 /data/ibali/omeka-s/vendor/laminas/laminas-mvc/src/View/Http/DefaultRenderingStrategy.php(98): Laminas\View\View->render()
#21 /data/ibali/omeka-s/vendor/laminas/laminas-eventmanager/src/EventManager.php(319): Laminas\Mvc\View\Http\DefaultRenderingStrategy->render()
#22 /data/ibali/omeka-s/vendor/laminas/laminas-eventmanager/src/EventManager.php(171): Laminas\EventManager\EventManager->triggerListeners()
#23 /data/ibali/omeka-s/vendor/laminas/laminas-mvc/src/Application.php(360): Laminas\EventManager\EventManager->triggerEvent()
#24 /data/ibali/omeka-s/vendor/laminas/laminas-mvc/src/Application.php(341): Laminas\Mvc\Application->completeRequest()
#25 /data/ibali/omeka-s/index.php(21): Laminas\Mvc\Application->run()
#26 {main}
Next Doctrine\DBAL\Exception\InvalidFieldNameException: An exception occurred while executing 'SELECT DISTINCT COUNT(value.value) FROM value value INNER JOIN resource resource ON resource.id = value.resource_id INNER JOIN item rs ON rs.id = resource.id WHERE (value.property IN (?)) AND (value.value IS NOT NULL) AND (resource.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?))' with params [46, 7118, 7119, 7120, 7121, 7122, 7123, 7124, 7125, 7126, 7127, 7128, 7129, 7130, 7131, 7132, 7133, 7134, 7135, 7136, 7137, 7138, 7139, 7140, 7141, 7142, 7143, 7144, 7145, 7146, 7147, 7148, 7149, 7150, 7151, 7152, 7153, 7154, 7155, 7156, 7157, 7158, 7159, 7160, 7161, 7162, 7163, 7164, 7165, 7166, 7167, 7168, 7170, 7172, 7173, 7174, 7175, 7176, 7177, 7178, 7179, 7820, 7821, 7822, 7823, 7824, 7825, 7826, 7827, 7828, 7829, 7830, 7831, 7832, 7833, 7834, 7835, 7836, 7837, 7838, 7839, 7851, 7852, 7853, 7854, 7855, 7856, 7857, 7858, 7859, 7860, 7861, 7862, 7863, 7864, 7865, 7866, 7867, 7868, 7869, 7870, 7874, 7875, 7876, 7877, 7878, 7879, 7880, 7881, 7882, 7883, 7884, 7885, 7886, 7887, 7888, 7889, 7890, 7891, 7892, 7893, 7899, 7900, 7901, 7902, 7903, 7904, 7905, 7906, 7907, 7908, 7909, 7910, 7911, 7912, 7913, 7914, 7915, 7916, 7917, 7918, 7930, 7931, 7932, 7933, 7934, 7935, 7936, 7937, 7938, 7939, 7940, 7941, 7942, 7943, 7944, 7945, 7946, 7947, 7948, 7949, 7960, 7961, 7962, 7963, 7964, 7965, 7966, 7967, 7968, 7969, 7970, 7971, 7972, 7973, 7974, 7975, 7976, 7977, 7978, 7979, 7986, 7987, 7988, 7989, 7990, 7991, 7992, 7993, 7994, 7995, 7996, 7997, 7998, 7999, 8000, 8001, 8002, 8003, 8004, 8005, 8012, 8013, 8014, 8015, 8016, 8017, 8018, 8019, 8020, 8021, 8022, 13183, 13184, 13185, 13186, 13187, 13188, 13189, 13190, 13191, 13192, 13193, 13194, 13195, 13196, 13197, 13198, 13199, 13200, 13201, 13202, 13223, 13224, 13225, 13226, 13227, 13228, 13229, 13230, 13231, 13232, 13233, 13234, 13235, 13236, 13237, 13238, 13239, 13240, 13241, 13242, 13261, 13262, 13263, 13264, 13265, 13266, 13267, 13268, 13269, 13270, 13271, 13272, 13273, 13274, 13275, 13276, 13277, 13278, 13279, 13280, 13296, …
I can’t seem to rollback a reference module version to fix the problem, and am not sure what the issue might be?
Thank you
Sanjin