handsome-church-15667
02/28/2022, 10:00 AMmysterious-ambulance-11183
02/28/2022, 4:41 PMdocker/sdk console code:phpstan -vvv
I sometimes have locally the problem that the result cache is being used and stale results are being displayed.
Running the phpstan command in PhpStanRunner.php itself in debug mode --debug
is solving the problem, since no cache is being used there, but that can't be solution.
Did I miss something here using this command?fresh-family-51844
03/01/2022, 2:01 AMbrief-judge-68528
03/01/2022, 2:50 PMunnest
feature in PgSQL was a great way to work with array structures. In MariaDB (or MySQL in general) these operations are not available anymore, CTE are still working but not in the array way.
Any suggestions here how to approach it? Are there maybe any "update guides" on the CTE topic for MariaDB? Thanks in advance!
Stay safe out there ✌️🇺🇦acoustic-businessperson-27970
03/03/2022, 1:23 PMpolite-lunch-97479
03/03/2022, 5:12 PMUncaught TypeError: $.fn.dataTable is undefined
setTableErrorMode data-table.js:41
js init.js:57
Could anybody point me to the package missing, please?careful-leather-48930
03/03/2022, 5:45 PMmysterious-ambulance-11183
03/03/2022, 6:55 PMProductConcreteFormExpanderPluginInterface
that was responsible for adding custom fields to the corresponding Symfony Form, but I could not find anything in the product-merchant-portal-gui.acoustic-businessperson-27970
03/04/2022, 1:31 PMErrorException - ini_set(): session.name cannot be a numeric or empty ''
in /data/srv/yves/www/vendor/symfony/http-foundation/Session/Storage/NativeSessionStorage.php (392)
fast-manchester-61640
03/07/2022, 8:18 AMcalm-furniture-47590
03/07/2022, 8:39 AMxdebug
on B2C demo project.
As I understand, we start the xdebug with ./docker/sdk start -x
command .
However when selecting Image for container in PHPStorm, there are a lots of image, so which one do we select, Any Idea?plain-zoo-22177
03/07/2022, 9:32 AMmysterious-king-59256
03/07/2022, 12:21 PMvendor/spryker/oms/src/Spryker/Zed/Oms/Business/OmsFacadeInterface.php:380
doc it’s written, that it should return null
in case of error, but it always returns at least empty array. In the \Spryker\Zed\Oms\Business\OrderStateMachine\OrderStateMachine::runCommand
I see that it just logs exception and goes further.
Is it a bug, or feature?
Can iI check somehow if there was any error in the OMS?handsome-church-15667
03/07/2022, 2:55 PMbest-sundown-96727
03/08/2022, 7:56 AMcalm-france-15664
03/09/2022, 7:32 AM'locales' => [
// first entry is default
'si' => 'sl_SI',
'en' => 'en_US',
],
acceptable-sundown-99280
03/09/2022, 5:12 PMpolite-lunch-97479
03/10/2022, 11:16 AMspryker-shop/navigation-widget
to spryker-shop/content-navigation-widget
but now the navigation lookup in Redis is expecting the navigation to be in namespace content
. Our navigation still is in namespace navigation
, though. Already republished everything, but the namespace doesn't change in Redis. Does anybody know, why the namespace changed and how to fix the navigation lookup?flaky-afternoon-98068
03/10/2022, 11:25 AMquaint-midnight-78937
03/10/2022, 2:46 PM<http://yves.de|yves.de>.spryker.local
the the hosts file but he is not able to open the website in a browser. He always gets a 403 Unauthorized Access
error (even when trying to access the page with Postman)
Any suggestion why this is happening? Might this be related to Docker?mysterious-refrigerator-76811
03/10/2022, 2:50 PMcalm-france-15664
03/11/2022, 8:35 AMbreezy-area-19002
03/11/2022, 9:41 AMrough-scientist-68683
03/15/2022, 7:43 AMPHP Fatal error: Uncaught Twig\Error\LoaderError: Template "service/elastic/7.10.2/elastic.yml.twig" is not defined in "docker-compose.yml.twig" at line 146. in /data/vendor/twig/twig/src/Loader/ChainLoader.php:98
Stack trace:
#0 /data/vendor/twig/twig/src/Environment.php(299): Twig\Loader\ChainLoader->getCacheKey('service/elastic...')
#1 /data/vendor/twig/twig/src/Environment.php(381): Twig\Environment->getTemplateClass('service/elastic...')
#2 /data/vendor/twig/twig/src/Template.php(333): Twig\Environment->loadTemplate('service/elastic...', NULL)
#3 /data/vendor/twig/twig/src/Environment.php(418) : eval()'d code(367): Twig\Template->loadTemplate('service/elastic...', 'docker-compose....', 146)
#4 /data/vendor/twig/twig/src/Template.php(405): __TwigTemplate_35c0c1c7f67b01e3ca72d8db6e31f05a1a0853e01a24f098133b05794511207a->doDisplay(Array, Array)
#5 /data/vendor/twig/twig/src/Template.php(378): Twig\Template->displayWithErrorHandling(Array, Array)
#6 /data/vendor/twig/twig/src/Template.php(390): Twig\Template->display(Array)
in /data/vendor/twig/twig/src/Loader/ChainLoader.php on line 98
When I change version 7.10.2 in the deploy.yml file to version 7.10 the same error happens but then it complains about service/elastic/7.1/elastic.yml.twig
is missing.
Does anyone know how I can solve this? And, why is it looking for .../elastic/7.1/...
instead of .../elastic/7.10/...
?adventurous-plumber-71255
03/15/2022, 9:48 AMdocker/sdk up
I get the error:
=> ERROR [internal] load metadata for <http://docker.io/library/spryker_b2c_dev_base_app:dev|docker.io/library/spryker_b2c_dev_base_app:dev> 1.2s
------
> [internal] load metadata for <http://docker.io/library/spryker_b2c_dev_base_app:dev|docker.io/library/spryker_b2c_dev_base_app:dev>:
------
failed to solve with frontend dockerfile.v0: failed to solve with frontend gateway.v0: rpc error: code = Unknown desc = pull access denied, repository does not exist or may require authorization: server message: insufficient_scope: authorization failed
any help would be cool, thanks!brief-judge-68528
03/15/2022, 11:55 AMCategoryNodeWritePublishPlugin
). This publisher collects data and runs into the repository of the Category module (CategoryRepository
). The invoked query with multiple joins took on our old Postgres database about 1.5s to collect all joined records. After moving to MariaDB this query takes from 65 to 95 seconds. As this is invoked for each node that is getting published our queue for all 5k nodes is just not being processed.
Question now:
1. is anyone aware of this topic?
a. If yes, how did you solve it in the past?
b. If no, any ideas how to approach this?
2. any ideas on how to optimize it from the infrastructure, as the query is build in the core?
We already tried to optimize the query slightly and also added combined indexes, which either had no impact or reduced the collected data.
Looking forward to any suggestion or insight 🙂best-sundown-96727
03/17/2022, 9:24 AMmysterious-ambulance-11183
03/17/2022, 10:23 AMPropel\Runtime\ActiveQuery\QueryExecutor\QueryExecutionException: 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] in file /data/vendor/propel/propel/src/Propel/Runtime/ActiveQuery/QueryExecutor/AbstractQueryExecutor.php on line 136
Caused by
PDOException: SQLSTATE[42000]: Syntax error or access violation: 1064 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 'FROM `spy_cms_slot` INNER JOIN spy_cms_slot_to_cms_slot_template ON (`spy_cms...' at line 1 in file /data/vendor/propel/propel/src/Propel/Runtime/Connection/StatementWrapper.php on line 215
Stack trace:
1. Propel\Runtime\ActiveQuery\QueryExecutor\QueryExecutionException->() /data/vendor/propel/propel/src/Propel/Runtime/ActiveQuery/QueryExecutor/AbstractQueryExecutor.php:136
2. Propel\Runtime\ActiveQuery\QueryExecutor\AbstractQueryExecutor->handleStatementException() /data/vendor/propel/propel/src/Propel/Runtime/ActiveQuery/QueryExecutor/AbstractQueryExecutor.php:105
3. PDOException->() /data/vendor/propel/propel/src/Propel/Runtime/Connection/StatementWrapper.php:215
4. PDOStatement->execute() /data/vendor/propel/propel/src/Propel/Runtime/Connection/StatementWrapper.php:215
5. Propel\Runtime\Connection\StatementWrapper->execute() /data/vendor/propel/propel/src/Propel/Runtime/ActiveQuery/QueryExecutor/AbstractQueryExecutor.php:103
6. Propel\Runtime\ActiveQuery\QueryExecutor\AbstractQueryExecutor->executeStatement() /data/vendor/propel/propel/src/Propel/Runtime/ActiveQuery/QueryExecutor/SelectQueryExecutor.php:49
7. Propel\Runtime\ActiveQuery\QueryExecutor\SelectQueryExecutor->runSelect() /data/vendor/propel/propel/src/Propel/Runtime/ActiveQuery/QueryExecutor/SelectQueryExecutor.php:37
8. Propel\Runtime\ActiveQuery\QueryExecutor\SelectQueryExecutor->execute() /data/vendor/propel/propel/src/Propel/Runtime/ActiveQuery/Criteria.php:2322
9. Propel\Runtime\ActiveQuery\Criteria->doSelect() /data/vendor/propel/propel/src/Propel/Runtime/ActiveQuery/ModelCriteria.php:2211
10. Propel\Runtime\ActiveQuery\ModelCriteria->doSelect() /data/vendor/propel/propel/src/Propel/Runtime/ActiveQuery/ModelCriteria.php:1243
11. Propel\Runtime\ActiveQuery\ModelCriteria->find() /data/vendor/spryker/gui/src/Spryker/Zed/Gui/Communication/Table/AbstractTable.php:964
12. Spryker\Zed\Gui\Communication\Table\AbstractTable->runQuery() /data/vendor/spryker/cms-slot-gui/src/Spryker/Zed/CmsSlotGui/Communication/Table/SlotTable.php:199
13. Spryker\Zed\CmsSlotGui\Communication\Table\SlotTable->prepareData() /data/vendor/spryker/gui/src/Spryker/Zed/Gui/Communication/Table/AbstractTable.php:1026
14. Spryker\Zed\Gui\Communication\Table\AbstractTable->fetchData() /data/vendor/spryker/cms-slot-gui/src/Spryker/Zed/CmsSlotGui/Communication/Controller/SlotListController.php:31
15. Spryker\Zed\CmsSlotGui\Communication\Controller\SlotListController->tableAction() /data/vendor/symfony/http-kernel/HttpKernel.php:156
16. Symfony\Component\HttpKernel\HttpKernel->handleRaw() /data/vendor/symfony/http-kernel/HttpKernel.php:78
17. Symfony\Component\HttpKernel\HttpKernel->handle() /data/vendor/spryker/application/src/Spryker/Shared/Application/Application.php:132
18. Spryker\Shared\Application\Application->handle() /data/vendor/spryker/application/src/Spryker/Shared/Application/Application.php:110
19. Spryker\Shared\Application\Application->run() /data/public/Backoffice/index.php:22
brainy-article-8040
03/17/2022, 2:14 PMagreeable-forest-25716
03/18/2022, 10:03 AM{% set actionConfig = '{
"type": "refresh-drawer",
"component": "ajax-form",
"options": {
"inputs": {
"action": "/product-merchant-portal-gui/update-product-concrete?product-id=' ~ productConcrete.idProductConcrete ~ '"
}
}
}' %}
<web-spy-button-action
type="button"
variant="primary"
size="md"
action="{{ actionConfig }}"
>
<web-spy-icon name="plus" icon></web-spy-icon>
{{ 'Refresh' | trans }}
</web-spy-button-action>
`
This works, but main goal is how to do this on success from response without the additional button?