Hello, my website is having issues with wpml
I can't add products, the process is stuck when I add products + I can't see my products in the product list. hidden link
Here is your ticket. During my investigation, I found that the action scheduler tool of WooCommecrce continuously inserts data into its tables. This action exhausts the database and causes a fatal error. I also noticed that the ID for each action in the database is 0, which is also not correct.
In this case, the structure of the tables needs to be updated properly. I kindly request you update the structure of the WooCommerce Action scheduler tables by following this article: hidden link
Once the structure for all 4 tables is updated, activate the WooCommerce plugin and then check again if the issue persists or not. In order to update the structure, you can seek assistance from the server or hosting administrator.
Please let me know the update. I will be happy to help if you need further assistance in this matter.
Hello There,
I hope you're doing well. Sorry for the delay in responding due to the Weekend.
Thanks for updating the key for the Action scheduler table. It seems that a persistent fatal error, which occurred whenever I attempted to access other pages, has now been successfully resolved as a result.
However, while checking the data tables of the WPML plugin, I noticed that the key has also not been for the column of WPML data tables. Please check this screenshot(hidden link) of one of the tables for a better understanding.
Maybe the database wasn't imported properly at the time of migration or the SQL mode is causing issues with the key. I'd kindly ask you to contact your hosting or developer and ask them if they can check for you if all the tables have the auto-increment feature enabled.
I have also noticed another issue, when I am trying to translate a product it brings a - There has been a critical error on this website. Please check your site admin email inbox for instructions - message
Thank you for updating the keys. It appears that the Fatal error, which was previously occurring when attempting to access the WooCommerce product section, has now been resolved. The Action Scheduler executes certain tasks in the background by WooCommerce. So, it will be activated. You can consult with the WooCommerce support team for more information. As far as I have checked, everything seems to be set up correctly now.
Regarding the Fatal error while translating a product- I reviewed the debug log and identified the root cause of the issue. It appears that the 'AUTO INCREMENT' property hasn't been set for the 'rid' column in the "_icl_translation_status" table of the database. As a result, a duplicate ID is inserted into the database during the translation process which leads to a fatal error.
Please open the "cod_icl_translation_status" table and set `AUTO INCREMENT` for the 'rid' column. You can reach out to your hosting provider in order to update that.
Let me know the update. I will be happy to help if you need further assistance in this matter.
Best Regards,
Prosenjit
Manage Cookie Consent
We use cookies to optimize our website and services. Your consent allows us to process data such as browsing behavior. Not consenting may affect some features.
Functional
Always active
Required for our website to operate and communicate correctly.
Preferences
The technical storage or access is necessary for the legitimate purpose of storing preferences that are not requested by the subscriber or user.
Statistics
We use these to analyze the statistics of our site. Collected information is completely anonymous.The technical storage or access that is used exclusively for anonymous statistical purposes. Without a subpoena, voluntary compliance on the part of your Internet Service Provider, or additional records from a third party, information stored or retrieved for this purpose alone cannot usually be used to identify you.
Marketing
These cookies track your browsing to provide ads relevant to you.
