[Resolved] There is a problem with the String Translation table in your site.

Hello,

Welcome to the WPML support forum. I will do my best to help you to resolve the issue. A couple of requests for tracking this.

1) Please share with us the WordPress debug.log(not WPML debug information) for collecting more details on this. Refer to the following pages for instructions

https://wpml.org/documentation/support/debugging-wpml/

https://wordpress.org/documentation/article/debugging-in-wordpress/

To enable WordPress Debug log, open your wp-config.php file of site root and look for define('WP_DEBUG', false);. Change it to:

// Enable WP_DEBUG mode
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 );

In this case, the errors will be saved to a debug.log log file inside the */wp-content/* directory. Please do the steps to reproduce the bug and check you are getting any errors or warnings related to WPML in the log file.

If you can paste your debug.log to http://pastebin.com/index.php and provide me that link it would be great! (This is the cleanest way because sometimes the logs are long and create a complete mess of discussion).

2) It would be helpful if you could share a couple of screenshots for better understanding of the following.

I can't select default language on WPML site. 

Also lot's of options is empty.

--
Thanks!

Bigul

Hello,

Thank you for the details. The Debug.log is showing the following DB error a few times.

WordPress database error You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near

This may be related to the following ticket. So can you please with your hosting team that you have the correct settings for the MySQL database? Which hosting service & plan you are currently using?

https://wpml.org/forums/topic/wordpress-database-error-you-have-an-error-in-your-sql-syntax/

Do you have a staging/dev site(a clone copy of the live site)? Because it will help us to troubleshoot the issue without affecting the live site.

--
Thanks!

Bigul

Hi Shay,

Thank you for the feedback. Please fill the private details fields after a full site backup. I would like to access the admin area of your site for further checking. Refer to the following links for more details about our private information sharing policies.

https://wpml.org/purchase/support-policy/privacy-and-security-when-providing-debug-information-for-support/

hidden link

--
Thanks!

Bigul

Hi Shay,

Thank you for the login credentials. I am getting the expected results on your site after the following steps.

1) Visit WPML>>Languages>>Site Languages
2) Add English as a language in the site
3) Set English as the default language of the site
4) Add Hebrew as a language in the site
5) Set Hebrew as the default language of the site
6) Install and activate WPML String Translation plugin
7) Translate *Search Here* string from WPML>>String Translation

Please check the attached images for more details. Therefore translate few of the posts/pages/strings and make sure you are getting the expected results or not.

To remove the following warning you can try the workaround suggested here - https://wpml.org/forums/topic/there-is-a-problem-with-the-string-translation-table-in-your-site-209/#post-9917251

There is a problem with the String Translation table in your site. This problem is not causing a problem running the site right now, but can become a critical issue in the future. WPML support team knows how to fix it. Please add a message in the relevant support thread and we'll fix it for you.

Please try it and let us know your feedback.

--
Thanks!

Bigul

Hi Shay,

Thank you for the updates. We can reset WPML from WPML>>Support>>Troubleshooting>>Reset section. But once we reset if will not possible to recover the translated data and current WPML configuration. So please try it only after a full site backup{mandatory}. Refer to the following article for more details.

https://wpml.org/documentation/getting-started-guide/language-setup/deleting-languages-and-plugin-data-by-doing-a-wpml-reset-on-your-site/#step-3-do-the-wpml-reset

After the reset action please try to configure WPML as per your requirement and make sure the problem remains or not.

--
Thanks!

Bigul