Advanced Search instalation

Hello i have problem with fresh install of OMEKA-S with few modules when i try to enable Advanced Search module an error is displayed when i enable SetEnv APPLICATION_ENV "development".
The error is:

The module removed tables "search_engine", "search_config", "search_suggester", "search_suggestion" from a previous broken install.

Omeka S срещна грешка

Doctrine\DBAL\Exception\NotNullConstraintViolationException
An exception occurred while executing ‘INSERT INTO search_engine (name, adapter, settings, created) VALUES (?, ?, ?, NOW());’ with params [“Internal (sql)”, null, “{"resource_types":["items"],"engine_adapter":}”]: SQLSTATE[23000]: Integrity constraint violation: 1048 Column ‘adapter’ cannot be null

Детайли:

PDOException: SQLSTATE[23000]: Integrity constraint violation: 1048 Column ‘adapter’ cannot be null in /var/www/html/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOStatement.php:117
Stack trace:
#0 /var/www/html/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOStatement.php(117): PDOStatement->execute()
#1 /var/www/html/vendor/doctrine/dbal/lib/Doctrine/DBAL/Connection.php(1527): Doctrine\DBAL\Driver\PDOStatement->execute()
#2 /var/www/html/modules/AdvancedSearch/Module.php(1555): Doctrine\DBAL\Connection->executeStatement()
#3 /var/www/html/modules/AdvancedSearch/Module.php(1512): AdvancedSearch\Module->createDefaultSearchConfig()
#4 /var/www/html/modules/AdvancedSearch/Module.php(121): AdvancedSearch\Module->installResources()
#5 /var/www/html/modules/Common/TraitModule.php(138): AdvancedSearch\Module->postInstall()
#6 /var/www/html/application/src/Module/Manager.php(226): AdvancedSearch\Module->install()
#7 /var/www/html/application/src/Controller/Admin/ModuleController.php(117): Omeka\Module\Manager->install()
#8 /var/www/html/vendor/laminas/laminas-mvc/src/Controller/AbstractActionController.php(71): Omeka\Controller\Admin\ModuleController->installAction()
#9 /var/www/html/vendor/laminas/laminas-eventmanager/src/EventManager.php(319): Laminas\Mvc\Controller\AbstractActionController->onDispatch()
#10 /var/www/html/vendor/laminas/laminas-eventmanager/src/EventManager.php(179): Laminas\EventManager\EventManager->triggerListeners()
#11 /var/www/html/vendor/laminas/laminas-mvc/src/Controller/AbstractController.php(97): Laminas\EventManager\EventManager->triggerEventUntil()
#12 /var/www/html/vendor/laminas/laminas-mvc/src/DispatchListener.php(132): Laminas\Mvc\Controller\AbstractController->dispatch()
#13 /var/www/html/vendor/laminas/laminas-eventmanager/src/EventManager.php(319): Laminas\Mvc\DispatchListener->onDispatch()
#14 /var/www/html/vendor/laminas/laminas-eventmanager/src/EventManager.php(179): Laminas\EventManager\EventManager->triggerListeners()
#15 /var/www/html/vendor/laminas/laminas-mvc/src/Application.php(325): Laminas\EventManager\EventManager->triggerEventUntil()
#16 /var/www/html/index.php(21): Laminas\Mvc\Application->run()
#17 {main}

Next Doctrine\DBAL\Driver\PDO\Exception: SQLSTATE[23000]: Integrity constraint violation: 1048 Column ‘adapter’ cannot be null in /var/www/html/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDO/Exception.php:18
Stack trace:
#0 /var/www/html/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOStatement.php(119): Doctrine\DBAL\Driver\PDO\Exception::new()
#1 /var/www/html/vendor/doctrine/dbal/lib/Doctrine/DBAL/Connection.php(1527): Doctrine\DBAL\Driver\PDOStatement->execute()
#2 /var/www/html/modules/AdvancedSearch/Module.php(1555): Doctrine\DBAL\Connection->executeStatement()
#3 /var/www/html/modules/AdvancedSearch/Module.php(1512): AdvancedSearch\Module->createDefaultSearchConfig()
#4 /var/www/html/modules/AdvancedSearch/Module.php(121): AdvancedSearch\Module->installResources()
#5 /var/www/html/modules/Common/TraitModule.php(138): AdvancedSearch\Module->postInstall()
#6 /var/www/html/application/src/Module/Manager.php(226): AdvancedSearch\Module->install()
#7 /var/www/html/application/src/Controller/Admin/ModuleController.php(117): Omeka\Module\Manager->install()
#8 /var/www/html/vendor/laminas/laminas-mvc/src/Controller/AbstractActionController.php(71): Omeka\Controller\Admin\ModuleController->installAction()
#9 /var/www/html/vendor/laminas/laminas-eventmanager/src/EventManager.php(319): Laminas\Mvc\Controller\AbstractActionController->onDispatch()
#10 /var/www/html/vendor/laminas/laminas-eventmanager/src/EventManager.php(179): Laminas\EventManager\EventManager->triggerListeners()
#11 /var/www/html/vendor/laminas/laminas-mvc/src/Controller/AbstractController.php(97): Laminas\EventManager\EventManager->triggerEventUntil()
#12 /var/www/html/vendor/laminas/laminas-mvc/src/DispatchListener.php(132): Laminas\Mvc\Controller\AbstractController->dispatch()
#13 /var/www/html/vendor/laminas/laminas-eventmanager/src/EventManager.php(319): Laminas\Mvc\DispatchListener->onDispatch()
#14 /var/www/html/vendor/laminas/laminas-eventmanager/src/EventManager.php(179): Laminas\EventManager\EventManager->triggerListeners()
#15 /var/www/html/vendor/laminas/laminas-mvc/src/Application.php(325): Laminas\EventManager\EventManager->triggerEventUntil()
#16 /var/www/html/index.php(21): Laminas\Mvc\Application->run()
#17 {main}

