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.

This topic contains 14 replies, has 4 voices.

Last updated by Carlos Rojas 5 months, 1 week ago.

Assigned support staff: Carlos Rojas.

Author Posts
June 26, 2018 at 8:24 pm #2436250

wdburgdorf

I am trying to:
Import product translations using WPML All Import

Link to a page where the issue can be seen:
Can only be seen in backend

I expected to see:
Imported products

Instead, I got:
"Your server terminated the import process"

Screenshot: hidden link

I set up a sandbox on a server of WP All Import: hidden link

The problem is the same here as on my own installation.

Please find the files I used here:
hidden link
hidden link
hidden link

The CSVs are identical, only the product titles are different. SKUs are unique, so those serve as connectors.

I sent the same message to WP All Import, they referred me to you.

Thank you!

June 28, 2018 at 3:03 pm #2441970

Lauren
Supporter

Languages: English (English )

Timezone: America/New_York (GMT-04:00)

Thank you for contacting WPML support. I'll be happy to help you with this.

What number records per iteration are you using? Please try lowering the records per iteration and see if this makes any difference.

Also, I have seen issues when trying to use Sku as the unique identifier. Please try adding a column to your files that serves as a truly unique identifier, and make sure they match in both languages.

Lastly, please ask your hosting provider to check the server error log to see if there are any messages there. If so, please paste the message in your next reply.

To ensure the quickest and most accurate support, please provide your debug information so that I can get a look at some of your configurations. We have an excellent article on how to located here: https://wpml.org/faq/provide-debug-information-faster-support/.

NOTE: Please be sure to check the box to indicate you can provide debug info and paste your debug info in the debug field provided, and NOT in the general response field.

June 28, 2018 at 5:22 pm #2442399

wdburgdorf

Hello Lauren,

Thanks for your reply.

Iteration: Lowered to 1, makes no difference

SKU is truely unique. Another connector would be very difficult to use, because we have several tables (one per supplier), and each of those will change regularly. I wouldn't know how to keep track of independent connctors. SKUs on the other hand will always be unique and remain the same per product across all translations. I can try with a different connector just to see if it helps.

Error log: I am my own hosting provider and there is nothing in the log about this.

I provided debug information from my own site. You can also try yourself and check the configuration on the WP All Import sandbox site. Same result there, therefore I assume it is not the template or another plugin on my site.

Thank you!

June 28, 2018 at 6:07 pm #2442482

Lauren
Supporter

Languages: English (English )

Timezone: America/New_York (GMT-04:00)

Thanks for testing this for me. I tested importing the files on a clean install but ran into the same issue that you reported.

To best troubleshoot the issue, please make a snapshot of your site using the Duplicator plugin: https://wordpress.org/plugins/duplicator/. This will allow me to try and duplicate the error so that I can run further tests without interrupting your live site.

Once the snapshot is complete, either upload the snapshot ZIP file and the installer.php file to a file sharing service such as Dropbox (and share the link in your reply) or right click the Duplicator links in your wp-admin and paste in your reply.

Please note: It is important to reduce the size of the package so please exclude some paths like /cache or /uploads and also exclude archives and media files.

I will also need the username and password of an account that was created BEFORE creating the duplicator package.

I will enable the next reply to be private so only you and I have access to it!

July 3, 2018 at 6:41 am #2455723

wdburgdorf

I tried to create another package from the All Import sandbox, because that is a clean installation, no special template etc., but I found updates for WPML, installed those, and the sandbox exploded:

"Fatal error: Uncaught exception 'InvalidArgumentException' with message 'Argument ID must be numeric and greater than 0.' in /var/www/public/odd-zebra/wp-content/plugins/sitepress-multilingual-cms/classes/translations/class-wpml-translation-element.php:28 ..."

(no access to files, no way to fix it ...)

July 4, 2018 at 7:48 pm #2464983

Carlos Rojas
Supporter

Languages: English (English ) Spanish (Español )

Timezone: America/Montevideo (GMT-03:00)

Hi there,
My name is Carlos and I will be taking this ticket because our colleague Lauren is on vacations this week.

I'm downloading the Duplicato package and I will run some tests on a local environment in order to reproduce the issue and try to find it's cause.

I will get back to you as soon as possible.

Best regards,
Carlos

July 4, 2018 at 9:43 pm #2465196

Carlos Rojas
Supporter

