[Closed] WordPress database error Commands out of sync with wp-all-import sync

Hi,

Please try the following and check if it helps to solve the problem.

1. Disable all caching on your site while doing the import.

2. Increase the WP Memory Limit by adding the following code in the wp-config.php file of your WordPress installation.

/** Memory Limit */
define('WP_MEMORY_LIMIT', '256M');
define( 'WP_MAX_MEMORY_LIMIT', '256M' );

(Save the file after adding this code.)

3. Use WPML's troubleshooting section.

Please, try the troubleshooting section.

1. Take a backup of the DB of your site.

2. Go to WPML -> Support -> Troubleshooting (link)

3. Once on the troubleshooting screen, press the following buttons and check if it helps. Press each button at a time and wait for the process to complete.

- 'Disable cache for language switcher templates'

- 'Clear language information and repopulate languages' button (if it is showing)

- 'Synchronize posts taxonomies' for 'Products'

- 'Clear the cache in WPML'

- 'Remove ghost entries from the translation tables'

- 'Fix element_type collation'

- 'Fix WPML tables collation'

- 'Assign translation status to duplicated content'

- 'Set language information'

- 'Reset languages' Press this button only if you didn't add a custom language!

- 'Fix terms count'

- 'Fix post type assignment for translations'

- 'Cleanup and optimize string tables'

*** Please backup your database before using this.***

Can you please try the above and check if it helps?

Hi, and thanks for trying my suggestions.

If you need further help with this, please share the access details to your site with me. Please also share the FTP access details.

Explain to me which import is failing and causing this error.

I'm enabling a private message for the following reply.

Privacy and Security Policy
We have strict policies regarding privacy and access to your information. Please see:
https://wpml.org/purchase/support-policy/privacy-and-security-when-providing-debug-information-for-support/
**IMPORTANT**
- - Please backup the site files and database before providing us access. --
-- If you have a staging site where the problem can be reproduced, it is better to share access to the staging site.--

Hi, and thanks for updating me on your findings.

So it seems we have a problem that does not necessarily link to WP All Import. Let's please look for PHP errors while repeating this process. Can you please proceed with the following?

1. If not enabled, please enable WordPress's debug log. Open your wp-config.php file and look for

define('WP_DEBUG', false);

Change it to:

define('WP_DEBUG', true);
// Enable Debug logging to the /wp-content/debug.log file
define('WP_DEBUG_LOG', true);
// Disable display of errors and warnings
define('WP_DEBUG_DISPLAY', false);
@ini_set('display_errors', 0);

2. Repeat the action that causes the problem on your site, which means trying to activate WPML as you describe above.

The errors will be saved to a debug.log log file inside the /wp-content/ directory. Then please share the errors with us.

Thanks,
Itamar.

Hi,

I am handling this ticket meanwhile Itamar is on vacation.

I've forwarded your findings to our 2nd tier team and 'll get back to you as soon as I have more information.

Thank you for your patience and cooperation.

Regards.