Installing Advanced Search and Removing Advanced Search Plus

sanjinmuftic · September 16, 2021, 2:25pm

Hello,

I am working with Omeka v3.02 and I was looking to get the Advanced Search Module set up (3.3.6.3). However the first time I put it up on the module folders, our platform became irresponsive - 500 Error and I couldn’t even login. I removed the module folder and it was working again. I think the cause might be that I had an active Advanced Search Plus Module (version 3.3.5.3) working on our system (on my dev site on my local machine the Advanced Search Plus was not installed). I noticed that the Advanced Search Plus is now replaced with Advanced Search and on my dev system with ASP deactivated and installing AS seems to have done this process.

So while I would like to confirm that this was probably the cause of the system going down as I would like to move to the Advanced Search Module. I realize I would probably need to do this in this order:

Deactivate Advanced Search Plus
Copy over Advanced Search into Module Folder
Install Advance Search (if site does not crash)
Activate Advance Search

However currently on the system I have many search strings which I think use the Advanced Search Plus functionality, and I just wanted to check that my query strings will not have to be redone, for example:

fulltext_search=&property%5B0%5D%5Bjoiner%5D=and&property%5B0%5D%5Bproperty%5D=450&property%5B0%5D%5Btype%5D=eq&property%5B0%5D%5Btext%5D=A&resource_class_id%5B0%5D=&resource_template_id%5B0%5D=&item_set_id%5B0%5D=1454&site_id=&owner_id=&datetime%5B0%5D%5Bjoiner%5D=and&datetime%5B0%5D%5Bfield%5D=created&datetime%5B0%5D%5Btype%5D=gte&datetime%5B0%5D%5Bvalue%5D=&is_public=&has_media=&has_original=&has_thumbnails=&has_tags=0&numeric%5Bts%5D%5Bgt%5D%5Bpid%5D=&numeric%5Bts%5D%5Bgt%5D%5Bval%5D=&numeric%5Bts%5D%5Blt%5D%5Bpid%5D=&numeric%5Bts%5D%5Blt%5D%5Bval%5D=&numeric%5Bdur%5D%5Bgt%5D%5Bpid%5D=&numeric%5Bdur%5D%5Bgt%5D%5Bval%5D=&numeric%5Bdur%5D%5Blt%5D%5Bpid%5D=&numeric%5Bdur%5D%5Blt%5D%5Bval%5D=&numeric%5Bivl%5D%5Bpid%5D=&numeric%5Bivl%5D%5Bval%5D=&numeric%5Bint%5D%5Bgt%5D%5Bpid%5D=&numeric%5Bint%5D%5Bgt%5D%5Bval%5D=&numeric%5Bint%5D%5Blt%5D%5Bpid%5D=&numeric%5Bint%5D%5Blt%5D%5Bval%5D=&year=&month=&day=&hour=&minute=&second=&offset=&years=&months=&days=&hours=&minutes=&seconds=&integer=&submit=Search&page=1&sort_by=schema:familyName&sort_order=asc

I can see that the moment i deactivated ASP (without having Advanced Search set up) those queries did not give me any results on the webpages. I am hoping that Advanced Search will just pick them up, am I right to assume that?

Thank you very much,

I am including the Omeka S Config is below:

