No items visible on site after upgrading to 4.0.1

[Leah]

Hello, I have a site that I’ve just upgraded to 4.0.1. The public site won’t display any item sets or search results, although I can navigate directly to items with item/id. Following a link to an item set or navigating to /item-set/id or performing a search or an advanced search all bring up “0 results”. All the item sets and items show up correctly in the admin site.

I have all modules deactivated and have also tried removing them from the file system but the problem persists. I am using the default theme. As far as I can tell this isn’t producing an error.

Thanks,
Leah

[jflatnes]

Check the “Resources” section of the admin for your site. The way items get assigned to sites changed in version 3.0. You can use the Resources section to make changes in bulk to what’s attached to the site, or set those attachments one-by-one in the Sites tab for each item.

[pafa]

Hi.

I’ve been trying to figure out a way to fix this same issue i’m having. I just did a massive upgrade (i was using omeka s 1.4). I “finally” was able update and get it up and running Omeka s 4.0, updated the PHP, modules, themes, etc. Almost everything is working. The front end shows 0 items. On the back end, i have all my items (30k). The resources shows “0 items” assigned to this site.

I added items and created item-sets to see if there were other issues. For the most part, I can add items and create item-sets fine but when i do, it triggers an error. The error log is:

2024-03-25T01:03:38+00:00 ERR (3): PDOException: SQLSTATE[23000]: Integrity constraint violation: 1048 Column ‘title’ cannot be null in /home/pafaarch/public_html/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOStatement.php:117
Stack trace:
#0 /home/pafaarch/public_html/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOStatement.php(117): PDOStatement->execute(NULL)
#1 /home/pafaarch/public_html/vendor/doctrine/dbal/lib/Doctrine/DBAL/Statement.php(179): Doctrine\DBAL\Driver\PDOStatement->execute(NULL)
#2 /home/pafaarch/public_html/vendor/doctrine/dbal/lib/Doctrine/DBAL/Statement.php(226): Doctrine\DBAL\Statement->execute(NULL)
#3 /home/pafaarch/public_html/application/src/Stdlib/FulltextSearch.php(48): Doctrine\DBAL\Statement->executeStatement()
#4 /home/pafaarch/public_html/application/Module.php(566): Omeka\Stdlib\FulltextSearch->save(Object(Omeka\Entity\Media), Object(Omeka\Api\Adapter\MediaAdapter))
#5 /home/pafaarch/public_html/vendor/laminas/laminas-eventmanager/src/EventManager.php(319): Omeka\Module->saveFulltext(Object(Laminas\EventManager\Event))
#6 /home/pafaarch/public_html/vendor/laminas/laminas-eventmanager/src/EventManager.php(171): Laminas\EventManager\EventManager->triggerListeners(Object(Laminas\EventManager\Event))
#7 /home/pafaarch/public_html/application/src/Api/Manager.php(323): Laminas\EventManager\EventManager->triggerEvent(Object(Laminas\EventManager\Event))
#8 /home/pafaarch/public_html/application/src/Api/Manager.php(269): Omeka\Api\Manager->finalize(Object(Omeka\Api\Adapter\ItemAdapter), Object(Omeka\Api\Request), Object(Omeka\Api\Response))
#9 /home/pafaarch/public_html/application/src/Api/Manager.php(78): Omeka\Api\Manager->execute(Object(Omeka\Api\Request))
#10 /home/pafaarch/public_html/application/src/Mvc/Controller/Plugin/Api.php(99): Omeka\Api\Manager->create(‘items’, Array, Array, Array)
#11 /home/pafaarch/public_html/application/src/Controller/Admin/ItemController.php(215): Omeka\Mvc\Controller\Plugin\Api->create(‘items’, Array, Array)
#12 /home/pafaarch/public_html/vendor/laminas/laminas-mvc/src/Controller/AbstractActionController.php(71): Omeka\Controller\Admin\ItemController->addAction()
#13 /home/pafaarch/public_html/vendor/laminas/laminas-eventmanager/src/EventManager.php(319): Laminas\Mvc\Controller\AbstractActionController->onDispatch(Object(Laminas\Mvc\MvcEvent))
#14 /home/pafaarch/public_html/vendor/laminas/laminas-eventmanager/src/EventManager.php(179): Laminas\EventManager\EventManager->triggerListeners(Object(Laminas\Mvc\MvcEvent), Object(Closure))
#15 /home/pafaarch/public_html/vendor/laminas/laminas-mvc/src/Controller/AbstractController.php(97): Laminas\EventManager\EventManager->triggerEventUntil(Object(Closure), Object(Laminas\Mvc\MvcEvent))
#16 /home/pafaarch/public_html/vendor/laminas/laminas-mvc/src/DispatchListener.php(132): Laminas\Mvc\Controller\AbstractController->dispatch(Object(Laminas\Http\PhpEnvironment\Request), Object(Laminas\Http\PhpEnvironment\Response))
#17 /home/pafaarch/public_html/vendor/laminas/laminas-eventmanager/src/EventManager.php(319): Laminas\Mvc\DispatchListener->onDispatch(Object(Laminas\Mvc\MvcEvent))
#18 /home/pafaarch/public_html/vendor/laminas/laminas-eventmanager/src/EventManager.php(179): Laminas\EventManager\EventManager->triggerListeners(Object(Laminas\Mvc\MvcEvent), Object(Closure))
#19 /home/pafaarch/public_html/vendor/laminas/laminas-mvc/src/Application.php(325): Laminas\EventManager\EventManager->triggerEventUntil(Object(Closure), Object(Laminas\Mvc\MvcEvent))
#20 /home/pafaarch/public_html/index.php(21): Laminas\Mvc\Application->run()
#21 {main}

