Hello, does somebody successfully adapt the concept of retry/error message queueing from spryker to their own queue message processing plugins? Seems that the code that is managing the retry/error stuff is deeply buried in the event module. I fear, this will be a copycat duplicating the most of the logic here when using it for own modules. I also noticed that there is a new

count

header for rabbitmq 3.8+ which will support counting the retries ootb by the death letter mechanism of rabbitmq … unfortunately, spryker rabbitmq is 3.7 … any plans to update? Any other approaches that worked for you? Best

Hello everyone, I tried to implement publish and synchronize as described in the Developer Foundations Workshop but I am getting an SQL error in zed exception logs after updating / creating an entity and the search table is always empty. Here is the error message:

[logs] [DE/ZED/exception.log] - [2021-06-10T13:23:28.194172+00:00] Zed.CRITICAL: Propel\Runtime\Exception\PropelException - 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 'key, created_at, updated_at) VALUES (NULL, 1, '{\"id_counter\":1,\"name\":\"m...' at line 1
[logs] [DE/ZED/exception.log] - Executed query: 
[logs] [DE/ZED/exception.log] - INSERT INTO pyz_counter_search (id_counter_search, fk_counter, data, key, created_at, updated_at) VALUES (:p0, :p1, :p2, :p3, :p4, :p5) in "/data/src/Orm/Zed/CounterSearch/Persistence/Base/PyzCounterSearch.php::933"

So I added a Search Module to zed with a search writer, business factory, facade, listener, event subscriber and registered those in the

EventDependencyProvider
RabbitMqConfig
QueueDependencyProvider

On data import I am calling:

$this->addPublishEvents(CounterEvents::ENTITY_PYZ_COUNTER_CREATE, $counterEntity->getIdCounter());

Am I missing something?

Hi, does Spryker have any kind of functionality/module that would be responsible for generating sitemaps? Couldn't find anything so far 🤔

We have several

*.schema.xml

files with columns like this:

<column name="soft_deleted_at" type="TIMESTAMP" default="NULL" required="false"/>

But the generated Transfer only accepts

string|null

as a parameter:

* @param string|null $softDeletedAt
     *
     * @return $this
     */
    public function setSoftDeletedAt($softDeletedAt)

We would like to add

\DateTimeInterface

to the possible types, too, since this is possible, but the docblock is wrong. Is there already a way how to solve this?

Hello All, I added a new store TS into stores.php as below and also added the corresponding config_default file but the newly added store is not showing up in the backoffice stores page, please advise.

$stores['TS'] = [
        'storesWithSharedPersistence' => ['US'],
    ] + $stores['US'];

Hello fellow colleagues, has anyone used quorum queues (https://www.rabbitmq.com/quorum-queues.html) and does anyone know if it’s supported in the spryker/rabbit-mq implementation? With thanks

Hello Everyone, i am trying to update(ALTER) my existing table i have made the changes into the XML schema but when i try to hit the console propel:install command getting this issue. Any suggestions ?

Hi everyone, any ideas how it could be that I'm getting "category with key xxx could not be found" errors during a category import even though said category is in the db, and exactly with that xxx key? Even in the import file (of course) category with key xxx comes first, and only afterwards follow any subcategories that refer xxx as their parent.

Hello I'm looking at the docs here https://documentation.spryker.com/docs/state-machine-cookbook#states For a given state in a state machine the reserved attribute is used

<state name="new" reserved="true"/>

Does anyone know what does this attribute do? Many thanks

Hello I have another question regarding transitions this time. Excerpt from https://documentation.spryker.com/docs/state-machine-cookbook#transitions "The event element can be omitted. This way an external call like 

saveOrder

 or 

triggerEvent

 is finished. That means that the control flow of the code goes back to the invoking method." It's not clear to me what does this actually mean. If I have a transition without an event, will that transition be executed automatically? Also what would be the use case of a transition without an event?

Is there a way to append to an existing file using the filesystem service?

Hi All, does anyone done the setup in Ubuntu 20.14 without Docker and Virtual box? I will be facing some issues in the setup. No jobs imported in Jenkins and the storefront has the resource bundle keys displayed. Thanks in advance.

Is there a cli command to generate unit test classes? I'm doing the developer bootcamp and in the TDD chapter at a certain point it says to add the unit test class. From the docblock I would say some sort of cli command was used to generate it. Does anyone know which one is it?

Hello everyone i have this issue any solution PS: im trying to install spryker with vagrant in windows 10 thank u .

hi Fati, can you rerun the command and check the result again. if the exception is triggered again, you should "grep" for that

3600

over the local project in order to increase that time out.

Short question: I am writing an implementation of the

QueryExpanderPluginInterface

. To properly expand the query, I need some functionality from

Spryker\Client\SearchElasticsearch\Query\QueryBuilder

. My question is: do I copy the functionality (sounds wrong?), or do I expose the

createQueryBuilder

method from the factory via the Facade?

Hello everyone! Is there a way to completely delete created CMS pages or blocks in Spryker? Admin BO supports only "Deactivate" as I know. Is it somewhere supported or do you know an extension to do this? Otherwise I would implement a console command to achieve this. Thanks for your help in advance.

Hi All, I will be facing when logging into the admin panel. This exception keeps popping up.

Hello.. Guys anyone knows how I can add id_product_concrete to product in Product List Page ?

Hey guys, when i run the command propel:install i get an error and after these error i get the information that ""Class 'Generated\Shared\Transfer\SpyAvailabilityAbstractEntityTransfer' not found"? Can somebody help me? It is a complette new installtion withour any customizations.

Hello, is there a smart way to “force” some entity to be flagged as “updated” without overriding the propel entity behaviour at all? For example if we write price data into the storage table, the lastUpdate date is updated in this moment … but if we fetch later the exact price data again, the record is not marked as some updated record since the data is the same, but we actually compare this date to decide when to refresh prices …. so the first idea is to “touch” the record manually even if the record didn’t changed at all … any possibilities? Best

Hi everyone, I want obtain all the list of banners in GLUE. I know exist this in Documentation but i want obtain a list. The only way for me is override "content-banners-rest-api" to get all. Is that correct?

Hello, can anybody tell me, what the field “price_data” in “spy_price_product_store” is intended to be? Seems there must be json inside, i have seen various json encode/decode operations. Best

Hi, is there a standard ruleset for Web Application Firewalls for spryker? a boilerplate to start from? We will be using the service of link11, but we do not mind the format,

hello, I'm getting

Twig\Error\LoaderError - Template "@HelloString/views/index/index.twig" is not defined (Spryker\Shared\Twig\TwigFilesystemLoader: Unable to find template "@HelloString/views/index/index.twig" (cached).).

although i have my index.twig in

src/Pyz/Yves/HelloString/Theme/Default/Index/Index.twig

Hello Everyone, i have import a slot template and some slots using the csv file data is being import successfully into database but template is not coming on the Zed UI. Any suggestion on this ?

hello. does spryker have the translations functionality in javascript?

Hello everyone, I have recently upgraded to the newest Spryker devvm and I am having a problem when running

vendor/bin/instal

it fails on creating the search index The command that is failing is:

Command setup-search for DE store [vendor/bin/console setup:search] (In progress...)

Hello, does anybody know if the order placing from frontend in spryker (via Zed Client) is generally intended to be decoupled from the OMS in backend? So my expectation is that when placing an order after checkout, the order is created in backend as “new” and the yves zed client gets a response. The follow up processing is done by zed via cronjobs etc. At the moment it feels like that any OMS step, that has an onEnter=true flag, is executed as well along the zed request from frontend. This might lead to timeouts if there are expensive follow up OMS steps. Is this behaviour correct or do i miss something here? If yes, how to “decouple” it from the frontend placement so that the user experience a fast checkout? It seems it can be solved using various intermediate states and condition plugins, but honestly it feels a bit overkill just for “decoupling” the first “new” state from the further order processing. Best

Store: DE | Environment: development
Creating Database
RuntimeException - Exception: createdb: error: could not connect to database template1: FATAL:  role "root" does not exist

in /home/sqli/Desktop/work/learning/sprker/b2c-demo-shop/vendor/spryker/propel/src/Spryker/Zed/Propel/Business/Model/PropelDatabase/Adapter/PostgreSql/CreatePostgreSqlDatabase.php (133)

Command: vendor/bin/console propel:install where can i update my database role i tried updating it in deploy.dev.yml but nothing changed