Omeka S
Version 3.0.2
PHP
Version 7.2.34-23+ubuntu18.04.1+deb.sury.org+1
SAPI apache2handler
Memory Limit 256M
POST Size Limit 256M
File Upload Limit 1024M
Garbage Collection Yes
Extensions apache2handler, bz2, calendar, Core, ctype, curl, date, dom, exif, fileinfo, filter, ftp, gettext, hash, iconv, json, libxml, mbstring, mysqli, mysqlnd, openssl, pcre, PDO, pdo_mysql, Phar, posix, readline, Reflection, session, shmop, SimpleXML, sockets, sodium, SPL, standard, sysvmsg, sysvsem, sysvshm, tokenizer, wddx, xml, xmlreader, xmlwriter, xsl, Zend OPcache, zip, zlib
Disabled Functions , pcntl_alarm, pcntl_async_signals, pcntl_exec, pcntl_fork, pcntl_getpriority, pcntl_get_last_error, pcntl_setpriority, pcntl_signal, pcntl_signal_dispatch, pcntl_signal_get_handler, pcntl_sigprocmask, pcntl_sigtimedwait, pcntl_sigwaitinfo, pcntl_strerror, pcntl_wait, pcntl_waitpid, pcntl_wexitstatus, pcntl_wifcontinued, pcntl_wifexited, pcntl_wifsignaled, pcntl_wifstopped, pcntl_wstopsig, pcntl_wtermsig
MySQL
Server Version 5.7.35-0ubuntu0.18.04.1
Client Version mysqlnd 5.0.12-dev - 20150407 - $Id: 3591daad22de08524295e1bd073aceeff11e6579 $
Mode ONLY_FULL_GROUP_BY, STRICT_TRANS_TABLES, NO_ZERO_IN_DATE, NO_ZERO_DATE, ERROR_FOR_DIVISION_BY_ZERO, NO_AUTO_CREATE_USER, NO_ENGINE_SUBSTITUTION
OS
Version Linux 5.4.0-81-generic x86_64

modules

Module	State
Advanced Resource Template version 3.3.4.8	Inactive
Advanced Search Plus version 3.3.5.3	Active
Alt Text version 1.2.1	Active
Analytics Snippet version 3.3.3.1	Active
Annotate version 3.3.3.6-beta-3	Active
Blocks Disposition version 3.3.2.2	Active
Bulk Edit version 3.3.12.4	Active
Collecting version 1.6.0	Active
CSSEditor version 1.3.0	Active
CSV Import version 2.2.1	Active
Custom Ontology version 3.3.5.1	Active
Custom Vocab version 1.3.1	Active
DataScribe version 1.0.0-beta	Active
Dspace Connector version 1.2.0	Inactive
EasyInstall version 3.2.5	not in filesystem
EU Cookie Bar version 3.3.4.3	Active
Export version 1.5.0	Active
Extract Ocr version 3.3.2.1	Not Installed
Extract Text version 1.2.0	Active
Faceted Browse version 1.0.0	Wrong version
Faceted Search version 0.1.0	Inactive
File Sideload version 1.4.0	Active
Folksonomy version 3.3.10.2	Active
Footnotes version 3.3.0.1-3.4.1	Active
Generic module version 3.3.28	Active
Google Analytics version 1.1.2	Active
Group version 3.3.4.1	Active
Hide Properties version 1.3.0	Active
IIIF Server version 3.6.3.2	Inactive
Image Server version 3.6.5.3	Not Installed
Internationalisation version 3.3.10.0	Not Installed
Item Carousel Block version 0.1.0	Active
Item Sets Tree version 0.3.0	Active
ItemCopy version 1.0.1	Inactive
Lockout version 3.3.4	Inactive
Log version 3.3.12.6	Active
Mapping version 1.4.0	Active
Meta Tags version 3.3.0.4	Active
Metadata Browse version 1.4.0	Active
Mirador Viewer version 3.1.7.2	Wrong version
Next version 3.3.39.2	Active
Numeric Data Types version 1.5.1	Active
OAI-PMH Repository version 3.3.5.3	Inactive
OaiPmhHarvester version 3.0.5	not in filesystem
PDF Embed version 1.2.0	Active
RdfDatatype version 3.0.4	not in filesystem
Reciprocal version 3.0.0	Wrong version
Reference version 3.4.30.3	Active
RestrictedSites version 2.0	Active
Rights Statements version 1.2.0	Active
Search version 0.9.0	Active
Sharing version 1.2.0	Active
Simple Carousel version 1.3.0	Active
SiteSlugAsSubdomain version 1.0.0	Inactive
Timeline version 3.4.14.3	Active
unAPI version 1.2.0	Not Installed
Universal Viewer version 3.6.4.4	Active
URI Dereferencer version 1.1.0	Inactive
UserNames version 1.0	Not Installed
Value Suggest version 1.8.0	Active
Value Suggest: Any version 3.3.0.4	Active
Wikidata version 1.3.0	Inactive

