Hi Brain -

Just a quick update. Due to items on the client side, it looks like we’re going to be launching this project first with that issue still in place and return to it on STAG later to address it. As such, I don’t expect us to move this issue forward until sometime next week at the earliest.

In the meantime, let me know your responses to my last post and just know we’ll leave this ticket open and unattended until we are past our launch.

Thanks, Mike

Hi Brian -

We’ve pushed this project live and have STAG available again to troubleshoot this issue. I updated Matrix to the latest version and now we get the errors below on both the front end and in the CP for entries with a Matrix field type. See an example here: http://staging.cadex.com/en/about-cadex/our-people

Error Number: 1054

Unknown column 'is_draft' in 'where clause'

SELECT row_id, col_id_42, col_id_43, col_id_44, col_id_45, col_id_46, col_id_47, col_id_48, col_id_49, col_id_50, col_id_51, col_id_52 FROM exp_matrix_data WHERE field_id = 59 AND publisher_status = "open" AND publisher_lang_id = 1 AND entry_id = 1002 AND is_draft = 0 ORDER BY row_order ASC LIMIT 100

Filename: third_party/publisher/models/publisher_query.php

Line Number: 74

If you can let me know about timing on looking at this ASAP that would be much appreciated. We have other work queued up behind this specific to this website so a heads up would let us better manage our schedule on those.

And of course, beyond this issue in upgrading Matrix is the original issue regarding adding/removing Matrix rows in the original language - and that not being reflected in other languages.

Thanks, Mike

Ok - we’re reverting the site to the previous version of Matrix so that we can work on other items. I’ll follow up next week and hopefully we can get this issue resolved.

Sorry but BWF is not installed on this site - nor never has been. In fact, I’ve never used used it on a project so I don’t think that’s it…

Ok - understood. We’ll circle back after some other updates and after we’ve resolved this Matrix issue - and see if the original bug in this thread still persists.

Thanks Brian. We haven’t looked at this further yet as we’re working on other items.

Pub 113 c installed Brian.

