[Waiting for user feedback] Database error after latest update
This is the technical support forum for WPML - the multilingual WordPress plugin.
Everyone can read, but only WPML clients can post here. WPML team is replying on the forum 6 days per week, 22 hours per day.
Our wait time is higher than usual, please make sure you are meeting the minimum requirement - https://wpml.org/home/minimum-requirements before you report issues, and if you can take a look at current Known Issues - https://wpml.org/known-issues/. Thank you.
<b>Background of the issue: </b>
I am trying to import data via WP-CLI but it causes database errors. This issue started happening after the latest update.
I checked the database and both tables exist, so the problem must be related to running the update from WP CLI.
<b>Symptoms: </b>
I got errors from the WP-CLI command. The following two errors are reported numerous times:
WordPress database error Table 'pylaimmobilier.wp_icl_links_post_to_post' doesn't exist for query SELECT id_to FROM wp_icl_links_post_to_post WHERE id_from = 820 made by shutdown_action_hook, do_action('shutdown'), WP_Hook->do_action, WP_Hook->apply_filters, WPMLUserInterfaceWebInfrastructureWordPressCompositionRootConfigEventTranslationLinksItemUpdateEvent->WPMLUserInterfaceWebInfrastructureWordPressCompositionRootConfigEventTranslationLinks{closure}, WPMLInfrastructureWordPressComponentTranslationApplicationEventLinksItemUpdateEventListenerAdapter->onShutdown, WPMLCoreComponentTranslationApplicationEventLinksItemUpdateListener->onItemSave, WPMLCoreComponentTranslationDomainLinksHandleUpdateOriginal->handle, WPMLCoreComponentTranslationDomainLinksHandleUpdateOriginal->collectRelationships, WPMLInfrastructureWordPressComponentTranslationDomainLinksRepository->getToItemsByFromItem
and
WordPress database error Table 'pylaimmobilier.wp_icl_links_post_to_term' doesn't exist for query SELECT id_to FROM wp_icl_links_post_to_term WHERE id_from = 820 made by shutdown_action_hook, do_action('shutdown'), WP_Hook->do_action, WP_Hook->apply_filters, WPMLUserInterfaceWebInfrastructureWordPressCompositionRootConfigEventTranslationLinksItemUpdateEvent->WPMLUserInterfaceWebInfrastructureWordPressCompositionRootConfigEventTranslationLinks{closure}, WPMLInfrastructureWordPressComponentTranslationApplicationEventLinksItemUpdateEventListenerAdapter->onShutdown, WPMLCoreComponentTranslationApplicationEventLinksItemUpdateListener->onItemSave, WPMLCoreComponentTranslationDomainLinksHandleUpdateOriginal->handle, WPMLCoreComponentTranslationDomainLinksHandleUpdateOriginal->collectRelationships, WPMLInfrastructureWordPressComponentTranslationDomainLinksRepository->getToItemsByFromItem
<b>Questions: </b>
Why am I getting database errors when importing data via WP-CLI after the latest update?
How can I resolve the issue with the tables not being recognized by WP-CLI?
Note that I am using 10.6.21-MariaDB-ubu2204 and not Mysql 5.5
Welcome to the WPML support forum. Before passing this thread to my colleague, I would like to share some suggestions and possible solutions for the issues you mentioned.
Sorry for the late response because of the holidays and the high support load. It is not normal here. Thank you for your kind understanding.
The *wp_icl_links_post_to_term* looks like a table created as a part of custom work or is from another plugin or theme. Becuase WPML doesn't have a table called *wp_icl_links_post_to_term* or *wp_icl_links*.
Please refer to the following links for more details and let us know your feedback.
