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: 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

Nigel

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

BoldMinded (Brian)

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?

BoldMinded (Brian)

What is the value of your php setting max_input_vars?

Nigel

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?

BoldMinded (Brian)

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

Nigel

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