In Magento 2.4, customer can request to be notified of product which is back in stock. However, to view which product has customer requested to be notified, we need to go to each of the product detail page and view the information under product alert.
Hence, the other way to retrieve the list at one go is to query from the database.
Below is the SQL to extract the list of products and customers who wish to be notified when the products are back in stock.
For some reason, the catalog_product index could not be indexed through the magento scheduler but you are able to reindex it manually and this causes error in loading the product detail page.
This issue has been occurring ever since I upgraded to Magento 2.4.6 and using Smile Elastic Plugin.
{main} {"exception":"[object] (LogicException(code: 0): catalog_product index does not exist yet. Make sure everything is reindexed. at /vendor/smile/elasticsuite/src/module-elasticsuite-core/Index/IndexOperation.php:118)"} []
[2023-07-27T03:33:09.723085+00:00] main.CRITICAL: LogicException: catalog_product index does not exist yet. Make sure everything is reindexed.
The quick workaround is to manually reindex through the CLI which temporarily solve the issue.
If you encounter the following when you reindex with magento, you probably did not install analysis-phonetic and analysis-icu plugins.
Error encounter
{"error":{"root_cause":[{"type":"illegal_argument_exception","reason":"Unknown filter type [phonetic] for [phonetic]"}],"type":"illegal_argument_exception","reason":"Unknown filter type [phonetic] for [phonetic]"},"status":400}
Resolution
Install the 2 plugins below. If you are using elasticsearch docker, docker bash to your docker and install from there
bin/elasticsearch-plugin install analysis-phonetic
bin/elasticsearch-plugin install analysis-icu
When I was updating my magento 2.3 to 2.4.x, PHP 8.1 is required, During the upgrade, I encountered the following coding errors which was either deprecated or hit critical error and need to update to.
Hence, I am sharing the following errors and the workaround.
Found a way to reverse engineer Docker Container to generate a Docker Run command so that I can safely remove the container and re-run it with some settings.
docker inspect --format "$(curl -s https://gist.githubusercontent.com/efrecon/8ce9c75d518b6eb863f667442d7bc679/raw/run.tpl)" [container-id]
If you’re planning your first trip on Royal Caribbean, below are some useful information for boarding/embarkation
You will board the cruise at Marina Bay Cruise Centre.
The address is
61 Marina Coastal Drive, Singapore 018947
If you are driving via KPE, Take Central Blvd Exit, keep left and turn left when you see Marina Costal Drive.
You will see a building and a MRT. That ti snot the Marina Cruise Centre. Drive further down and turn left. You should spot the Spectrum of the Sea Cruise at the dock (It too big not to be missed).
Level 2 should be full. Proceed to level 3 for parking.
For my case, my check in time is 1pm and by the time I reached the car park at 12pm, Level 2 parking is full and I have to park at level 3. Level 3 was about 30% full.
If you’re planning your first trip on Royal Caribbean, below are some useful information related to room
Children are not allowed in the casino. However, if you are dining in the main dining room on level 3, you need to pass through the casino to use the restroom. In this case, it is allowed for your kids to accompany you to the restroom.
The minimum bet for Baccarat is $50 USD.
The minimum bet for Black Jack is $15 USD.
Before using the FlowRider on Deck 16, you need to sign a waiver form and obtain a blue band from Deck 15. The queue time is around 30 minutes, and there are two instructors available. The area is divided into two lanes, and each round lasts 3-5 minutes. Typically, once you wipe out after 2 minutes
Although the queue looks long (usually stretched till Arcade area), it takes about 30-45 mins to clear as each round will clear 8-10 people and each round last 2-3 minutes.
The archery queue looks short but takes 45-60mins to queue as each person/family usually takes 5-10 mins to try out.
If you’re planning your first trip on Royal Caribbean, below are some useful information related to room
The room wall plugs are 2 pin plug. There are 2 USB charging port at the desk area.
