Publisher does not support the Fluid field type. Please do not contact asking when support will be available.

If you purchased an add-on from expressionengine.com, be sure to visit boldminded.com/claim to add the license to your account here on boldminded.com.

Ticket: Variable isAuto undefined Update phrases

Status Resolved
Add-on / Version Publisher 2.6.2
Severity
EE Version 3.5.6

Jérôme Canon

Jul 24, 2017

Hello,

i Updated Publisher from 2.5 to 2.6.2 and now when i try to update the translations of a phrase i have an error message.

Screenshot :

https://www.dropbox.com/s/qp4yyrmx4cf8fje/Capture%20d%E2%80%99%C3%A9cran%202017-07-24%20%C3%A0%2013.35.34.png?dl=0

I downgrade and it’s ok.

Regards,

J.

#1

BoldMinded (Brian)

Unfortunately this could happen in some edge cases, and I can’t write a script to automatically fix it. You’ll need to manually review your exp_publisher_phrase_data table and remove the duplicate rows. You can run this query to identify the duplicates, then determine which rows to delete.

select distinct phrase_id, site_id, lang_id, `status`, is_auto, edit_by
  from exp_publisher_phrase_data as t1
 where exists (select * 
                 from exp_publisher_phrase_data as t2 
                where t2.id != t1.id
                  and t2.phrase_id = t1.phrase_id
                  and t2.site_id = t1.site_id
                  and t2.lang_id = t1.lang_id
                  and t2.`status` = t1.`status`
                  and t2.is_auto = t1.is_auto
                  and t2.edit_by = t1.edit_by
               )

I wish I had a better answer for you but I can’t create a query to fix it automatically because I don’t know which row contains the correct translation for your site.

#2

BoldMinded (Brian)

Note this shouldn’t happen again. The error you’re seeing is because the unique index I added to prevent it was added after you already had duplicates, so what you’re seeing is an old bug.

Login to reply