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: MSM Site Displaying Mixed Languages

Status	Resolved
Add-on / Version	Publisher 2.7.0
Severity
EE Version	3.5.12

Gregory Maher

Apr 13, 2018

Hi Brian,

Description:
We have a site that on one of the MSM sites, one of the channels is displaying mixed languages for a channel. It’s happening for both the Title and some other fields. I’ve been able to reproduce it locally.

To Reproduce:
Navigate to the EU version of the site at the url in the ticket /eu. Click on the first navigation item to open the dropdown. Observe the different languages within the navigation. I’ll followup with a quick video to demonstrate.

This looks to be something in the database as locally, with a slightly older db it’s not happening.

Is this something you’ve seen before? Anything I can check immediately?

Thanks in advance!

Greg

BoldMinded (Brian)

First navigation item in the dropdown, do you mean this page? http://www.raritan.com/eu/products/power/power-distribution

Have you tried upgrading to the latest version of Publisher? What kind of content is that… how is it managed? Grid, entries list via relationships tag or normal entries tag, Bloqs?

If you think its something in the database did you take a peak at it? Maybe to see if there are duplicate rows or rows that somehow have the wrong lang_id assigned to them?

Gregory Maher

Comment has been marked private.

BoldMinded (Brian)

Its an MSM site, but is that relevant in this case? Is it displaying content from a different site or is it just different translations from the same entry?

BoldMinded (Brian)

How are those navigation items built? Structure or some other means?

I have a lot of questions 😊 Need to narrow down the actual things involved in the issue.

Gregory Maher

Hi Brian, It’s displaying different translations from the same entry. The navigation is built using Low Reorder tags to display entries within sets, based on categories.

I will try to update Publisher shortly. But all was working until about 2 weeks ago…we only noticed yesterday.

You should have access to the site. If you have any more questions, certainly let me know.

Thanks for taking a look!

Greg

BoldMinded (Brian)

I’ll only login as a last resort. After you upgrade Publisher try re-saving the problem content to see if it fixes the issue. If not, don’t use Low Reorder…. list out the same content using a basic entries tag in a template all by itself… no other template tags, html, or css, and see if its still outputting the incorrect content. If you get to this step and its still incorrect I’ll login and take a look (add {entry_id} in the loop so I can easily see what data its working with)

Gregory Maher

Hi Brian, I believe this was fixed with an update. Thanks for the quick responses!

Talk soon!

Greg

Gregory Maher

Comment has been marked private.

BoldMinded (Brian)

Change line 262 to this:

'templates' => isset($templatesByGroup[$row['group_name']]) ? $templatesByGroup[$row['group_name']]: []

#10

Gregory Maher

Comment has been marked private.

#11

BoldMinded (Brian)

There have been a ton of commits between 2.7.0 and the version you have now, some of which deal with url routing. Did you test this on the staging site before pushing it live? Did you clear your site caches after upgrading? I’ll be honest I won’t be able to look into this today.

#12

Gregory Maher

OK, no problem at all. We did test it on a staging site, but not this particular piece of functionality. I’ll take a closer look and see if it’s something I can find easily. It’s odd that it’s only one of the MSM sites - the others seem to function correctly.

#13

BoldMinded (Brian)

Check the page headers for “X-Publisher-Redirect” to see at least what parts of Publisher might be causing a redirect.

#14

BoldMinded (Brian)

Does this scenario sound familiar?

[Fixed] If url translations were off, prefixes on, add prefix to homepage off, and hide prefix on default language was on breath, some urls were not properly prefixed with the language code.

https://boldminded.com/support/ticket/1660

#15

BoldMinded (Brian)

Comment has been marked private.

#16

Gregory Maher

Comment has been marked private.

#17

Gregory Maher

I can certainly try to revert to the older versions. I’ll do so shortly. Anything to know about the “downgrading”?

Thanks so much for the quick responses, Brian!

Greg

#18

BoldMinded (Brian)

No, downgrading should be fine. I haven’t made any major DB updates in awhile. Just be sure to clear all caches after each downgrade/upgrade (or disable all caching entirely if you can). Of course backup your DB before you start just to be extra safe.

#19

Gregory Maher

Hi Brian, Before I go too far, this is working fine on another MSM site in the same installation. That “site” uses the identical Publisher settings and template code.

Think I should still try downgrading?

#20

BoldMinded (Brian)

Yeah, I’d still try downgrading.

#21

Gregory Maher

Hi Brian, So, based on the Change Log I started with the version right before the above mentioned edit ([Fixed] If url translations were off, prefixes on, add prefix to homepage off, and hide prefix on default language was on breath, some urls were not properly prefixed with the language code.).

2.7.3 seems to have fixed both of my issues.

So it looks like in situations where add prefix to homepage is ON seems to cause issues.

Thanks so much for offering the previous versions. Let me know if I can help troubleshoot anything for you and we’ll plan accordingly.

Have a great day!

Greg

#22

BoldMinded (Brian)

I’m going to need FTP to trouble shoot this one. I don’t have anything near this complex of a setup locally to replicate it.