The error above re: saving an entry is still there ({”sEcho”:0,”iTotalRecords”:”0”,”iTotalDisplayRecords”:”0”,”aaData”:[]} for http://staging.cadex.com/de/matrix-issue-2) - though perhaps it shouldn’t be with new entries (I haven’t tried adding another new one). Should it fix that existing entry?

The original row bug remains. See this test entry: http://staging.cadex.com/en/matrix-issue-2. It has an EN row not showing up in DE in the CP.

As well, I get these errors now on the front end if I hit the site without explicitly adding a language code in my url (ie. staging.cadex.com):

A PHP Error was encountered

Severity: Notice

Message: Undefined variable: new_url

Filename: Publisher/Publisher_session.php

Line Number: 702

A PHP Error was encountered

Severity: Notice

Message: Undefined variable: new_url

Filename: Publisher/Publisher_session.php

Line Number: 704

A PHP Error was encountered

Severity: Warning

Message: Cannot modify header information - headers already sent by (output started at /nfs/c07/h04/mnt/112936/domains/system252_stag/codeigniter/system/core/Exceptions.php:170)

Filename: helpers/Publisher_helper_url.php

Line Number: 79

Is it worth creating a new entry at this point to test that behaviour (ie. to see if it happens on other entries)?

Hi Brian -

Sorry, I can’t answer your second question - I’m not really a developer - mostly just a front end guy. As to a clean entry, I’ve run a few tests. I created two more - with the exact same behaviour (fyi, one of those channels did not have a matrix field in it). I also tried editing two previously existing entries in both respective channels and those were ok.

This issue did not exist in before updating to Pub 113 (and then 113c) - and those are the only updates since then. When updating to Pub 112 and the latest Matrix build, all was fine at that point in regards to this specific issue.

And now further, I’m seeing other entry weirdness. While testing some existing entries, I edited the DE version of an entry (ID 233) and when I got the preview returned, it was all English. You can see the DE version of the page here: http://staging.cadex.com/de/privacy

But if you check the CP to edit the German, it still shows the German content - and I see that German content in the exp_publisher_data table.

Thanks for looking at this Brian.

The matrix bug does seem fixed finally. Whew.

One point to make re: the pages template. You are correct that was the issue but those entries were getting assigned that way due to something that changed in Publisher. If you create an entry, it will pick the default template for that channel as defined in the Pages modules settings (which is how EE should work). However, when you go to create a new language version, Publisher is not honouring that Pages module setting and is defaulting to the first template. Not trying to be unkind but that seems like either a bug or oversight in how this works. Publisher seemed to honour that setting previously and I guess I’d argue it still should.

I can obviously re-enable the field in my various entry forms and instruct clients to make certain they select the correct template when creating a new language version - but it doesn’t seem like an ideal workflow. Perhaps you’ll consider having Publisher pull across the selected template from the primary language entry like it tries to do with other fields.

Thanks Brian. Two items:

On STAG, those php errors are now coming up again (without having upgraded to your latest build). Go to: http://staging.cadex.com/ to see them. They disappear if you enter a language code. I thought I’d mention that first before pushing through the latest

On another front, the PROD version of this site is throwing an error now:

Fatal error: Call to undefined method Publisher_entry::is_ignored() in /nfs/c07/h04/mnt/112936/domains/system252/expressionengine/third_party/publisher/libraries/Publisher/hooks/Publisher_matrix_hooks.php on line 87

The client was working on an update when they had connectivity issues with the host while saving an entry and got some kind of DB error back (they did not copy the error). We’re in the process of getting a db backup restored as that seems to be the likely issue. We cannot access and entries in the CP that use Matrix… just curious on your opinion on this that might shed light on things if the DB restore does not work. Thanks.

Yes, that was it.

Let me know about those other php errors on STAG - maybe related to uploading the hook file to PROD by accident?

Thanks Brian. Everything is working with your latest build except for the pages template selection. It is still defaulting to the first selection on other languages for me. I’ve tried testing multiple entries and channels and it never preserves the primary language’s template selection.

I replaced everything completely with the build you sent this AM (publisher-113-20131219). And just now I re-uploaded just those two files from that build. Same behaviour. You can log into the CP to confirm but I’m definitely seeing that behaviour still.

I don’t know what to say. Well, first, I’m not testing any channels that haven’t been assigned a default template. For those that are, it definitely is not working. Maybe you you can explain what you’re doing to get it to work?

I’ll attach two screens of my efforts showing the initial EN entry creation and then what I see in the CP when I switch languages.

What I am doing is:

1. Create new multi-entry entry
2. enter some data (see in my first screen the templates drop down has pre-populated with the correct template)
3. save the entry
4. go to edit the entry again
5. switch to another language, and;
6. the templates drop down now shows ‘adapters’ the first template in the list

Shouldn’t that have ‘multi-entry’ as it’s value?

Is there something wrong with this process or are you dong something different?

Thanks, Mike

Hi Brian -

The template is is fixed - thanks.

However, I have to disagree with your assessment of the page uri errors. They do appear to be a Publisher-related issue. Let me lay this out:

Unfortunately, I had deleted entry 1018 but entry 232 does not have “example/pages/uri” entered as it’s URI. It is ‘sitemap’ for every language when looking at the CP. I’m not certain where you’re seeing ‘example/pages/uri’? I cannot find an occurrence of the string ‘example/pages/uri’ in any table other than exp_publisher_titles - is that where the pages list it exists then? If so, why do I not see that as it’s value in the CP?

Further, I can publish as many entries in the primary language in channels with no pages template assigned without issue. As soon as I go to any of those and attempt to publish an alternate language version, I get the error (sample screen attached). If what you say in the comment above is true (and I’m assuming it is), why am I able to publish EN versions without issue? If there is an entry saved with ‘example/pages/uri’ then according to what you say above, I shouldn’t be able to publish primary language versions either and should see these errors for primary language attempts also - but I don’t. Isn’t that correct? Or are you saying there is an issue that only affects alternate language versions? But in either case, that would seem to point to a Publisher-related issue.

Go into Content > Publish > Subscriptions or Content > Publish > File Groups and publish some EN entries. Those should all work fine. But as soon as you try to publish alternate language versions, you’ll get that error. That just does not make sense to me - why do EN ones work but no other languages?

Thanks, Mike