sanjinmuftic · September 16, 2021, 6:15pm

On a further exploration I am wondering if the Search module is the problem. My dev site had it active, and when i tried to install AdvanceSearch there was a warning that flashed on the modules page to uninstall it first. I guess on my main site it doesn’t even get to that point.

Search version 0.9.0 by BibLibre Add search capabilities to Omeka S

It might be that I need to uninstall Search first, before trying to upload the AdvancedSearch module into the modules folder?

sanjinmuftic · September 18, 2021, 1:48pm

So i have done some more of the clean up of the modules and found that in the root of my modules folders there is a composer.phar file and i am not sure it might be causing some issues. I can even see it online https://ibali.uct.ac.za/modules/composer.phar

I also noticed that I had a an out of date version of RDF datatypes and have now installed and upgraded it to the DataTypeRDF.

I was going to keep trying to copy over Advanced Search onto my server to see what happens, and keep trying to debug it by switching off certain modules. But I did want to check that by copying it over onto the server, I won’t be damaging what is on the omeka system and database?

Thanks for your help.

sanjinmuftic · September 19, 2021, 8:09am

So I did a thorough clean up of my modules and not only uninstalled but also removed them from the server, and the the installation of the module and the upgrade worked. Not quite sure what the offending module was.

sanjinmuftic · November 27, 2021, 8:40pm

Hello again,

When preparing for an upgrade to Omeka 3.1.1. on my test server I ran into a similar problem with upgrade of the AdvancedSearch Module (3.3.6.8). Even after deactivating all the other the modules, on leaving only the really necessary one I was not able to get Omeka working.

The application log has the following:

