Calling Developers!
We are reenergizing our code contribution process! Learn More

What are the Slack Archives?

It’s a history of our time together in the Slack Community! There’s a ton of knowledge in here, so feel free to search through the archives for a possible answer to your question.

Because this space is not active, you won’t be able to create a new post or comment here. If you have a question or want to start a discussion about something, head over to our categories and pick one to post in! You can always refer back to a post from Slack Archives if needed; just copy the link to use it as a reference..

Hey guys, checked out the current master-branch of the spryker-b2c-demo-shop and tried to get the sl

Options
U02UR8WNS9W
U02UR8WNS9W Posts: 14 🧑🏻‍🚀 - Cadet
edited January 2022 in Help

Hey guys, checked out the current master-branch of the spryker-b2c-demo-shop and tried to get the slot-view of the templates. apparently there is an error in the sql-statement that is trying to select the data. there is a column selection missing in the statement.

Propel\Runtime\ActiveQuery\QueryExecutor\QueryExecutionException thrown with message "Unable to execute statement [SELECT  FROM `spy_cms_slot` INNER JOIN spy_cms_slot_to_cms_slot_template ON (`spy_cms_slot`.`id_cms_slot`=spy_cms_slot_to_cms_slot_template.fk_cms_slot) WHERE spy_cms_slot_to_cms_slot_template.fk_cms_slot_template=:p1 ORDER BY `spy_cms_slot`.`id_cms_slot` ASC LIMIT 10]"

Stacktrace:
#18 Propel\Runtime\ActiveQuery\QueryExecutor\QueryExecutionException in /data/vendor/propel/propel/src/Propel/Runtime/ActiveQuery/QueryExecutor/AbstractQueryExecutor.php:136
#17 Propel\Runtime\ActiveQuery\QueryExecutor\AbstractQueryExecutor:handleStatementException in /data/vendor/propel/propel/src/Propel/Runtime/ActiveQuery/QueryExecutor/AbstractQueryExecutor.php:105
#16 PDOException in /data/vendor/propel/propel/src/Propel/Runtime/Connection/StatementWrapper.php:215
#15 PDOStatement:execute in /data/vendor/propel/propel/src/Propel/Runtime/Connection/StatementWrapper.php:215
#14 Propel\Runtime\Connection\StatementWrapper:execute in /data/vendor/propel/propel/src/Propel/Runtime/ActiveQuery/QueryExecutor/AbstractQueryExecutor.php:103
#13 Propel\Runtime\ActiveQuery\QueryExecutor\AbstractQueryExecutor:executeStatement in /data/vendor/propel/propel/src/Propel/Runtime/ActiveQuery/QueryExecutor/SelectQueryExecutor.php:49
#12 Propel\Runtime\ActiveQuery\QueryExecutor\SelectQueryExecutor:runSelect in /data/vendor/propel/propel/src/Propel/Runtime/ActiveQuery/QueryExecutor/SelectQueryExecutor.php:37
#11 Propel\Runtime\ActiveQuery\QueryExecutor\SelectQueryExecutor:execute in /data/vendor/propel/propel/src/Propel/Runtime/ActiveQuery/Criteria.php:2322
#10 Propel\Runtime\ActiveQuery\Criteria:doSelect in /data/vendor/propel/propel/src/Propel/Runtime/ActiveQuery/ModelCriteria.php:2211
#9 Propel\Runtime\ActiveQuery\ModelCriteria:doSelect in /data/vendor/propel/propel/src/Propel/Runtime/ActiveQuery/ModelCriteria.php:1243
#8 Propel\Runtime\ActiveQuery\ModelCriteria:find in /data/vendor/spryker/gui/src/Spryker/Zed/Gui/Communication/Table/AbstractTable.php:964
#7 Spryker\Zed\Gui\Communication\Table\AbstractTable:runQuery in /data/vendor/spryker/cms-slot-gui/src/Spryker/Zed/CmsSlotGui/Communication/Table/SlotTable.php:200
#6 Spryker\Zed\CmsSlotGui\Communication\Table\SlotTable:prepareData in /data/vendor/spryker/gui/src/Spryker/Zed/Gui/Communication/Table/AbstractTable.php:1026
#5 Spryker\Zed\Gui\Communication\Table\AbstractTable:fetchData in /data/vendor/spryker/cms-slot-gui/src/Spryker/Zed/CmsSlotGui/Communication/Controller/SlotListController.php:31
#4 Spryker\Zed\CmsSlotGui\Communication\Controller\SlotListController:tableAction in /data/vendor/symfony/http-kernel/HttpKernel.php:152
#3 Symfony\Component\HttpKernel\HttpKernel:handleRaw in /data/vendor/symfony/http-kernel/HttpKernel.php:74
#2 Symfony\Component\HttpKernel\HttpKernel:handle in /data/vendor/spryker/application/src/Spryker/Shared/Application/Application.php:132
#1 Spryker\Shared\Application\Application:handle in /data/vendor/spryker/application/src/Spryker/Shared/Application/Application.php:110
#0 Spryker\Shared\Application\Application:run in /data/public/Backoffice/index.php:22

Comments