So you’re saying 2.7.6 is what broke it?

#23

Gregory Maher

Comment has been marked private.

#24

BoldMinded (Brian)

The pagination_create hook was added in 2.7.5, but if you have a lower version installed the method isn’t there, but the DB thinks it is.

I’d rather not have repo access, that would require setting everything up locally. In this case, since its a complicated MSM site, I’d rather avoid setting up the sites locally.

#25

Gregory Maher

OK, so I just manually disabled that extension in the db…is that fine?

I’ll update the ticket with ftp access. Can you give me an IP address to whitelist?

Thanks!

Greg

#26

BoldMinded (Brian)

If you mean that you set the pagination_create hook row enabled value set to “n”, then yeah thats fine.

#27

BoldMinded (Brian)

Comment has been marked private.

#28

Gregory Maher

OK, great. That’s what I did and it seemed to work. I’ll wait on your IP address.

Thanks again, Brian!

Greg

#29

BoldMinded (Brian)

Comment has been marked private.

#30

Gregory Maher

Hi Brian, This IP address has been added so you should be all set.

If anything doesn’t work, just let me know.

Thanks in advance!

Greg

#31

BoldMinded (Brian)

Do the same logins provided work for the staging site? I don’t want to debug on production…

#32

Gregory Maher

They do. If you have any issues let me know.

Thanks!

Greg

#33

BoldMinded (Brian)

I also don’t see the behavior you’re describing in comment #10 happening on production or on staging.site.com. Are you positive its still happening? If so could you create a quick video of it?

#34

Gregory Maher

Rolling back to 2.7.3 seems to have fixed both issues. If you upgrade one of those to 2.7.9 you’ll see the issue again. I can do that for you but it’ll take me some time.

Just let me know.

Thanks!

Greg

#35

BoldMinded (Brian)

Time to update to 2.7.9 or the video? If you update the site back to the broken state with 2.7.9 we can forgo the video.

#36

BoldMinded (Brian)

And so its clear you started with 2.7.0, and 2.7.9 fixed the content issue, but introduced the weird redirect issue? 2.7.3 Fixes both the content and redirect issue?

#37

Gregory Maher

Yes, sorry…that’s what I meant. Some time to re-update back to the broken 2.7.9. I will do it asap but I’m heading out to a meeting now.

And, your notes in Comment #36 are correct.

Thanks!

Greg

#38

BoldMinded (Brian)

Comment has been marked private.

#39

BoldMinded (Brian)

The FTP you provided doesn’t allow me to access the staging site’s folders.

#40

Gregory Maher

Comment has been marked private.

#41

BoldMinded (Brian)

Weird, works this time. I’ll try to take a look at it tonight. Are you able to try upgrading to those other versions to see if we can narrow down the range of commits/versions where the redirect issue started?

#42

Gregory Maher

Comment has been marked private.

#43

BoldMinded (Brian)

It looks like the issue was introduced in 2.7.5. It appeared to work fine in 2.7.4

#44

BoldMinded (Brian)

So, this is pretty hard to debug because when I click then Anglais link in the dropdown on the staging site, it actually redirects to the production site. Is there a way you can fix that?

#45

BoldMinded (Brian)

Double check that the site_url is correct in the database for each site config too. If MSM is enabled Publisher will get the site_url from the database, not the config file.

#46

Gregory Maher

Hi Brian, I believe this is sorted out with a recent build you provided. You can go ahead and close this ticket.

Thanks!

Greg

#47

Gregory Maher

Comment has been marked private.

#48

BoldMinded (Brian)

What do you mean by “We seem to be having a very similar issue to the one reported above” - I see the rest of your comment about the repeating url segments, but what is “above”? Can you provide a comment number? Or was this meant to be referencing another ticket entirely?

Can you remind me about the setup before I login? Is /ap/ a sub-directory with an EE index.php file so it serves a secondary site?

#49

BoldMinded (Brian)

Also, is this happening in the staging environment as well? If so I’d rather debug there and not touch the live site directly. That’s bad news bears.

#50

Gregory Maher

So sorry, Brian!

Comment #10 above.

You’re exactly right in the setup. /ap, /eu, /jp are sub-directories with ExpressionEngine index.php files. They’re setup as MSM sites.

Thanks!

Greg

#51

Gregory Maher

Yes, it is happening in the staging site also.

If you replace www with staging on those provided URLs you’ll see the same issue.

Thanks so much for looking into it!

Greg

#52

BoldMinded (Brian)

This sounds similar to https://boldminded.com/support/ticket/1771

#53

Gregory Maher

Hi Brian, OK, I’m working through some htaccess and configuration things now. We use Master Config and for some reason the site_index set in the regional (subdirectory) index.php files isn’t appearing in the CP.

But, things seem to have been stabilized through some htaccess modifications. I’ll keep you posted if anything else comes up but you can likely close for now. Thanks for the quick response!

Greg

#54

BoldMinded (Brian)

Sounds good. I thought this sounded like a config issue 😊 I’ll go ahead and close the ticket again.