2021-11-27T20:22:18+00:00 ERR (3): PDOException: SQLSTATE[HY000]: General error: 3065 Expression #1 of ORDER BY clause is not in SELECT list, references column 'omeka.vocabulary.id' which is not in SELECT list; this is incompatible with DISTINCT in /Applications/MAMP/htdocs/omeka-s/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOConnection.php:132
Stack trace:
#0 /Applications/MAMP/htdocs/omeka-s/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOConnection.php(132): PDO->query('SELECT DISTINCT...')
#1 /Applications/MAMP/htdocs/omeka-s/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOQueryImplementation.php(36): Doctrine\DBAL\Driver\PDOConnection->doQuery(Object(Doctrine\DBAL\Query\QueryBuilder))
#2 /Applications/MAMP/htdocs/omeka-s/vendor/doctrine/dbal/lib/Doctrine/DBAL/Connection.php(1297): Doctrine\DBAL\Driver\PDOConnection->query(Object(Doctrine\DBAL\Query\QueryBuilder))
#3 /Applications/MAMP/htdocs/omeka-s/modules/AdvancedSearch/src/Adapter/InternalAdapter.php(61): Doctrine\DBAL\Connection->executeQuery(Object(Doctrine\DBAL\Query\QueryBuilder))
#4 /Applications/MAMP/htdocs/omeka-s/modules/AdvancedSearch/src/Form/MainSearchForm.php(903): AdvancedSearch\Adapter\InternalAdapter->getAvailableFields()
#5 /Applications/MAMP/htdocs/omeka-s/modules/AdvancedSearch/src/Form/MainSearchForm.php(113): AdvancedSearch\Form\MainSearchForm->getAvailableFields()
#6 /Applications/MAMP/htdocs/omeka-s/vendor/laminas/laminas-form/src/FormElementManager/FormElementManagerV3Polyfill.php(323): AdvancedSearch\Form\MainSearchForm->init()
#7 /Applications/MAMP/htdocs/omeka-s/vendor/laminas/laminas-servicemanager/src/ServiceManager.php(780): Laminas\Form\FormElementManager\FormElementManagerV3Polyfill->callElementInit(Object(Laminas\ServiceManager\ServiceManager), Object(AdvancedSearch\Form\MainSearchForm))
#8 /Applications/MAMP/htdocs/omeka-s/vendor/laminas/laminas-servicemanager/src/ServiceManager.php(228): Laminas\ServiceManager\ServiceManager->doCreate('AdvancedSearch\\...', Array)
#9 /Applications/MAMP/htdocs/omeka-s/vendor/laminas/laminas-servicemanager/src/AbstractPluginManager.php(153): Laminas\ServiceManager\ServiceManager->build('AdvancedSearch\\...', Array)
#10 /Applications/MAMP/htdocs/omeka-s/vendor/laminas/laminas-form/src/FormElementManager/FormElementManagerTrait.php(56): Laminas\ServiceManager\AbstractPluginManager->get('AdvancedSearch\\...', Array, true)
#11 /Applications/MAMP/htdocs/omeka-s/modules/AdvancedSearch/src/Api/Representation/SearchConfigRepresentation.php(204): Laminas\Form\FormElementManager\FormElementManagerV3Polyfill->get('AdvancedSearch\\...', Array)
#12 /Applications/MAMP/htdocs/omeka-s/modules/AdvancedSearch/src/Api/Representation/SearchConfigRepresentation.php(137): AdvancedSearch\Api\Representation\SearchConfigRepresentation->formInit()
#13 /Applications/MAMP/htdocs/omeka-s/modules/AdvancedSearch/Module.php(1373): AdvancedSearch\Api\Representation\SearchConfigRepresentation->formAdapter()
#14 /Applications/MAMP/htdocs/omeka-s/vendor/laminas/laminas-eventmanager/src/EventManager.php(321): AdvancedSearch\Module->addHeaders(Object(Laminas\EventManager\Event))
#15 /Applications/MAMP/htdocs/omeka-s/vendor/laminas/laminas-eventmanager/src/EventManager.php(170): Laminas\EventManager\EventManager->triggerListeners(Object(Laminas\EventManager\Event))
#16 /Applications/MAMP/htdocs/omeka-s/application/src/View/Helper/Trigger.php(60): Laminas\EventManager\EventManager->triggerEvent(Object(Laminas\EventManager\Event))
#17 [internal function]: Omeka\View\Helper\Trigger->__invoke('view.layout')
#18 /Applications/MAMP/htdocs/omeka-s/vendor/laminas/laminas-view/src/Renderer/PhpRenderer.php(396): call_user_func_array(Object(Omeka\View\Helper\Trigger), Array)
#19 /Applications/MAMP/htdocs/omeka-s/application/view/layout/layout-admin.phtml(25): Laminas\View\Renderer\PhpRenderer->__call('trigger', Array)
#20 /Applications/MAMP/htdocs/omeka-s/vendor/laminas/laminas-view/src/Renderer/PhpRenderer.php(505): include('/Applications/M...')
#21 /Applications/MAMP/htdocs/omeka-s/vendor/laminas/laminas-view/src/View.php(206): Laminas\View\Renderer\PhpRenderer->render(NULL)
#22 /Applications/MAMP/htdocs/omeka-s/vendor/laminas/laminas-mvc/src/View/Http/DefaultRenderingStrategy.php(104): Laminas\View\View->render(Object(Laminas\View\Model\ViewModel))
#23 /Applications/MAMP/htdocs/omeka-s/vendor/laminas/laminas-eventmanager/src/EventManager.php(321): Laminas\Mvc\View\Http\DefaultRenderingStrategy->render(Object(Laminas\Mvc\MvcEvent))
#24 /Applications/MAMP/htdocs/omeka-s/vendor/laminas/laminas-eventmanager/src/EventManager.php(170): Laminas\EventManager\EventManager->triggerListeners(Object(Laminas\Mvc\MvcEvent))
#25 /Applications/MAMP/htdocs/omeka-s/vendor/laminas/laminas-mvc/src/Application.php(366): Laminas\EventManager\EventManager->triggerEvent(Object(Laminas\Mvc\MvcEvent))
#26 /Applications/MAMP/htdocs/omeka-s/vendor/laminas/laminas-mvc/src/Application.php(347): Laminas\Mvc\Application->completeRequest(Object(Laminas\Mvc\MvcEvent))
#27 /Applications/MAMP/htdocs/omeka-s/index.php(21): Laminas\Mvc\Application->run()
#28 {main}

