search

TYPO3-Solr / ext-solr

A TYPO3 extension that integrates the Apache Solr search server with TYPO3 CMS. dkd Internet Service GmbH is developing the extension. Community contributions are welcome. See CONTRIBUTING.md for details.
GNU General Public License v3.0
137 stars 252 forks source link

[BUG] 13.0.0-dev DBAL Error on opening scheduler module #4208

Open linawolf opened 3 weeks ago

linawolf commented 3 weeks ago

Describe the bug On opening the scheduler module I get the following error:

1/3) #1064 Doctrine\DBAL\Exception\SyntaxErrorException
An exception occurred while executing a query: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ') `pidlist` ON (`sys_template`.`pid` = `pidlist`.`uid`) WHERE ((`sys_template...' at line 1

in in /var/www/html/vendor/apache-solr-for-typo3/solr/Classes/System/Configuration/ConfigurationManager.php line 187

Used versions (please complete the following information):

linawolf commented 3 weeks ago

@RafaelKa any news on this?

linawolf commented 3 weeks ago

I think this bug is related to https://forge.typo3.org/issues/105541

pduersteler commented 2 weeks ago

.. and maybe https://github.com/TYPO3-Solr/ext-solr/issues/4203 as well :)

dkd-kaehm commented 2 weeks ago

@linawolf This error is triggered in several places, so it is my absolute favorite, which will be fixed first.

dkd-kaehm commented 2 weeks ago

@linawolf It is fixed in core, can we close this issue?

Please check with current TYPO3 13.4.x-dev state.

If it still reproducible in your setup, please check Site is set properly in task properties. Via SQL or xDebug(Breakpoint f.e. AbstractSolrTask::61 and check property $this->rootPageId.)