WPML 4 - db errors everywhere

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 next available supporter will start replying to tickets in about 2.01 hours from now. Thank you for your understanding.

Sun	Mon	Tue	Wed	Thu	Fri	Sat
-	9:00 – 14:00	9:00 – 14:00	9:00 – 14:00	9:00 – 14:00	9:00 – 14:00	-
-	19:00 – 22:00	19:00 – 22:00	19:00 – 22:00	19:00 – 22:00	19:00 – 22:00	-

Supporter timezone: Europe/Paris (GMT+02:00)

This topic contains 51 replies, has 3 voices.

Last updated by George Botsev 5 years, 6 months ago.

Assisted by: Yvette.

Author	Posts
July 23, 2018 at 7:51 am #2568883
Yvette Supporter Languages: English (English ) Spanish (Español ) Timezone: Europe/Paris (GMT+02:00)	You were right - the site is very large and after numerous attempts to extract the single site, I have convinced our 2nd tier group to log-in directly to your site. I have forwarded all the relevant information to them and they will take it from here forward. The status of this ticket is now set to "Escalated to 2nd tier".
July 23, 2018 at 11:14 am #2569413
Václav	Hello, thanks for the follow-up, looking forward to find a solution for this!
July 23, 2018 at 3:35 pm #2570315
Yvette Supporter Languages: English (English ) Spanish (Español ) Timezone: Europe/Paris (GMT+02:00)	Me too!
July 26, 2018 at 8:17 pm #2586030
Václav	I debugged more, and the same problem appears on the sites with WPML installed / activated, but without WooCommerce. You can test that ie. on kellyxir.cz, which is on the same multisite installation (just use the same admin account). I'm unable to use the new Translation management at all (assign translations to the translators etc.), the db errors are along the lines [code]WordPress database error Field 'translator_id' doesn't have a default value for query INSERT INTO `mw_536_icl_translation_status` (`status`, `translation_id`) VALUES ('9', '7370') made by WPML_Post_Status::set_status [/code] Any chance to get this fixed asap? I'm using WPML forever and never had such issues, it seems that the last WPML versions broke the basic functionality. Thanks V.
July 26, 2018 at 8:31 pm #2586058
Yvette Supporter Languages: English (English ) Spanish (Español ) Timezone: Europe/Paris (GMT+02:00)	Hello I´ve forwarded these observations to the 2nd tier supporter working on your case.
August 6, 2018 at 8:13 am #2614968
Václav	Hello, any news on this please?
August 6, 2018 at 3:31 pm #2616493
Yvette Supporter Languages: English (English ) Spanish (Español ) Timezone: Europe/Paris (GMT+02:00)	Hello Yes, I have some news. The issue was escalated to our programmers and will be fixed in our next release. In the mean time, they advise that you can modify table: icl_translation_status to set a default value for the column "translator_id" to 0. This can be done with SQL code like this: ALTER TABLE `mw_536_icl_translation_status` CHANGE `translator_id` `translator_id` BIGINT(20) NOT NULL DEFAULT '0'; You can use ARI Adminer to effect this change wihtout code as well by altering the table structure. Do you need assistance to try this advice?
August 6, 2018 at 8:17 pm #2617396
Yvette Supporter Languages: English (English ) Spanish (Español ) Timezone: Europe/Paris (GMT+02:00)	Hello I tried using the ARI ADminer plugin on your network but it is not working. So you will have to do the change to your database using your Cpanel/PHPMyAdmin tool. Please let me know if you are successful at doing this.
August 13, 2018 at 10:45 pm #2641368
Yvette Supporter Languages: English (English ) Spanish (Español ) Timezone: Europe/Paris (GMT+02:00)	Hello - I am just checking in to see if the suggested workaround had any effect. We´d appreciate your feedback.
August 27, 2018 at 4:09 pm #2679120
Václav	Hello, sorry for late reply, I've been on my vacations..:) I'll check that and will let you know! Thanks V.
August 27, 2018 at 4:16 pm #2679217
Yvette Supporter Languages: English (English ) Spanish (Español ) Timezone: Europe/Paris (GMT+02:00)	No worries. Thanks.
September 14, 2018 at 2:26 pm #2735710
Yvette Supporter Languages: English (English ) Spanish (Español ) Timezone: Europe/Paris (GMT+02:00)	Hello I have some news from the 2nd tier support group. They are asking if you can once again provide FTP access. I am opening the private area for this again. Thank you in advance.
September 14, 2018 at 2:42 pm
September 16, 2018 at 1:56 pm #2738940
Yvette Supporter Languages: English (English ) Spanish (Español ) Timezone: Europe/Paris (GMT+02:00)	I´ve notified the 2nd tier supporter and passed your warning along to them. Thanks.
September 25, 2018 at 10:10 am #2763354
Yvette Supporter Languages: English (English ) Spanish (Español ) Timezone: Europe/Paris (GMT+02:00)	Hello I have some news from 2nd tier. They write that they have created and installed a new WPML plugin called: HyperDB Multilingual This will be a new WPML addition to the WPML suite of plugins that will be publicly available and supported by our team. They ask if you can please test if your site is now working properly. They have done some testing and it seems that it does but they need your confirmation. I wait for your news.