Next Doctrine\DBAL\Driver\PDO\Exception: SQLSTATE[HY000]: General error: 3065 Expression #1 of ORDER BY clause is not in SELECT list, references column 'omeka.vocabulary.id' which is not in SELECT list; this is incompatible with DISTINCT in /Applications/MAMP/htdocs/omeka-s/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDO/Exception.php:18
Stack trace:
#0 /Applications/MAMP/htdocs/omeka-s/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOConnection.php(134): Doctrine\DBAL\Driver\PDO\Exception::new(Object(PDOException))
#1 /Applications/MAMP/htdocs/omeka-s/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOQueryImplementation.php(36): Doctrine\DBAL\Driver\PDOConnection->doQuery(Object(Doctrine\DBAL\Query\QueryBuilder))
#2 /Applications/MAMP/htdocs/omeka-s/vendor/doctrine/dbal/lib/Doctrine/DBAL/Connection.php(1297): Doctrine\DBAL\Driver\PDOConnection->query(Object(Doctrine\DBAL\Query\QueryBuilder))
#3 /Applications/MAMP/htdocs/omeka-s/modules/AdvancedSearch/src/Adapter/InternalAdapter.php(61): Doctrine\DBAL\Connection->executeQuery(Object(Doctrine\DBAL\Query\QueryBuilder))
#4 /Applications/MAMP/htdocs/omeka-s/modules/AdvancedSearch/src/Form/MainSearchForm.php(903): AdvancedSearch\Adapter\InternalAdapter->getAvailableFields()
#5 /Applications/MAMP/htdocs/omeka-s/modules/AdvancedSearch/src/Form/MainSearchForm.php(113): AdvancedSearch\Form\MainSearchForm->getAvailableFields()
#6 /Applications/MAMP/htdocs/omeka-s/vendor/laminas/laminas-form/src/FormElementManager/FormElementManagerV3Polyfill.php(323): AdvancedSearch\Form\MainSearchForm->init()
#7 /Applications/MAMP/htdocs/omeka-s/vendor/laminas/laminas-servicemanager/src/ServiceManager.php(780): Laminas\Form\FormElementManager\FormElementManagerV3Polyfill->callElementInit(Object(Laminas\ServiceManager\ServiceManager), Object(AdvancedSearch\Form\MainSearchForm))
#8 /Applications/MAMP/htdocs/omeka-s/vendor/laminas/laminas-servicemanager/src/ServiceManager.php(228): Laminas\ServiceManager\ServiceManager->doCreate('AdvancedSearch\\...', Array)
#9 /Applications/MAMP/htdocs/omeka-s/vendor/laminas/laminas-servicemanager/src/AbstractPluginManager.php(153): Laminas\ServiceManager\ServiceManager->build('AdvancedSearch\\...', Array)
#10 /Applications/MAMP/htdocs/omeka-s/vendor/laminas/laminas-form/src/FormElementManager/FormElementManagerTrait.php(56): Laminas\ServiceManager\AbstractPluginManager->get('AdvancedSearch\\...', Array, true)
#11 /Applications/MAMP/htdocs/omeka-s/modules/AdvancedSearch/src/Api/Representation/SearchConfigRepresentation.php(204): Laminas\Form\FormElementManager\FormElementManagerV3Polyfill->get('AdvancedSearch\\...', Array)
#12 /Applications/MAMP/htdocs/omeka-s/modules/AdvancedSearch/src/Api/Representation/SearchConfigRepresentation.php(137): AdvancedSearch\Api\Representation\SearchConfigRepresentation->formInit()
#13 /Applications/MAMP/htdocs/omeka-s/modules/AdvancedSearch/Module.php(1373): AdvancedSearch\Api\Representation\SearchConfigRepresentation->formAdapter()
#14 /Applications/MAMP/htdocs/omeka-s/vendor/laminas/laminas-eventmanager/src/EventManager.php(321): AdvancedSearch\Module->addHeaders(Object(Laminas\EventManager\Event))
#15 /Applications/MAMP/htdocs/omeka-s/vendor/laminas/laminas-eventmanager/src/EventManager.php(170): Laminas\EventManager\EventManager->triggerListeners(Object(Laminas\EventManager\Event))
#16 /Applications/MAMP/htdocs/omeka-s/application/src/View/Helper/Trigger.php(60): Laminas\EventManager\EventManager->triggerEvent(Object(Laminas\EventManager\Event))
#17 [internal function]: Omeka\View\Helper\Trigger->__invoke('view.layout')
#18 /Applications/MAMP/htdocs/omeka-s/vendor/laminas/laminas-view/src/Renderer/PhpRenderer.php(396): call_user_func_array(Object(Omeka\View\Helper\Trigger), Array)
#19 /Applications/MAMP/htdocs/omeka-s/application/view/layout/layout-admin.phtml(25): Laminas\View\Renderer\PhpRenderer->__call('trigger', Array)
#20 /Applications/MAMP/htdocs/omeka-s/vendor/laminas/laminas-view/src/Renderer/PhpRenderer.php(505): include('/Applications/M...')
#21 /Applications/MAMP/htdocs/omeka-s/vendor/laminas/laminas-view/src/View.php(206): Laminas\View\Renderer\PhpRenderer->render(NULL)
#22 /Applications/MAMP/htdocs/omeka-s/vendor/laminas/laminas-mvc/src/View/Http/DefaultRenderingStrategy.php(104): Laminas\View\View->render(Object(Laminas\View\Model\ViewModel))
#23 /Applications/MAMP/htdocs/omeka-s/vendor/laminas/laminas-eventmanager/src/EventManager.php(321): Laminas\Mvc\View\Http\DefaultRenderingStrategy->render(Object(Laminas\Mvc\MvcEvent))
#24 /Applications/MAMP/htdocs/omeka-s/vendor/laminas/laminas-eventmanager/src/EventManager.php(170): Laminas\EventManager\EventManager->triggerListeners(Object(Laminas\Mvc\MvcEvent))
#25 /Applications/MAMP/htdocs/omeka-s/vendor/laminas/laminas-mvc/src/Application.php(366): Laminas\EventManager\EventManager->triggerEvent(Object(Laminas\Mvc\MvcEvent))
#26 /Applications/MAMP/htdocs/omeka-s/vendor/laminas/laminas-mvc/src/Application.php(347): Laminas\Mvc\Application->completeRequest(Object(Laminas\Mvc\MvcEvent))
#27 /Applications/MAMP/htdocs/omeka-s/index.php(21): Laminas\Mvc\Application->run()
#28 {main}

