Who is this guide for?
If you installed the LoyaltyLion module on Magento v2.4.2 or below and subsequently upgraded your Magento instance to v2.4.3 or above, you may be affected by a breaking change described here:
In v2.4.3, Magento started encrypting the
consumer secret field but the upgrade process may not consistently encrypt any consumer secrets already created. As a result, you might see an error when you try to activate or reauthorize the LoyaltyLion integration: https://developers.loyaltylion.com/docs/install-adobe-commerce-2#provide-api-access
How do I resolve the issue?
The easiest resolution is to fully uninstall the module and delete LoyaltyLion from the integrations table:
SELECT integration_id FROM integration WHERE email = 'firstname.lastname@example.org'
# If integration_id is for e.g. 1, the name in oauth_consumer will be Integration1
SELECT * FROM oauth_consumer WHERE name = ?, IntegrationX
# entity_id from the oauth_consumer table in the previous query
DELETE FROM oauth_token WHERE consumer_id = ?, entity_id
# Delete our oauth_consumer
DELETE FROM oauth_consumer WHERE name = ?, IntegrationX
# Remove the integration itself
DELETE FROM integration WHERE email = 'email@example.com'
# Reinstall the module