Alex
  • Member for 9 years
  • Last seen this week
Unique constraint violation found when editing category Name / URL key in 2.4.3 / having url_path
Accepted answer
0 votes

This query helped here, after the upgrade: https://github.com/magento/magento2/issues/33770#issuecomment-991065898 START TRANSACTION; CREATE TABLE catalog_url_rewrite_product_category_temp SELECT ...

View answer
Duplicate entry in DB after upgrading to 2.4.3
0 votes

It's a bug in Magento 2.4.3 upgrade procedure, see GitHub for details: https://github.com/magento/magento2/issues/33770 You can apply on of the workaround posted here.

View answer
Failed to retrieve Adobe Stock search files results when opening media gallery in the Admin Panel
1 votes

In the end of the day it was another problem. The Amasty PageSpeed Optimizer module created 11 Mio files in /media which the Gallery tried to load. I think the module somehow excludes that folder ...

View answer
Merge different language csv to determine which phrases missing a translation
1 votes

You could use csvkit to diff the first columns of the CSVs In this example we compare de_DE with the theme we have to see what is not translated yet # download existing language pack to de_DE.csv ...

View answer
Why does it matter in which order I add attributes to a filter?
1 votes

The resulting queries differ: SELECT `e`.*, IF(at_customer_group.value_id > 0, at_customer_group.value, at_customer_group_default.value) AS `customer_group` FROM `catalog_product_entity` AS `...

View answer
How to fix "ThreeDomainSecure is not a function" during PayPal Credit Card Payment?
0 votes

PayPal changed something, not it works - seems like a problem on their side.

View answer
Avoid getting old data from customerRegistry in queue runner
0 votes

Calling remove on the registry seems to work, but I am wondering if there is a nicer solution, because eventually any nested addresses might still be cached. /** @var \Magento\Customer\Model\...

View answer
how to debug large object in Magento 2 without var_dump?
0 votes

Most objects have a ->debug() method, which displays less data than ->getData() This comes in quite handy, when working with n98-magerun2 dev:console $cm = $di->get(Magento\Customer\Model\...

View answer
What are good debugging strategies for MFTF (v2) tests which only faily sometimes?
2 votes

First idea: Put a <wait stepKey="almostForever" time="65535"> at the part where the test fails and try to reproduce the problem manually from there on Interactive pause: ...

View answer
Getting "The configuration file has changed. Run the "app:config:import" ...." during integration tests, after most of them ran already
1 votes

The problem was in incomplete bootstrapping of the integration tests (aborted with errors), on the second run the bootstrapping worked, but only because it already was half installed - but the config ...

View answer
Cart rule free shipping on subtotal after discount magento 2
0 votes

Actually the option Subtotal (excl. Tax) seems to be with discount, when having a look at the dropdown I see this: <option value="Magento\SalesRule\Model\Rule\Condition\Address|...

View answer
How to display Sale label on configurable product
0 votes

Our solution for a customer was, to create a new attribute is_on_sale which is updated each time a configurable or it's simples are changed. Then we simply use that attribute to display a sale label ...

View answer
How to get cache images path
Accepted answer
1 votes

You can hard code the hash as it depends only on the image target format and mostly does not change.

View answer
File show placeholder image, even existing
1 votes

The media/catalog/product/cache/18076855f65e9b9019a33b25468c9e1d/filename.png URLs are fetched by the pub/get.php You can start debugging from there. Interesting point is \Magento\MediaStorage\App\...

View answer
Magento 2 delete specific product categories
Accepted answer
1 votes

You can do it with n98-magerun2 if this is a one-shot task: If you want to delete categories with IDs 1, 2, 3, 4 $di->configure($di->get(\Magento\Framework\ObjectManager\ConfigLoaderInterface::...

View answer
Magento 2: How to lock/unlock customers
4 votes

Same like Jen's answer but via SQL: n98-magerun2 db:console update customer_entity set failures_num = 10, lock_expires = "2038-01-01 00:00:00" where entity_id = TYPE_CUSTOMER_ID_HERE ; ...

View answer
Deactivate a list of SKUs for a two specific websites?
0 votes

I came up with this # find out the store Ids for example with n98-magerun2 sys:store:list, in my case 9 + 10 select attribute_id from eav_attribute where attribute_code like "status" and ...

View answer
What is the difference between getStoredData and getData?
0 votes

The difference between getData and getStoredData is at least, that getData gives you the current version of the model, and getStored is supposed to give the version which is currently in the database. ...

View answer
User Error: Some transactions have not been committed or rolled back during integration tests, only on CI
Accepted answer
3 votes

TL;DR Magento integration tests do not seem to be prepared for the case that a secure base URL is set in the integration testing database. In this case they run into an exit statement when trying to ...

View answer
How to Debug UI Component only showing spinner
1 votes

One approach is to dig into component initialization (via https://twitter.com/vova_yatsyuk/status/1250807165914357762) There actually is logging with console-logger in place, but it is disabled by ...

View answer
index backlog grows without reason?
0 votes

We had a cron job that ran much longer than expected and was contiously updating products. That explains it.

View answer
getIdentities spends a lot of time
0 votes

Turns out that the problem is caused by $productBlockObj= $block->getLayout()->createBlock('Example\ProductListings\Block\Product\ListProduct') in a custom items.phtml This seems to cause ...

View answer
Anonymizing Magento 2.3 DB with fake data
0 votes

You can try GDPR dump but it needs some configuration... Would be nice if you share your config if you succeed. https://github.com/machbarmacher/gdpr-dump

View answer
Full Page Cache not Working, no X-Magento-Cache-Debug header present
0 votes

Make sure, your Full Page cache is switched to "Built in cache", not varnish For exmaple check the config value system/full_page_cache/caching_application and set it to "1" (2 would mean Varnish) -> ...

View answer
Is the session table supposed to be cleaned up automatically?
0 votes

We believe this is a core issue: https://github.com/magento/magento2/issues/26308

View answer
Where is the original price set in sales order item table?
0 votes

In our case we were overwriting the originalprice in an observer, which did not come through to the order item. Setting a breakpoint in \Magento\Sales\Model\Order\Item::setOriginalPrice you find that ...

View answer
How do I create a link to a product using just the ID or SKU?
0 votes

This FOSS Module might help. It overwrites the router and redirects exact SKU matches to the product https://github.com/karliuka/m2.ProductSkuRedirect So you would have link like example.com/1337 ...

View answer
Which server settings can cause Magento reindex to run really slow?
5 votes

And another Answer --- thanks to the Chat with Wilson Hauck: He pointed out, that the quotes might confuse the new optimized in 10.3 I took the full query.sql from above and extracted only the ...

View answer
Which server settings can cause Magento reindex to run really slow?
1 votes

Partial answer - better debugging welcome. Turns out that the issue is reproducible with MariaDB 10.3.18 locally as well. According to DevDocs "Magento is also compatible with MySQL NDB Cluster 7.4.*...

View answer
Magento 2: SQL get orders with specific option id
0 votes

The product options are saved as JSON. With the MySQL version required by Magento 2, there seems to be no nice solution for this: You can filter using LIKE "%2010%" or some more sophisticated ...

View answer
1
2 3 4 5
7