Next Doctrine\DBAL\Exception\NotNullConstraintViolationException: An exception occurred while executing ‘INSERT INTO search_engine
(name, adapter, settings, created)
VALUES
(?, ?, ?, NOW());’ with params [“Internal (sql)”, null, “{"resource_types":["items"],"engine_adapter":}”]:

SQLSTATE[23000]: Integrity constraint violation: 1048 Column ‘adapter’ cannot be null in /var/www/html/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/AbstractMySQLDriver.php:125
Stack trace:
#0 /var/www/html/vendor/doctrine/dbal/lib/Doctrine/DBAL/DBALException.php(182): Doctrine\DBAL\Driver\AbstractMySQLDriver->convertException()
#1 /var/www/html/vendor/doctrine/dbal/lib/Doctrine/DBAL/DBALException.php(159): Doctrine\DBAL\DBALException::wrapException()
#2 /var/www/html/vendor/doctrine/dbal/lib/Doctrine/DBAL/Connection.php(2226): Doctrine\DBAL\DBALException::driverExceptionDuringQuery()
#3 /var/www/html/vendor/doctrine/dbal/lib/Doctrine/DBAL/Connection.php(1538): Doctrine\DBAL\Connection->handleExceptionDuringQuery()
#4 /var/www/html/modules/AdvancedSearch/Module.php(1555): Doctrine\DBAL\Connection->executeStatement()
#5 /var/www/html/modules/AdvancedSearch/Module.php(1512): AdvancedSearch\Module->createDefaultSearchConfig()
#6 /var/www/html/modules/AdvancedSearch/Module.php(121): AdvancedSearch\Module->installResources()
#7 /var/www/html/modules/Common/TraitModule.php(138): AdvancedSearch\Module->postInstall()
#8 /var/www/html/application/src/Module/Manager.php(226): AdvancedSearch\Module->install()
#9 /var/www/html/application/src/Controller/Admin/ModuleController.php(117): Omeka\Module\Manager->install()
#10 /var/www/html/vendor/laminas/laminas-mvc/src/Controller/AbstractActionController.php(71): Omeka\Controller\Admin\ModuleController->installAction()
#11 /var/www/html/vendor/laminas/laminas-eventmanager/src/EventManager.php(319): Laminas\Mvc\Controller\AbstractActionController->onDispatch()
#12 /var/www/html/vendor/laminas/laminas-eventmanager/src/EventManager.php(179): Laminas\EventManager\EventManager->triggerListeners()
#13 /var/www/html/vendor/laminas/laminas-mvc/src/Controller/AbstractController.php(97): Laminas\EventManager\EventManager->triggerEventUntil()
#14 /var/www/html/vendor/laminas/laminas-mvc/src/DispatchListener.php(132): Laminas\Mvc\Controller\AbstractController->dispatch()
#15 /var/www/html/vendor/laminas/laminas-eventmanager/src/EventManager.php(319): Laminas\Mvc\DispatchListener->onDispatch()
#16 /var/www/html/vendor/laminas/laminas-eventmanager/src/EventManager.php(179): Laminas\EventManager\EventManager->triggerListeners()
#17 /var/www/html/vendor/laminas/laminas-mvc/src/Application.php(325): Laminas\EventManager\EventManager->triggerEventUntil()
#18 /var/www/html/index.php(21): Laminas\Mvc\Application->run()
#19 {main}

Can you please navigate me what i did wrong ?
Thank you.
Svetoslav

I miss to share Omeka-s version is 4.1.1 and Advanced search module version is 3.4.39.
The module removed tables “search_engine”, “search_config”, “search_suggester”, “search_suggestion” from a previous broken install.

Please tell if i miss something on installation process.

Regards

This is fixed in 3.4.40.

Thank you Daniel but i can see in Omeka-s site 3.4.39 as last version and in github is the same. Can you share from where i can get new version?

Regards!
Svetoslav

I’ll publish it on Monday with some other fixes.
You can retry to download the version 3.4.39 nevertheless, i included the fix inside it.

1 Like

3.4.40 is published.

1 Like