I am duplicating some pages to Spanish and I expect to see those Spanish pages with the same hierarchy was the English pages (original ones). However, they don't hold any hierarchy.
Languages: English (English )Italian (Italiano )Portuguese (Brazil) (Português )
Timezone: Europe/Rome (GMT+01:00)
Hi,
I enabled the wp_debug option and found there are multiple issues with your database, which explain the problem with duplication.
I tried to create new pages to see if the problem still existed, but it seems I'm not allowed to.
The suggestion I got from 2nd tier is to create new pages, but since they are many I think you would prefer another solution.
In that case, I need to escalate the ticket and to do that I need a copy of the site. I tried using Duplicator, which is our preferred option, but it seems I can't do that due to host setup constraints (probably the time limit is not enough). I cannot even take the database backup.
Could you see if there are some other options for us to get a copy of the site?
Sorry for my delayed response. I was preparing the site to be able to share the files with you. It is ready now, so, could you please allow a private message to put the URL there? Our hosting provider, WPEngine, allows us to download a zip file of the site.
Do you mind telling me what you saw with the wp_debug?
Languages: English (English )Italian (Italiano )Portuguese (Brazil) (Português )
Timezone: Europe/Rome (GMT+01:00)
Hi,
sorry for the delay in response but we had a high workload due to our latest release and it was also a holiday in Italy.
I checked your .zip file, but without the database, I can't recreate your site. I could access the site and take it, but I would need to install a plugin to do so (I would use Duplicator).
Also, I can see several "language folder" to define them, could you explain to me why did you create them and for what do you use them for?
I've found that in the table wp_icl_translations there are rows with NULL in the element_id field. Those are causing a database error logged in debug.log about a UPDATE that fails because the trid and language_code already exist and there is an index that prevents of duplication. So I deleted the pages that were duplicated from the original language, deleted the rows with NULL value and re-duplicate the pages in translator management and now the hierarchy is preserved and the translation status is correct.
The question now is if what I did: deleting those rows containing NULL in element_id is a good way to fix this problem.
All above I did on a copy of the site, so the site that you guys have access was untouched.
Since I know that changes made directly in the database might cause other issues, maybe there is data in other tables referenced. I rather wait to get a confirmation. However, we are hitting deadlines here and we would like to know if we could get an answer by Monday.
Languages: English (English )Italian (Italiano )Portuguese (Brazil) (Português )
Timezone: Europe/Rome (GMT+01:00)
Hi,
we have reduced workforce during the weekend, so no, I don't think it's possible to have an answer before Monday.
I can suggest to backup everything before applying the changes, so in case something is wrong you can rollback.
Languages: English (English )Italian (Italiano )Portuguese (Brazil) (Português )
Timezone: Europe/Rome (GMT+01:00)
Hi,
here is a reply from 2nd tier:
"There is a risk for that.
We had a similar issue, related to ATE translation.
When you translate by ATE, the element_id becomes NULL until the translation is delivered and that delivery was triggering only on visiting WPML > Translations page.
Further than that - this is a suitable and valid workaround."
