Nach MM Installation: Attibute nicht aufrufbar: SQL Syntax Error

**Kyuhunter** · 21.09.2020, 10:36

Hallo Zusammen,

ich habe gerade MM 2.1 auf einer frischen Contao-Installation installiert, und ein Metamodel angelegt. Wenn ich nun versuche auf die Attribute zu gehen bekomme ich den Fehler:

Code:

An exception occurred while executing 'SELECT id FROM tl_metamodel_attribute WHERE (pid = ?) AND () ORDER BY sorting ASC' with params ["1"]: SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ') ORDER BY sorting ASC' at line 1

Was kann ich da machen?

Mit freundlichen Grüßen
Kyuhunter

**zonky** · 21.09.2020, 10:45

gib mal Info zu Version Contao, PHP und DB

**Kyuhunter** · 21.09.2020, 10:47

Contao: 4.4.51
PHP: 7.4
mysql Ver 14.14 Distrib 5.7.31, for Linux (x86_64)

**zonky** · 21.09.2020, 10:48

Inhalt Deiner composer.json ...

**Kyuhunter** · 21.09.2020, 10:49

Code:

{
    "type": "project",
    "require": {
        "contao/calendar-bundle": "4.4.*",
        "contao/comments-bundle": "4.4.*",
        "contao/conflicts": "*@dev",
        "contao/faq-bundle": "4.4.*",
        "contao/listing-bundle": "4.4.*",
        "contao/manager-bundle": "4.4.*",
        "contao/news-bundle": "4.4.*",
        "contao/newsletter-bundle": "4.4.*",
        "metamodels/attribute_alias": "^2.1",
        "metamodels/attribute_checkbox": "^2.1",
        "metamodels/attribute_color": "^2.1",
        "metamodels/attribute_combinedvalues": "^2.1",
        "metamodels/attribute_country": "^2.1",
        "metamodels/attribute_decimal": "^2.1",
        "metamodels/attribute_file": "^2.1",
        "metamodels/attribute_geodistance": "^2.1",
        "metamodels/attribute_langcode": "^2.1",
        "metamodels/attribute_levensthein": "^2.1",
        "metamodels/attribute_longtext": "^2.1",
        "metamodels/attribute_numeric": "^2.1",
        "metamodels/attribute_rating": "^2.1",
        "metamodels/attribute_select": "^2.1",
        "metamodels/attribute_tablemulti": "^2.1",
        "metamodels/attribute_tabletext": "^2.1",
        "metamodels/attribute_tags": "^2.1",
        "metamodels/attribute_text": "^2.1",
        "metamodels/attribute_timestamp": "^2.1",
        "metamodels/attribute_translatedalias": "^2.1",
        "metamodels/attribute_translatedcheckbox": "^2.1",
        "metamodels/attribute_translatedcombinedvalues": "^2.1",
        "metamodels/attribute_translatedfile": "^2.1",
        "metamodels/attribute_translatedlongtext": "^2.1",
        "metamodels/attribute_translatedselect": "^2.1",
        "metamodels/attribute_translatedtablemulti": "^2.1",
        "metamodels/attribute_translatedtabletext": "^2.1",
        "metamodels/attribute_translatedtags": "^2.1",
        "metamodels/attribute_translatedtext": "^2.1",
        "metamodels/attribute_translatedurl": "^2.1",
        "metamodels/attribute_url": "^2.1",
        "metamodels/contao-frontend-editing": "^2.1",
        "metamodels/core": "^2.1",
        "metamodels/filter_checkbox": "^2.1",
        "metamodels/filter_fromto": "^2.1",
        "metamodels/filter_perimetersearch": "^2.1",
        "metamodels/filter_range": "^2.1",
        "metamodels/filter_register": "^2.1",
        "metamodels/filter_select": "^2.1",
        "metamodels/filter_tags": "^2.1",
        "metamodels/filter_text": "^2.1",
        "premium-contao-themes/pct_theme_installer": "^1.4",
        "terminal42/contao-leads": "^1.4",
        "terminal42/notification_center": "^1.5"
    },
    "extra": {
        "contao-component-dir": "assets"
    },
    "scripts": {
        "post-install-cmd": [
            "Contao\\ManagerBundle\\Composer\\ScriptHandler::initializeApplication"
        ],
        "post-update-cmd": [
            "Contao\\ManagerBundle\\Composer\\ScriptHandler::initializeApplication"
        ]
    }
}

**zonky** · 21.09.2020, 10:54

Holla die Waldfee - Du brauchst alle MM-Pakete?

das Install-Tool hattest Du aufgerufen? domain.tld/contao/install