Languages: English (English ) Spanish (Español )

Timezone: America/Montevideo (GMT-03:00)

Hi,

With the copy of the site on local I ran into the same Fatal Error when I tried to deactivate the plugins. However I created a fresh new install and I was able to import all the products (15 per language) correctly. This leaves the issue in the live site and not in the import process.

I would like to ask you to follow this steps in order to isolate the cause of the issue:
- Back up your site first before making any change, this is for security reasons.
- Deactivate all the plugins that are not related to WPML.
- Switch for a moment to a WordPress default theme like Twenty Seventeen.
- If the issue is gone, activate one by one to see with which one there is an interaction issue.

Could you tell me the result of this steps?

Best regards,
Carlos

July 5, 2018 at 7:51 am #2466009

wdburgdorf

I tried the WP All Import sandbox as a fresh new install, as described earlier, with the same result.
And I have never seen plugin incompatibilities or a template to be the cause of such errors. Anyway, I did as you said, switched to twentyseventeen and deactivated all that is not absolutely necessary, only WooCommerce, WPML, and WP All Import left. Same result.

You're welcome to try yourself: hidden link

July 5, 2018 at 9:33 am #2466454

wdburgdorf

Now I set up a completely new site, on the same server, all the same plugins. Import seems to work there. So it must be something about the settings, or installation history.

July 5, 2018 at 4:27 pm #2468395

Carlos Rojas
Supporter

Languages: English (English ) Spanish (Español )

Timezone: America/Montevideo (GMT-03:00)

Hi,

Yes, I believe that the issue is in the production site. I asked you to deactivate all plugins and change themes in the site to rule out some compatibilty issue.

With this results we can conclude that the issue is in the original installation and not in WPML + WP All Import code.

At this point I recommend you to recreate the site or to contact one of our certified partners if you want to isolate and fix what's causing the 'Fatal Error' as this will involve custom coding which falls outside of our scope as a support service.

Please let me know if you need further assistance and I will be more than happy to help.
Best regards,
Carlos

July 5, 2018 at 6:00 pm #2468730

wdburgdorf

Hi Carlos,

If it was just this one installation, you may be right. But it is also on the original WP All Import sandbox, with original template and no extra plugins. Therefore WP All Import support concluded, it must be WPLM that causes the issue, and they sent me here. I would be glad if you discussed this with WP All Import - at least on their sandbox it should work. Otherwise I have no hope that I could get it to work on my own installation.

Thank you!

Best regards,
Ralf

July 5, 2018 at 6:08 pm #2468818

Carlos Rojas
Supporter

Languages: English (English ) Spanish (Español )

Timezone: America/Montevideo (GMT-03:00)

Hi Ralf,

I will consult my colleagues about this issue and I will get back to you as soon as I get an answer.

Thank you very much for your patience and understanding.
Best regards,
Carlos

July 9, 2018 at 12:28 pm #2476195

Carlos Rojas
Supporter

Languages: English (English ) Spanish (Español )

Timezone: America/Montevideo (GMT-03:00)

Hi Ralf,

Could you provide a video with the steps you are following to make this import? This way our specialists could have more information and they will be able to replicate the issue in the exact same way as you did.

Best regards,
Carlos

May 9, 2019 at 1:19 pm #3776457

mostafaE

Hello Carlos,
I'm trying to import an excel sheet in 2 languages, English(As default) and Arabic, I'm facing 2 errors
1 - Every time I am trying to upload the excel sheet I got an error saying "Your server terminated the import process", I tried to fix this error by disabling all my plugins and I found that when I deactivate "WPML Multilingual CMS" the error doesn't appear, and the products are loaded successfully, but with Arabic I can't import products because of deactivating "WPML Multilingual CMS" will make the Arabic products imported as English also.
2- After importing the products if I tried to see the products after activating WPML I can't see them but after deactivating it and reActivating the products are visible.
Notice: i've tried to reproduce the error using sandbox but I can't, the error seems in my setup.

May 9, 2019 at 6:06 pm #3778645

Carlos Rojas
Supporter

Languages: English (English ) Spanish (Español )

Timezone: America/Montevideo (GMT-03:00)

Hello,

As this ticket is closed, I kindly ask you to open a new ticket describing the issue in your site. This way you will get a better support service and we will be helping future clients to find answers in the forum in an easier way.

Thank you very much for your understanding!
Best regards,
Carlos