AttributeSlugRepository cannot save non existing slug

[gerrits-ecommerce]

In version v8.8.0 of the tweakwise/magento2-tweakwise module. The following happens.

When visiting a categorie with filters i get the following exception:

[2025-12-23T12:42:23.116453+00:00] main.CRITICAL: Magento\Framework\Exception\CouldNotSaveException: Die Seite konnte nicht gespeichert werden: Verletzung einer "Unique" Einschränkung gefunden in /data/web/apps/deploy.mysteel.hypernode.io/releases/12/vendor/tweakwise/magento2-tweakwise/Model/AttributeSlugRepository.php:107

It looks like the Save() function is trying to save an already existing slug to the tweakwise_attribute_slug table. When i dump: $attributeSlug->getSlug(); i get pulverbeschichtetem-stahl-1.

But when i than look in the table this slug does not exist:

The result of this is that on this category page no filters are loaded. To temporarily fix this is disabled the CouldNotSaveException thrown on line 107 of vendor/tweakwise/magento2-tweakwise/Model/AttributeSlugRepository.php

[ahuininga-orisha]

@gerrits-ecommerce Nevermind. I think may earlier comment may be wrong. There should not be two slug values for the same attribute. So this is not the problem. This is the original problem again. Only it should not be an problem anymore because there should not be two ways to write the attribute.

I think this may be triggered if the attribute is changed in tweakwise itself. I look into it.

[ahuininga-orisha]

@gerrits-ecommerce The value doesn't seem to be changed by tweakwise.

Can you check the value of $attributeSlug->getAttribute()? I want to know why the check on line 85 fails. vendor/tweakwise/magento2-tweakwise/Model/AttributeSlugRepository.php

if ($existingSlug->getAttribute() === $attributeSlug->getAttribute()) {

Based on my data, it should not fail. I think it may be an capital letter problem. The code should not reach the save function in the first place. I found the error in the cache lookup table that may indicate it may be an problem with capital letters. I'll make an fix for that. But to be sure, can you confirm the check on line 85 fails because of this?

[ahuininga-orisha]

@gerrits-ecommerce I think i found the cause. It is not the spelling. But you have two attributes both with the exact same option. material_type and import materiaal. And one of them seems to have an space after the value. The space in combination with the duplicate value causes the error. I'll see if i can find an solution for this.

In the mean time. If you remove the space after Pulverbeschichtetem Stahl for option_id 6446, it should solve the issue.