Next Doctrine\DBAL\Exception\DriverException: An exception occurred while executing 'SELECT DISTINCT CONCAT(vocabulary.prefix, ":", property.local_name) AS "name", property.label AS "label" FROM property property INNER JOIN vocabulary vocabulary ON property.vocabulary_id = vocabulary.id ORDER BY vocabulary.id ASC, property.local_name ASC':

SQLSTATE[HY000]: General error: 3065 Expression #1 of ORDER BY clause is not in SELECT list, references column 'omeka.vocabulary.id' which is not in SELECT list; this is incompatible with DISTINCT in /Applications/MAMP/htdocs/omeka-s/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/AbstractMySQLDriver.php:128
Stack trace:
#0 /Applications/MAMP/htdocs/omeka-s/vendor/doctrine/dbal/lib/Doctrine/DBAL/DBALException.php(182): Doctrine\DBAL\Driver\AbstractMySQLDriver->convertException('An exception oc...', Object(Doctrine\DBAL\Driver\PDO\Exception))
#1 /Applications/MAMP/htdocs/omeka-s/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 /Applications/MAMP/htdocs/omeka-s/vendor/doctrine/dbal/lib/Doctrine/DBAL/Connection.php(2214): Doctrine\DBAL\DBALException::driverExceptionDuringQuery(Object(Doctrine\DBAL\Driver\PDO\MySQL\Driver), Object(Doctrine\DBAL\Driver\PDO\Exception), 'SELECT DISTINCT...', Array)
#3 /Applications/MAMP/htdocs/omeka-s/vendor/doctrine/dbal/lib/Doctrine/DBAL/Connection.php(1301): Doctrine\DBAL\Connection->handleExceptionDuringQuery(Object(Doctrine\DBAL\Driver\PDO\Exception), 'SELECT DISTINCT...', Array, Array)
#4 /Applications/MAMP/htdocs/omeka-s/modules/AdvancedSearch/src/Adapter/InternalAdapter.php(61): Doctrine\DBAL\Connection->executeQuery(Object(Doctrine\DBAL\Query\QueryBuilder))
#5 /Applications/MAMP/htdocs/omeka-s/modules/AdvancedSearch/src/Form/MainSearchForm.php(903): AdvancedSearch\Adapter\InternalAdapter->getAvailableFields()
#6 /Applications/MAMP/htdocs/omeka-s/modules/AdvancedSearch/src/Form/MainSearchForm.php(113): AdvancedSearch\Form\MainSearchForm->getAvailableFields()
#7 /Applications/MAMP/htdocs/omeka-s/vendor/laminas/laminas-form/src/FormElementManager/FormElementManagerV3Polyfill.php(323): AdvancedSearch\Form\MainSearchForm->init()
#8 /Applications/MAMP/htdocs/omeka-s/vendor/laminas/laminas-servicemanager/src/ServiceManager.php(780): Laminas\Form\FormElementManager\FormElementManagerV3Polyfill->callElementInit(Object(Laminas\ServiceManager\ServiceManager), Object(AdvancedSearch\Form\MainSearchForm))
#9 /Applications/MAMP/htdocs/omeka-s/vendor/laminas/laminas-servicemanager/src/ServiceManager.php(228): Laminas\ServiceManager\ServiceManager->doCreate('AdvancedSearch\\...', Array)
#10 /Applications/MAMP/htdocs/omeka-s/vendor/laminas/laminas-servicemanager/src/AbstractPluginManager.php(153): Laminas\ServiceManager\ServiceManager->build('AdvancedSearch\\...', Array)
#11 /Applications/MAMP/htdocs/omeka-s/vendor/laminas/laminas-form/src/FormElementManager/FormElementManagerTrait.php(56): Laminas\ServiceManager\AbstractPluginManager->get('AdvancedSearch\\...', Array, true)
#12 /Applications/MAMP/htdocs/omeka-s/modules/AdvancedSearch/src/Api/Representation/SearchConfigRepresentation.php(204): Laminas\Form\FormElementManager\FormElementManagerV3Polyfill->get('AdvancedSearch\\...', Array)
#13 /Applications/MAMP/htdocs/omeka-s/modules/AdvancedSearch/src/Api/Representation/SearchConfigRepresentation.php(137): AdvancedSearch\Api\Representation\SearchConfigRepresentation->formInit()
#14 /Applications/MAMP/htdocs/omeka-s/modules/AdvancedSearch/Module.php(1373): AdvancedSearch\Api\Representation\SearchConfigRepresentation->formAdapter()
#15 /Applications/MAMP/htdocs/omeka-s/vendor/laminas/laminas-eventmanager/src/EventManager.php(321): AdvancedSearch\Module->addHeaders(Object(Laminas\EventManager\Event))
#16 /Applications/MAMP/htdocs/omeka-s/vendor/laminas/laminas-eventmanager/src/EventManager.php(170): Laminas\EventManager\EventManager->triggerListeners(Object(Laminas\EventManager\Event))
#17 /Applications/MAMP/htdocs/omeka-s/application/src/View/Helper/Trigger.php(60): Laminas\EventManager\EventManager->triggerEvent(Object(Laminas\EventManager\Event))
#18 [internal function]: Omeka\View\Helper\Trigger->__invoke('view.layout')
#19 /Applications/MAMP/htdocs/omeka-s/vendor/laminas/laminas-view/src/Renderer/PhpRenderer.php(396): call_user_func_array(Object(Omeka\View\Helper\Trigger), Array)
#20 /Applications/MAMP/htdocs/omeka-s/application/view/layout/layout-admin.phtml(25): Laminas\View\Renderer\PhpRenderer->__call('trigger', Array)
#21 /Applications/MAMP/htdocs/omeka-s/vendor/laminas/laminas-view/src/Renderer/PhpRenderer.php(505): include('/Applications/M...')
#22 /Applications/MAMP/htdocs/omeka-s/vendor/laminas/laminas-view/src/View.php(206): Laminas\View\Renderer\PhpRenderer->render(NULL)
#23 /Applications/MAMP/htdocs/omeka-s/vendor/laminas/laminas-mvc/src/View/Http/DefaultRenderingStrategy.php(104): Laminas\View\View->render(Object(Laminas\View\Model\ViewModel))
#24 /Applications/MAMP/htdocs/omeka-s/vendor/laminas/laminas-eventmanager/src/EventManager.php(321): Laminas\Mvc\View\Http\DefaultRenderingStrategy->render(Object(Laminas\Mvc\MvcEvent))
#25 /Applications/MAMP/htdocs/omeka-s/vendor/laminas/laminas-eventmanager/src/EventManager.php(170): Laminas\EventManager\EventManager->triggerListeners(Object(Laminas\Mvc\MvcEvent))
#26 /Applications/MAMP/htdocs/omeka-s/vendor/laminas/laminas-mvc/src/Application.php(366): Laminas\EventManager\EventManager->triggerEvent(Object(Laminas\Mvc\MvcEvent))
#27 /Applications/MAMP/htdocs/omeka-s/vendor/laminas/laminas-mvc/src/Application.php(347): Laminas\Mvc\Application->completeRequest(Object(Laminas\Mvc\MvcEvent))
#28 /Applications/MAMP/htdocs/omeka-s/index.php(21): Laminas\Mvc\Application->run()
#29 {main} {"userId":1}

I then tested the advice on removing the ONLY_FULL_GROUP_BY in the sql mode through myPhP admin on my MAMP test server and that allows Omeka S to load but am not sure how this will affect the use of the Advanced Search Module.

I am worried about doing the upgrade of the Module on my current system (where 3.3.6.3 is working) after we do the Omeka upgrade to 3.1.1.

Any clarification about the issue how to resolve would be helpful.

My production server settings:

My MAMP server settings:

Thank you

Daniel_KM · November 29, 2021, 12:01pm

Thanks, it’s a regression with the mode “only_full_group_by” of mysql ; it’s fixed in version 3.3.6.8.1.

Daniel_KM · November 29, 2021, 12:34pm

Normally, the module works with default mysql config (with or without the new mode).

sanjinmuftic · November 29, 2021, 12:50pm

Thanks a lot Daniel for being so speedy.

system · August 6, 2022, 12:51pm

This topic was automatically closed 250 days after the last reply. New replies are no longer allowed.