Background of the issue:
I am trying to have a functional website. I expected to see an empty debug.log.
I have already asked for the solution. But after applying SQL Create table query on production site, the web was completely corrupted and I had to restore the full backup. I know what I did, I applied the fix exactly same way as on the staging site.
The site was migrated to the new hosting, yes, but after my further research, on the previous hosting there were even much more problems with WPML and autoload!
Symptoms:
The debug log is flooded with errors related to 'icl_background_task' table not existing. The log file has grown to 20 MB due to these errors. Example error: WordPress database error Table 'u117824311_aoov.wpeg_icl_background_task' doesn't exist for query SELECT * FROM wpeg_icl_background_task WHERE task_status IN ('1','0','2') AND 1=1.
Questions:
Why is the 'icl_background_task' table missing?
How can I stop the debug log from being flooded with these errors?
Fyi: I´ve already tested deactivate all the plugins, but this issue is internal WPML problem. After applying patch from last chat, I could not create any new posts or pages, WP instalation was completely corrupted after that.
I have run this query:
CREATE TABLE IF NOT EXISTS `wpeg_icl_background_task` (
`task_id` BIGINT UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY,
`task_type` VARCHAR(500) NOT NULL,
`task_status` SMALLINT UNSIGNED NOT NULL DEFAULT 0,
`starting_date` DATETIME NULL,
`total_count` INT UNSIGNED NOT NULL DEFAULT 0,
`completed_count` INT UNSIGNED NOT NULL DEFAULT 0,
`completed_ids` TEXT NULL DEFAULT NULL,
`payload` TEXT NULL DEFAULT NULL,
`retry_count` SMALLINT UNSIGNED NOT NULL DEFAULT 0
)
This doesn't look like harm potential query, but the question is, which operation follows after, when the table has been created.
I have tested to switch CTE to ATE, but issue is not resolved.
I tested DB query again on dev site. Works without any problems.
Switching to ATE on production site return another error:
Which translation engines do you want to use?
Automatic translation engines differ in translation style and supported language pairs. If your preferred translation engine does not support a language pair that you want to use, we fall back to your next preferred engine that does support it. Learn more about,
Failed to load engines
I will test to run DB query during the night at production site.
After second patching it seems to be working without side effects. I am able to create new posts and pages.
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.
