Question regarding URL's
The main question is where does Spryker save his URL's?
I know the spy_url and spy_redirect_url and the two related storage tables. But are there more?
The issue is that I have (product) URLs which I can browse to, but that I cant find in the url or redirect table. I would say, that if it doesnt exist there then that URL should not be working.
Or does it work differently? That a created URL somehow always will be working until it gets redirected? Is there a table where I can see all these URLs?
Answers
-
Normally, all the product URLs should be existing in spy_url.
But, to resolve the route, Spryker doesn't make a database lookup because of performance reasons but instead uses Redis.
You might want to check Redis if the URL is existing in there.
If it is, there probably is a synchronization issue between your database and Redis.I remember a Spryker bug years ago that in case you created redirect URLs in the Backoffice the wrong Redis entry was invalidated, leading to inconsistencies. I don't know if this has been fixed.
In that case a quickfix would be to clear all the URL entries from Redis and start the syncing again.
As a long term fix you have to find out what is causing the synchronization issues.If you system contains a lot of products it might be handy to replace Spryker's existing URL resolving logic for product URLs and instead rely on URLs that have the product SKU included - so a Redis and Database mapping between a product and an URL is not necessary anymore.
2
Categories
- All Categories
- 42 Getting Started & Guidelines
- 7 Getting Started in the Community
- 8 Additional Resources
- 7 Community Ideas and Feedback
- 76 Spryker News
- 930 Developer Corner
- 788 Spryker Development
- 89 Spryker Dev Environment
- 362 Spryker Releases
- 3 Oryx frontend framework
- 35 Propel ORM
- 68 Community Projects
- 3 Community Ideation Board
- 30 Hackathon
- 3 PHP Bridge
- 6 Gacela Project
- 26 Job Opportunities
- 3.2K 📜 Slack Archives
- 116 Academy
- 5 Business Users
- 370 Docker
- 551 Slack General
- 2K Help
- 75 Knowledge Sharing
- 6 Random Stuff
- 4 Code Testing
- 32 Product & Business Questions
- 70 Spryker Safari Questions
- 50 Random