Background of the issue:
I am trying to reorder the product list on my website. I encountered an error when attempting to move products up or down. I made updates yesterday. Here is the link to the page where the issue can be seen: hidden link. With debug, I got an issue that it's coming: [07-Aug-2025 19:56:17 UTC] WordPress database error You can't specify target table 'posts' for update in FROM clause for query UPDATE pak_iki_sec_db_posts posts JOIN pak_iki_sec_db_icl_translations trans ON posts.ID = trans.element_id AND trans.element_type = 'post_product' SET posts.menu_order = ( SELECT menu_order FROM pak_iki_sec_db_posts JOIN pak_iki_sec_db_icl_translations ON ID = element_id AND element_type = 'post_product' WHERE language_code = 'hy' AND trid = trans.trid ) WHERE trans.language_code <> 'hy'.
Symptoms:
I see a loading icon when trying to move products, and I can't reorder them. The sorting isn't working as expected.
Questions:
How can I fix the database error when reordering products?
Why is the loading icon appearing and preventing product movement?
as I understood from your reply, the issue still happens when WPML is disabled, correct?
If yes, then the issue is not caused by WPML, and you should probably check further with other plugins / themes disabled and contact the relevant developer.
No. something misunderstand. as without WPML there are no languages except of English the issue not happening. I gave you all the details. Can you just check why it happened and how to fix.
you mentioned in your reply: "Disabled the WPML and the issue still in the website."
That is why I assumed it still happens. Please check one more thing before we proceed.
Can you please try next:
- Make sure you have a backup.
- Disable all other plugins and leave active only WPML plugins
- Switch to WP default theme
- Check if the issue still happens.
Let me know how it goes.
Regards,
Drazen
The topic ‘[Closed] Can’t reorder the products’ is closed to new replies.
