Publisher is EE6 compatible, but it does not support the Fluid field.

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: Duplicating bloqs does not save

Status Resolved
Add-on / Version Bloqs 4.6.0
Severity
EE Version 6.0.3

Nigel

Mar 14, 2021

I am setting up a new site locally in MAMP with the intention to copy up the database when complete.

I am finding that nested blocks are coming up with a error when I try to save.

Below is the error from the dev logs:

Bloqs save error: SQLSTATE[HY000]: General error: 1366 Incorrect integer value: ‘blocks_new_block_22’ for column ‘parent_id’ at row 1:
INSERT INTO exp_blocks_block (`blockdefinition_id`, `entry_id`, `field_id`, `order`, `parent_id`, `draft`, `depth`, `lft`, `rgt`, `templatedefinition_id`) VALUES (8, 765, 30, 20, ‘blocks_new_block_22’, 0, 1, 38, 41, 1)

Here is a link to a screen recording showing the issue in action:

https://www.icloud.com/iclouddrive/0_iMCyszHaTZyObK1EtuM-4-A#Screen_Recording_2021-03-14_at_18.50

#1

Nigel

Mar 14, 2021

Taking look at this I can see that the query is trying to save a string into a int field. parent_id

Very keen for a solution as I am unable to fully create my pages.

Thanks

#2

BoldMinded (Brian)

Mar 14, 2021

Does this happen when creating a new entry or only when editing an existing entry and adding new blocks?

Is this a site that was upgraded from a previous version of Bloqs or a new install?

Do you have any errors in your JS console?

#3

BoldMinded (Brian)

Mar 14, 2021

What is the value of your php setting max_input_vars?

#4

Nigel

Mar 14, 2021

This is a site that I had recently upgraded from a previous install.

No JS errors.

max_input_vars = 1000

I have tried a fresh page and I do not experience the same errors. Anything I should take onboard?

#5

BoldMinded (Brian)

Mar 14, 2021

Sounds like a max input vars issue. Change it to 2000 and see what happens. Or 3000 to play it safe.

#6

Nigel

Mar 15, 2021

This specific Issue I have not seen again since creating fresh entries. Will close for now.

Login to reply