Next Doctrine\DBAL\Driver\PDO\Exception: SQLSTATE[23000]: Integrity constraint violation: 1048 Column ‘title’ cannot be null in /home/pafaarch/public_html/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDO/Exception.php:18
Stack trace:
#0 /home/pafaarch/public_html/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOStatement.php(119): Doctrine\DBAL\Driver\PDO\Exception::new(Object(PDOException))
#1 /home/pafaarch/public_html/vendor/doctrine/dbal/lib/Doctrine/DBAL/Statement.php(179): Doctrine\DBAL\Driver\PDOStatement->execute(NULL)
#2 /home/pafaarch/public_html/vendor/doctrine/dbal/lib/Doctrine/DBAL/Statement.php(226): Doctrine\DBAL\Statement->execute(NULL)
#3 /home/pafaarch/public_html/application/src/Stdlib/FulltextSearch.php(48): Doctrine\DBAL\Statement->executeStatement()
#4 /home/pafaarch/public_html/application/Module.php(566): Omeka\Stdlib\FulltextSearch->save(Object(Omeka\Entity\Media), Object(Omeka\Api\Adapter\MediaAdapter))
#5 /home/pafaarch/public_html/vendor/laminas/laminas-eventmanager/src/EventManager.php(319): Omeka\Module->saveFulltext(Object(Laminas\EventManager\Event))
#6 /home/pafaarch/public_html/vendor/laminas/laminas-eventmanager/src/EventManager.php(171): Laminas\EventManager\EventManager->triggerListeners(Object(Laminas\EventManager\Event))
#7 /home/pafaarch/public_html/application/src/Api/Manager.php(323): Laminas\EventManager\EventManager->triggerEvent(Object(Laminas\EventManager\Event))
#8 /home/pafaarch/public_html/application/src/Api/Manager.php(269): Omeka\Api\Manager->finalize(Object(Omeka\Api\Adapter\ItemAdapter), Object(Omeka\Api\Request), Object(Omeka\Api\Response))
#9 /home/pafaarch/public_html/application/src/Api/Manager.php(78): Omeka\Api\Manager->execute(Object(Omeka\Api\Request))
#10 /home/pafaarch/public_html/application/src/Mvc/Controller/Plugin/Api.php(99): Omeka\Api\Manager->create(‘items’, Array, Array, Array)
#11 /home/pafaarch/public_html/application/src/Controller/Admin/ItemController.php(215): Omeka\Mvc\Controller\Plugin\Api->create(‘items’, Array, Array)
#12 /home/pafaarch/public_html/vendor/laminas/laminas-mvc/src/Controller/AbstractActionController.php(71): Omeka\Controller\Admin\ItemController->addAction()
#13 /home/pafaarch/public_html/vendor/laminas/laminas-eventmanager/src/EventManager.php(319): Laminas\Mvc\Controller\AbstractActionController->onDispatch(Object(Laminas\Mvc\MvcEvent))
#14 /home/pafaarch/public_html/vendor/laminas/laminas-eventmanager/src/EventManager.php(179): Laminas\EventManager\EventManager->triggerListeners(Object(Laminas\Mvc\MvcEvent), Object(Closure))
#15 /home/pafaarch/public_html/vendor/laminas/laminas-mvc/src/Controller/AbstractController.php(97): Laminas\EventManager\EventManager->triggerEventUntil(Object(Closure), Object(Laminas\Mvc\MvcEvent))
#16 /home/pafaarch/public_html/vendor/laminas/laminas-mvc/src/DispatchListener.php(132): Laminas\Mvc\Controller\AbstractController->dispatch(Object(Laminas\Http\PhpEnvironment\Request), Object(Laminas\Http\PhpEnvironment\Response))
#17 /home/pafaarch/public_html/vendor/laminas/laminas-eventmanager/src/EventManager.php(319): Laminas\Mvc\DispatchListener->onDispatch(Object(Laminas\Mvc\MvcEvent))
#18 /home/pafaarch/public_html/vendor/laminas/laminas-eventmanager/src/EventManager.php(179): Laminas\EventManager\EventManager->triggerListeners(Object(Laminas\Mvc\MvcEvent), Object(Closure))
#19 /home/pafaarch/public_html/vendor/laminas/laminas-mvc/src/Application.php(325): Laminas\EventManager\EventManager->triggerEventUntil(Object(Closure), Object(Laminas\Mvc\MvcEvent))
#20 /home/pafaarch/public_html/index.php(21): Laminas\Mvc\Application->run()
#21 {main}