Aktiviere mal den app_dev-Modus und poste mal was im Stack-Trace steht
(siehe https://metamodels.readthedocs.io/de...ymfony-toolbar)

**Kyuhunter** · 21.09.2020, 10:59

Ich bin mir noch nicht ganz sicher welche pakete ich benötigen werde... also erstmal alle installiert. Kann im Zuge des debuggen das ganze auch eben auf das reduzieren von ich weiß, dass ich es brauche.

Ja, install-tool ist aufgerufen worden.

Stack-Trace:

Code:

Doctrine\DBAL\Exception\SyntaxErrorException:
An exception occurred while executing 'SELECT id FROM tl_metamodel_attribute WHERE (pid = ?) AND () ORDER BY sorting ASC' with params ["1"]:

SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ') ORDER BY sorting ASC' at line 1

  at vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/AbstractMySQLDriver.php:98
  at Doctrine\DBAL\Driver\AbstractMySQLDriver->convertException()
     (vendor/doctrine/dbal/lib/Doctrine/DBAL/DBALException.php:182)
  at Doctrine\DBAL\DBALException::wrapException()
     (vendor/doctrine/dbal/lib/Doctrine/DBAL/DBALException.php:159)
  at Doctrine\DBAL\DBALException::driverExceptionDuringQuery()
     (vendor/doctrine/dbal/lib/Doctrine/DBAL/Connection.php:2021)
  at Doctrine\DBAL\Connection->handleExceptionDuringQuery()
     (vendor/doctrine/dbal/lib/Doctrine/DBAL/Connection.php:1163)
  at Doctrine\DBAL\Connection->executeQuery()
     (vendor/doctrine/dbal/lib/Doctrine/DBAL/Query/QueryBuilder.php:204)
  at Doctrine\DBAL\Query\QueryBuilder->execute()
     (vendor/contao-community-alliance/dc-general/src/Data/DefaultDataProvider.php:381)
  at ContaoCommunityAlliance\DcGeneral\Data\DefaultDataProvider->fetchAll()
     (vendor/contao-community-alliance/dc-general/src/Panel/DefaultLimitElement.php:87)
  at ContaoCommunityAlliance\DcGeneral\Panel\DefaultLimitElement->calculateTotal()
     (vendor/contao-community-alliance/dc-general/src/Panel/DefaultLimitElement.php:161)
  at ContaoCommunityAlliance\DcGeneral\Panel\DefaultLimitElement->initialize()
     (vendor/contao-community-alliance/dc-general/src/Panel/DefaultPanel.php:97)
  at ContaoCommunityAlliance\DcGeneral\Panel\DefaultPanel->initialize()
     (vendor/contao-community-alliance/dc-general/src/Panel/DefaultPanelContainer.php:89)
  at ContaoCommunityAlliance\DcGeneral\Panel\DefaultPanelContainer->initialize()
     (vendor/contao-community-alliance/dc-general/src/Contao/View/Contao2BackendView/ViewHelpers.php:131)
  at ContaoCommunityAlliance\DcGeneral\Contao\View\Contao2BackendView\ViewHelpers::initializeSorting()
     (vendor/contao-community-alliance/dc-general/src/Contao/Event/Subscriber.php:318)
  at ContaoCommunityAlliance\DcGeneral\Contao\Event\Subscriber->initializePanels()
     (vendor/symfony/symfony/src/Symfony/Component/EventDispatcher/Debug/WrappedListener.php:115)
  at Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke()
     (vendor/symfony/symfony/src/Symfony/Component/EventDispatcher/EventDispatcher.php:214)
  at Symfony\Component\EventDispatcher\EventDispatcher->doDispatch()
     (vendor/symfony/symfony/src/Symfony/Component/EventDispatcher/EventDispatcher.php:44)
  at Symfony\Component\EventDispatcher\EventDispatcher->dispatch()
     (vendor/symfony/symfony/src/Symfony/Component/EventDispatcher/Debug/TraceableEventDispatcher.php:143)
  at Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch()
     (vendor/contao-community-alliance/dc-general/src/Controller/DefaultController.php:158)
  at ContaoCommunityAlliance\DcGeneral\Controller\DefaultController->handle()
     (vendor/metamodels/core/src/BackendIntegration/Module.php:74)
  at MetaModels\BackendIntegration\Module->generate()
     (vendor/contao/core-bundle/src/Resources/contao/classes/Backend.php:424)
  at Contao\Backend->getBackendModule()
     (vendor/contao/core-bundle/src/Resources/contao/controllers/BackendMain.php:131)
  at Contao\BackendMain->run()
     (vendor/contao/core-bundle/src/Controller/BackendController.php:55)
  at Contao\CoreBundle\Controller\BackendController->mainAction()
     (vendor/symfony/symfony/src/Symfony/Component/HttpKernel/HttpKernel.php:151)
  at Symfony\Component\HttpKernel\HttpKernel->handleRaw()
     (vendor/symfony/symfony/src/Symfony/Component/HttpKernel/HttpKernel.php:68)
  at Symfony\Component\HttpKernel\HttpKernel->handle()
     (vendor/symfony/symfony/src/Symfony/Component/HttpKernel/Kernel.php:200)
  at Symfony\Component\HttpKernel\Kernel->handle()
     (web/app_dev.php:73)

**Kyuhunter** · 21.09.2020, 11:03

Und hier nochmal die composer.json mit den MM-Packages die ich brauche:

Code:

{
    "type": "project",
    "require": {
        "contao/calendar-bundle": "4.4.*",
        "contao/comments-bundle": "4.4.*",
        "contao/conflicts": "*@dev",
        "contao/faq-bundle": "4.4.*",
        "contao/listing-bundle": "4.4.*",
        "contao/manager-bundle": "4.4.*",
        "contao/news-bundle": "4.4.*",
        "contao/newsletter-bundle": "4.4.*",
        "metamodels/attribute_alias": "^2.1",
        "metamodels/attribute_checkbox": "^2.1",
        "metamodels/attribute_decimal": "^2.1",
        "metamodels/attribute_file": "^2.1",
        "metamodels/attribute_longtext": "^2.1",
        "metamodels/attribute_numeric": "^2.1",
        "metamodels/attribute_select": "^2.1",
        "metamodels/attribute_tabletext": "^2.1",
        "metamodels/attribute_tags": "^2.1",
        "metamodels/attribute_text": "^2.1",
        "metamodels/attribute_timestamp": "^2.1",
        "metamodels/attribute_url": "^2.1",
        "metamodels/core": "^2.1",
        "metamodels/filter_checkbox": "^2.1",
        "metamodels/filter_fromto": "^2.1",
        "metamodels/filter_perimetersearch": "^2.1",
        "metamodels/filter_range": "^2.1",
        "metamodels/filter_register": "^2.1",
        "metamodels/filter_select": "^2.1",
        "metamodels/filter_tags": "^2.1",
        "metamodels/filter_text": "^2.1",
        "premium-contao-themes/pct_theme_installer": "^1.4",
        "terminal42/contao-leads": "^1.4",
        "terminal42/notification_center": "^1.5"
    },
    "extra": {
        "contao-component-dir": "assets"
    },
    "scripts": {
        "post-install-cmd": [
            "Contao\\ManagerBundle\\Composer\\ScriptHandler::initializeApplication"
        ],
        "post-update-cmd": [
            "Contao\\ManagerBundle\\Composer\\ScriptHandler::initializeApplication"
        ]
    }
}

Fehler tritt immernoch auf.

**zonky** · 21.09.2020, 12:58

kann ich bei mir leider nicht nachvollziehen

füge mal vor Zeile 368
https://github.com/contao-community-...vider.php#L368

PHP-Code:


dump($config);

ein und poste den Inhalt des Dumps

**Kyuhunter** · 21.09.2020, 13:10

Habe ich gemacht:

Code:

    
...
public function fetchAll(ConfigInterface $config)
    {
    	dump($config);
        $queryBuilder = $this->connection->createQueryBuilder();
        $queryBuilder->from($this->source);
        DefaultDataProviderDBalUtils::addField($config, $this->idProperty, $queryBuilder);
        DefaultDataProviderDBalUtils::addWhere($config, $queryBuilder);
        DefaultDataProviderDBalUtils::addSorting($config, $queryBuilder);
...

Sobald ich jetzt im Backend auf Metamodels gehe bekomme ich den Fehler:

Code:

Attempted to call function "dump" from namespace "ContaoCommunityAlliance\DcGeneral\Data".

**Kyuhunter** · 21.09.2020, 13:13

Wenn ich das ganze über app_dev.php aufrufe bekomme ich unten angezeigt:

DefaultDataProvider.php line 368:

Code:

DefaultConfig {#1648 ?
  #mixId: null
  #arrIds: []
  #blnIdOnly: true
  #intStart: null
  #intAmount: null
  #arrFilter: null
  #arrSorting: array:1 [?
    "sorting" => "asc"
  ]
  #arrFields: null
  #arrData: []
}

**zonky** · 21.09.2020, 13:13

app_dev ist an?

**zonky** · 21.09.2020, 13:19

sieht alles etwas merkwürdig aus - müssen uns das mal zusammen ansehen per AnyDesk

ping mich mal per PM an

**Kyuhunter** · 21.09.2020, 13:19

Ja, in meinem letzten Beitrag der Output davon.

**zonky** · 21.09.2020, 14:39

konnte das (bisher) nicht nachvollziehen - downgrade von MM core und DCG gab keine Änderung

Temp. Fix eingebaut

PHP-Code:


CCA DefaultDataProviderDBalUtils.php:

    private static function filterAndOr($operation, QueryBuilder $queryBuilder)

    {

        $children = $operation['children'];



        if (empty($children)) {

            return;

        }



        $whereOperation = strtolower($operation['operation']) . 'Where';



        foreach ($children as $child) {

            if ('' !== $child = static::calculateSubFilter($child, $queryBuilder)) {

                $queryBuilder->{$whereOperation}($child);

            }

        }

    }

Dank an Xtra