Tell us what you are trying to do? Argh. I already had a support ticket open and it was closed while I tried to implement the suggestion. But it didn't resolve the issue.
Is there any documentation that you are following? It was provided in the ticket: hidden link
The WPML > Translation Taxonomy page is not rendering and I need to access this because I am getting a message that "Taxonomy sync problem Show this notice.
Some taxonomy terms are out of sync between languages. This means that content in some languages will not have the correct tags or categories.
In order to synchronize the taxonomies, you need to go over each of them from the following list and click the "Update taxonomy hierarchy" button.
My apologies I couldn't find the other ticket to get the details. But since you've provided here, I'll try my best to continue forward.
Since you are using latest WordPress and WPML plugins, it is advised to:
IMPORTANT: Take full backup of your website and database beforehand. It is highly advised to try the following on a staging/dev site first, so your live website isn't compromised.
- upgrade PHP version to at-least 7.4
- and MySQL version to 5.7
Then if problem continues to appear, I'll recommend enabling debugging on the site, so we can see what's causing this issue. Usually, you should be able to render the page when clicking the "Topical". See https://wpml.org/documentation/support/debugging-wpml/ for details.
Once enabled, retry to access the taxonomy. This will log the errors in the debug.log file which you can upload somewhere (i.e. hidden link) and share the download link for investigation.
Thank-you Waqas,
I have updated the PHP to 7.4 (it was on 7.2) and my website is hosted on Hostinger. I have sent a message to them asking about the MySQL version. I think that Hostinger is in control of the MySQL version. I have also modified the wp-config.php file to enable bugging (screenshot attached). I then went to the By Heart admin dashboard and clicked the "Topical" link and the page spun as it has in the past, and did not render. I went back to the wp-content folder to look for the log file but could not find it. Am I looking in the right place?
Hey Waqas, I was able to get an error log generated. I used the Hostinger H-Panel and it was in the ".logs" folder. The file is only 85KB. Here is the link to the file: hidden link
The reason why there wasn't a log file in wp-content folder is the use of wrong quotes surrounding the WP_DEBUG constant in the wp-config.php file and there's an error about it in your supplied log file:
PHP Warning: Use of undefined constant 'WP_DEBUG' - assumed ''WP_DEBUG'' (this will throw an Error in a future version of PHP) in /home/u648632192/domains/byheart.org/public_html/wp-config.php on line 74
Simply remove those quotes from it and use single quote to surround it correctly like:
define('WP_DEBUG', true);
Anyways, I found another error in the same log which seems relevant though:
WordPress database error Table 'u648632192_3CaXo.wp_icl_background_task' doesn't exist for query SELECT * FROM wp_icl_background_task WHERE task_status IN ('1','0','2') AND 1=1 made by require_once('wp-load.php'), require_once('wp-config.php'), require_once('wp-settings.php'), do_action('wp_loaded'), WP_Hook->do_action, WP_Hook->apply_filters, WPML\LIB\WP\Hooks::WPML\LIB\WP\{closure}, WPML\FP\Promise->resolve, WPML\FP\Right->chain, WPML\FP\Right->map, WPML\BackgroundTask\BackgroundTaskLoader->WPML\BackgroundTask\{closure}, WPML\BackgroundTask\BackgroundTaskLoader->getSerializedTasks, WPML\Core\BackgroundTask\Repository\BackgroundTaskRepository->getAllRunnableTasks, WPML\Core\BackgroundTask\Repository\BackgroundTaskRepository->getAllByTaskStatus
Looks like the table "wp_icl_background_task" does not exist in the database. Some tasks run in the background, specially where syncing is required and this table is used.
Please go to your database and check if the "wp_icl_background_task" table exists? If it doesn't exist, please create it manually and check if the issue persists. See the attached image for the table structure.
Hi Waqas,
Thank-you so much for your troubleshooting! I have taken care of the DEBUG line but there was no change after doing that. As for the table "wp_icl_background_task", I think I need to talk to the host of my website (Hostinger) in order to change the database. Does that sound right?
Hi Waqas,
OK, I see that if I go into phpMyAdmin in Hosting H-panel, then I can see the database tables (I'm learning!). When I click the "Structure" tab for the wp_icl_background_task table, it looks like the one that you sent. I've attached a screenshot for you to see.
May I ask for admin access to your website to check the issue in detail? You can create a separate admin user for this purpose, which can be deleted afterwards.
Also provide detailed steps to reproduce the issue and links to pages in admin and on frontend.
Remember to take full backup of your website and database before proceeding. However, a staging/test site is highly recommended, because I may need to try some changes/fixes on the site (including plugins & themes deactivation), which may cause conflicts with the live site otherwise.
Please confirm it in your next reply or let me know if you do not agree with the mentioned.
I've set your next reply as private to share this information safely.
IMPORTANT: If you don't see the section for providing access information, do not write in the message box or the information may appear as public.
I was able to fix the problem, now you can sync the taxonomy by going to WPML -> Taxonomy Translation or directly hidden link.
I had to deactivate and delete WPML Multilingual CMS plugin and then upload again and activate. Looks like the previous installation had some corrupted or broken files. This was throwing a lot of errors in browser console.
Besides this, I updated Astra theme to the latest version. While, there are a lot of out dated plugins which are currently active. So please remember to update the plugins to the latest versions.
And of course, take a full backup before doing any major updates, always!
