![The cron task indexer_update_all_views failed | SQLSTATE[23000]: Integrity constraint violation: 1052 Column ‘entity_id’ in where clause is ambiguous](https://www.rubin.com.np/wp-content/themes/customizr/assets/front/img/thumb-standard-empty.png)
Sorry for my bad English. I am using Magento 2.4.6-p4 CE and I get the following error after every order. The job indexer_update_all_views scheduled at **date** **time** failed with the following error message: SQLSTATE[23000]: Integrity constraint violation: 1052 Column 'entity_id' in where clause is ambiguous, query was: SELECT `o`.`entity_id`, `o`.`increment_id`, […]
Magento2
7841 posts
I’m experiencing an issue with my Magento 2 website concerning inventory management using Multi Source Inventory (MSI). Whenever there is a failed transaction via a specific payment gateway, the inventory quantity for the product is deducted as expected. However, unlike successful transactions, the deducted quantity for failed transactions does not […]
Magento 2.4.6 I am running this every minute via cronjob: php bin/magento cron:run; > /dev/null 2>&1 php bin/magento queue:consumers:start product_action_attribute.update & php bin/magento queue:consumers:start codegeneratorProcessor & php bin/magento queue:consumers:start exportProcessor & After a couple of minutes, my SQL server states “too many connections”. Tried disabling the cron job, which fixes […]
There is an issue arising with a app admin page is redirecting to media/admin and showing 404. Tried clearing cache as well as tried redeploying static content but the issue persists. Checked for the htaccesss and it seems fine as well. https://avenueretail.co.uk/admin getting redirected to https://avenueretail.co.uk/media/admin/admin/index/index/key/ae6fc3c55da773416b13f37c4c1b9c14f6143d2e456859eac5f59b733ce4c3af/ Apologize cannot share server […]
I am using the default api to create customer for a guest user to create account mutation { createCustomer( input: { firstname: “Bob” lastname: “Loblaw” email: “bobloblaw@example.com” password: “b0bl0bl@w” is_subscribed: true } ) { customer { firstname lastname email is_subscribed } } } But after creating the account on my […]
Magento Verrion: 2.4.3-p1 Problem: I tried to update the products weight value in the admin panel. I changed the weight value 1.2kgs(current) => 2.8kgs(preffereable) and press the save&exit button. but in my case nothing has been updated. after changes it’s show the same value 1.2kg. I want to know the […]
When we click on any category or subcategory link , it open two urls : first, it will load below url https://www.website.com/earrings/earlobes Next, it will load below url : https://www.website.com/earrings/earlobes?page=1 as we have pagination. because of this, facebook pixels are triggering two times as we are loading the page url […]
Current Magento v2.4.5-p1. Process Magento version to 2.4.5-p7 upgrade by following process give on below link. https://experienceleague.adobe.com/en/docs/commerce-operations/upgrade-guide/implementation/perform-upgrade Switch to maintenance mode to prevent access to your store during the upgrade process bin/magento maintenance:enable Starting the upgrade process while asynchronous processes, such as message queue consumers, are running may cause data […]
I’m working on a Magento 2 Hyva Theme project and need to convert the default Media Gallery slider into a vertical slider. Currently, the slider displays images horizontally, but I want it to scroll vertically instead. Can someone provide guidance or point me in the right direction on how to […]