Next Doctrine\DBAL\Exception\NotNullConstraintViolationException: An exception occurred while executing ‘INSERT INTO fulltext_search (
id, resource, owner_id, is_public, title, text
) VALUES (
:id, :resource, :owner_id, :is_public, :title, :text
) ON DUPLICATE KEY UPDATE
owner_id = :owner_id, is_public = :is_public, title = :title, text = :text’ with params [121453, “media”, 1, true, null, “”]:

SQLSTATE[23000]: Integrity constraint violation: 1048 Column ‘title’ cannot be null in /home/pafaarch/public_html/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/AbstractMySQLDriver.php:125
Stack trace:
#0 /home/pafaarch/public_html/vendor/doctrine/dbal/lib/Doctrine/DBAL/DBALException.php(182): Doctrine\DBAL\Driver\AbstractMySQLDriver->convertException(‘An exception oc…’, Object(Doctrine\DBAL\Driver\PDO\Exception))
#1 /home/pafaarch/public_html/vendor/doctrine/dbal/lib/Doctrine/DBAL/DBALException.php(159): Doctrine\DBAL\DBALException::wrapException(Object(Doctrine\DBAL\Driver\PDO\MySQL\Driver), Object(Doctrine\DBAL\Driver\PDO\Exception), ‘An exception oc…’)
#2 /home/pafaarch/public_html/vendor/doctrine/dbal/lib/Doctrine/DBAL/Connection.php(2226): Doctrine\DBAL\DBALException::driverExceptionDuringQuery(Object(Doctrine\DBAL\Driver\PDO\MySQL\Driver), Object(Doctrine\DBAL\Driver\PDO\Exception), ‘INSERT INTO fu...', Array) #3 /home/pafaarch/public_html/vendor/doctrine/dbal/lib/Doctrine/DBAL/Statement.php(185): Doctrine\DBAL\Connection->handleExceptionDuringQuery(Object(Doctrine\DBAL\Driver\PDO\Exception), 'INSERT INTO fu…’, Array, Array)
#4 /home/pafaarch/public_html/vendor/doctrine/dbal/lib/Doctrine/DBAL/Statement.php(226): Doctrine\DBAL\Statement->execute(NULL)
#5 /home/pafaarch/public_html/application/src/Stdlib/FulltextSearch.php(48): Doctrine\DBAL\Statement->executeStatement()
#6 /home/pafaarch/public_html/application/Module.php(566): Omeka\Stdlib\FulltextSearch->save(Object(Omeka\Entity\Media), Object(Omeka\Api\Adapter\MediaAdapter))
#7 /home/pafaarch/public_html/vendor/laminas/laminas-eventmanager/src/EventManager.php(319): Omeka\Module->saveFulltext(Object(Laminas\EventManager\Event))
#8 /home/pafaarch/public_html/vendor/laminas/laminas-eventmanager/src/EventManager.php(171): Laminas\EventManager\EventManager->triggerListeners(Object(Laminas\EventManager\Event))
#9 /home/pafaarch/public_html/application/src/Api/Manager.php(323): Laminas\EventManager\EventManager->triggerEvent(Object(Laminas\EventManager\Event))
#10 /home/pafaarch/public_html/application/src/Api/Manager.php(269): Omeka\Api\Manager->finalize(Object(Omeka\Api\Adapter\ItemAdapter), Object(Omeka\Api\Request), Object(Omeka\Api\Response))
#11 /home/pafaarch/public_html/application/src/Api/Manager.php(78): Omeka\Api\Manager->execute(Object(Omeka\Api\Request))
#12 /home/pafaarch/public_html/application/src/Mvc/Controller/Plugin/Api.php(99): Omeka\Api\Manager->create(‘items’, Array, Array, Array)
#13 /home/pafaarch/public_html/application/src/Controller/Admin/ItemController.php(215): Omeka\Mvc\Controller\Plugin\Api->create(‘items’, Array, Array)
#14 /home/pafaarch/public_html/vendor/laminas/laminas-mvc/src/Controller/AbstractActionController.php(71): Omeka\Controller\Admin\ItemController->addAction()
#15 /home/pafaarch/public_html/vendor/laminas/laminas-eventmanager/src/EventManager.php(319): Laminas\Mvc\Controller\AbstractActionController->onDispatch(Object(Laminas\Mvc\MvcEvent))
#16 /home/pafaarch/public_html/vendor/laminas/laminas-eventmanager/src/EventManager.php(179): Laminas\EventManager\EventManager->triggerListeners(Object(Laminas\Mvc\MvcEvent), Object(Closure))
#17 /home/pafaarch/public_html/vendor/laminas/laminas-mvc/src/Controller/AbstractController.php(97): Laminas\EventManager\EventManager->triggerEventUntil(Object(Closure), Object(Laminas\Mvc\MvcEvent))
#18 /home/pafaarch/public_html/vendor/laminas/laminas-mvc/src/DispatchListener.php(132): Laminas\Mvc\Controller\AbstractController->dispatch(Object(Laminas\Http\PhpEnvironment\Request), Object(Laminas\Http\PhpEnvironment\Response))
#19 /home/pafaarch/public_html/vendor/laminas/laminas-eventmanager/src/EventManager.php(319): Laminas\Mvc\DispatchListener->onDispatch(Object(Laminas\Mvc\MvcEvent))
#20 /home/pafaarch/public_html/vendor/laminas/laminas-eventmanager/src/EventManager.php(179): Laminas\EventManager\EventManager->triggerListeners(Object(Laminas\Mvc\MvcEvent), Object(Closure))
#21 /home/pafaarch/public_html/vendor/laminas/laminas-mvc/src/Application.php(325): Laminas\EventManager\EventManager->triggerEventUntil(Object(Closure), Object(Laminas\Mvc\MvcEvent))
#22 /home/pafaarch/public_html/index.php(21): Laminas\Mvc\Application->run()
#23 {main}

I will say during the update phase today, i did get the “fulltext_search” error. I deleted/uninstalled the Advanced Search modules since that looked to be giving me trouble during testing.