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: Issue with Publisher 2 and Bloqs

Status	Resolved
Add-on / Version	Publisher 2.6.0
Severity
EE Version	3.5.7

Hop Studios

Jul 10, 2017

Hi there,

I’ve been testing Bloqs and Publisher 2 on my local EE3 install and it seems that there’s a bug when creating drafts.

EE 3.5.7
Publisher 2.6.0
Bloqs 3.1.3

I have a Page channel on my local ee3 install with pre-existing entries.
- Install Bloqs
- Install Publisher
- Create Bloqs types
- Create a Bloqs field in my Page channel
- Add a bloq in an existing entry, save as draft (1)
- View the entry draft, save as published (2)
- View the published, modify data in the bloq, save as draft (3)

In the DB, exp_blocks_atom, there are 3 rows (2 drafts and 1 open) for the same bloq. In the 2 drafts, one contains the content from (1), the second contains the content from (3).

The result:
Editing the draft still shows the content from (1). Interestingly enough, changing the content there, and saving as draft will update the correct bloq row. (see 4th screenshot)

At this point, if I save the draft as published, it creates a second open row in the DB. That second row contains the updated data, the first open row isn’t updated. (see 5th screenshot)

Not sure what’s going on.

Thanks

BoldMinded (Brian)

Thanks for the detailed report, I’ll try to replicate it locally and get back to you.

BoldMinded (Brian)

I can replicate this locally. To be honest its going to be a few days or a week or so before I can dive into this one.

BoldMinded (Brian)

Just a heads up, I think I’m close to a fix for this. Hopefully I’ll get a new build to you early next week or sooner.

Hop Studios

Hi Brian,

Thanks for the update 😊

BoldMinded (Brian)

Comment has been marked private.

Hop Studios

Hi there,

Thanks for the update.

I’ve updated Publisher to the version you sent me. I tried to modify the draft of my previous entry and added a row in the Bloq field. I hit save (as draft) and I got a bunch of errors:

Warning Missing argument 3 for Publisher_ext::blocks_set_block_order()

user/addons/publisher/ext.publisher.php, line 1421 show details

Severity: E_WARNING

Warning Missing argument 4 for Publisher_ext::blocks_set_block_order()

user/addons/publisher/ext.publisher.php, line 1421 show details

Severity: E_WARNING

Warning Missing argument 5 for Publisher_ext::blocks_set_block_order()

user/addons/publisher/ext.publisher.php, line 1421 show details

Severity: E_WARNING

Notice Undefined variable: entryId

user/addons/publisher/ext.publisher.php, line 1423 show details

Severity: E_NOTICE

Notice Undefined variable: fieldId

user/addons/publisher/ext.publisher.php, line 1423 show details

Severity: E_NOTICE

Notice Undefined variable: fieldData

user/addons/publisher/ext.publisher.php, line 1423 show details

Severity: E_NOTICE

Did I do something wrong ? I tried to delete all rows in the Bloq field, and then add a new one but the same errors occurred. I tried with PHP7 and then PHP5.6, same errors too.

BoldMinded (Brian)

Try the latest build available inf your account. I saw that error too this morning and believe I fixed it for the official release.

Hop Studios

I’ve downloaded the version on my account and same thing.

I also have errors when saving as published:

Warning Missing argument 3 for Publisher_ext::blocks_set_block_order()

user/addons/publisher/ext.publisher.php, line 1421 show details Warning Missing argument 4 for Publisher_ext::blocks_set_block_order()

user/addons/publisher/ext.publisher.php, line 1421 show details Warning Missing argument 5 for Publisher_ext::blocks_set_block_order()

user/addons/publisher/ext.publisher.php, line 1421 show details Notice Undefined variable: entryId

user/addons/publisher/ext.publisher.php, line 1423 show details Notice Undefined variable: fieldId

user/addons/publisher/ext.publisher.php, line 1423 show details Notice Undefined variable: fieldData

user/addons/publisher/ext.publisher.php, line 1423 show details Warning Cannot modify header information - headers already sent by (output started at ee/legacy/core/Exceptions.php:119)

ee/EllisLab/ExpressionEngine/Boot/boot.common.php, line 531 show details Exception Caught SQLSTATE[23000]: Integrity constraint violation: 1048 Column ‘entry_id’ cannot be null: INSERT INTO exp_blocks_block (blockdefinition_id, site_id, entry_id, field_id, order, publisher_lang_id, publisher_status) VALUES (1, 1, NULL, NULL, ‘1’, 1, ‘draft’)

ee/legacy/database/drivers/mysqli/mysqli_connection.php:122 Stack Trace: show

Hop Studios

Oh, my bad, I didn’t know I had to update Bloqs as well. So I installed Bloqs 3.1.4, and now I only got an SQL error when saving my entry as draft with a new Bloq row

SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ‘)’ at line 2: DELETE FROM exp_blocks_block WHERE id IN ()

#10

BoldMinded (Brian)

Oops, I think you need this conditional check:

https://www.dropbox.com/s/3ulo031aay58ojc/Screenshot 2017-07-18 19.00.00.png?dl=0

#11

BoldMinded (Brian)

Comment has been marked private.

#12

Hop Studios

I tried the new build and it seems to work properly. I’ll do some more testing, just in case 😊

Thanks a lot for the quick fix.

#13

BoldMinded (Brian)

Sweet, sounds good.

#14

BoldMinded (Brian)

I just found an issue with this new build. If you have a Relationship field inside of a block, they do not save correctly.

I’m going to have to revisit this issue.

#15

Hop Studios

Ok, I didn’t remember checking that. Thanks for keeping me posted.

#16

Hop Studios

Hi Brian,

Any news on that ?

Thanks

#17

BoldMinded (Brian)

Yes, the latest builds of both addons were released Monday and should fix the issue.