Hi Brian,

We have had quite a long debugging process some time ago, it seemed like we had solved the issues.

But I am sorry to mention that we overlooked a tiny detail, which actually isn’t tiny at all.

When saving an entry with Publisher Lite & Bloqs (Publisher being the one from our previous ticket), I get a very big error:

Exception Caught
SQLSTATE[21S01]: Insert value list does not match column list: 1136 Column count doesn't match value count at row 1:
INSERT INTO exp_blocks_block (blockdefinition_id, site_id, entry_id, field_id, `order`, publisher_lang_id, publisher_status) VALUES (2, 1, 246, 23, '1')
ee/legacy/database/drivers/mysqli/mysqli_connection.php:116

Stack Trace: Please include when reporting this error
#0 ee/legacy/database/drivers/mysqli/mysqli_driver.php(111): CI_DB_mysqli_connection->query('INSERT INTO exp…')
#1 ee/legacy/database/DB_driver.php(269): CI_DB_mysqli_driver->_execute('INSERT INTO exp…')
#2 ee/legacy/database/DB_driver.php(179): CI_DB_driver->simple_query('INSERT INTO exp…')
#3 user/addons/publisher/legacy/libraries/hooks/Publisher_bloqs_hooks.php(273): CI_DB_driver->query('INSERT INTO exp…', Array)
#4 user/addons/publisher/ext.publisher.php(1466): Publisher_bloqs_hooks->blocks_create_block('INSERT INTO exp…', Array, 246, 23, Array)
#5 [internal function]: Publisher_ext->blocks_create_block('INSERT INTO exp…', Array, 246, 23, Array)
#6 ee/legacy/libraries/Extensions.php(227): call_user_func_array(Array, Array)
#7 ee/legacy/libraries/Extensions.php(122): EE_Extensions->call_class('Publisher_ext', 'blocks_create_b…', Array, Array)
#8 user/addons/bloqs/libraries/EEBlocks/Database/Adapter.php(483): EE_Extensions->call('blocks_create_b…', 'INSERT INTO exp…', Array, 246, 23, Array)
#9 user/addons/bloqs/libraries/EEBlocks/Controller/PublishController.php(462): EEBlocks\Database\Adapter->createBlock(2, 1, 246, 23, '1', Array)
#10 user/addons/bloqs/ft.bloqs.php(336): EEBlocks\Controller\PublishController->save(Array, 1, 246)
#11 [internal function]: Bloqs_ft->post_save('1')
#12 ee/legacy/libraries/api/Api_channel_fields.php(408): call_user_func_array(Array, Array)
#13 ee/EllisLab/ExpressionEngine/Model/Content/FieldFacade.php(209): Api_channel_fields->apply('post_save', Array)
#14 ee/EllisLab/ExpressionEngine/Model/Content/ContentModel.php(75): EllisLab\ExpressionEngine\Model\Content\FieldFacade->postSave()
#15 ee/EllisLab/ExpressionEngine/Model/Channel/ChannelEntry.php(353): EllisLab\ExpressionEngine\Model\Content\ContentModel->onAfterSave()
#16 [internal function]: EllisLab\ExpressionEngine\Model\Channel\ChannelEntry->onAfterSave()
#17 ee/EllisLab/ExpressionEngine/Service/Model/Model.php(824): call_user_func_array(Array, Array)
#18 ee/EllisLab/ExpressionEngine/Service/Model/Query/Update.php(50): EllisLab\ExpressionEngine\Service\Model\Model->emit('afterSave')
#19 ee/EllisLab/ExpressionEngine/Service/Model/DataStore.php(281): EllisLab\ExpressionEngine\Service\Model\Query\Update->run()
#20 ee/EllisLab/ExpressionEngine/Service/Model/DataStore.php(247): EllisLab\ExpressionEngine\Service\Model\DataStore->runQuery('Update', Object(EllisLab\ExpressionEngine\Service\Model\Query\Builder))
#21 ee/EllisLab/ExpressionEngine/Service/Model/Query/Builder.php(70): EllisLab\ExpressionEngine\Service\Model\DataStore->updateQuery(Object(EllisLab\ExpressionEngine\Service\Model\Query\Builder))
#22 ee/EllisLab/ExpressionEngine/Service/Model/Model.php(360): EllisLab\ExpressionEngine\Service\Model\Query\Builder->update()
#23 ee/EllisLab/ExpressionEngine/Model/Content/ContentModel.php(219): EllisLab\ExpressionEngine\Service\Model\Model->save()
#24 ee/EllisLab/ExpressionEngine/Controller/Publish/AbstractPublish.php(366): EllisLab\ExpressionEngine\Model\Content\ContentModel->save()
#25 ee/EllisLab/ExpressionEngine/Controller/Publish/Edit.php(468): EllisLab\ExpressionEngine\Controller\Publish\AbstractPublish->saveEntryAndRedirect(Object(EllisLab\ExpressionEngine\Model\Channel\ChannelEntry))
#26 [internal function]: EllisLab\ExpressionEngine\Controller\Publish\Edit->entry('246')
#27 ee/EllisLab/ExpressionEngine/Core/Core.php(240): call_user_func_array(Array, Array)
#28 ee/EllisLab/ExpressionEngine/Core/Core.php(109): EllisLab\ExpressionEngine\Core\Core->runController(Array)
#29 ee/EllisLab/ExpressionEngine/Boot/boot.php(146): EllisLab\ExpressionEngine\Core\Core->run(Object(EllisLab\ExpressionEngine\Core\Request))
#30 public_html/webmanager/index.php(143): require_once('...')
#30 public_html/webmanager/index.php(143): require_once('...')

So to help you with the process I started testing like a maniac, and this is what I’ve tried so far:
- Saving a new Entry with Bloqs field but without Bloqs as Published: Succes
- Saving a new Entry with Bloqs field but without Bloqs as Draft: Succes
- Saving an existing Entry with Bloqs field but without Bloqs as Published: Succes
- Saving an existing Entry with Bloqs field but without Bloqs as Draft: succes
- Saving a new Entry with Bloqs field and some added Bloqs as Published: Fail
- Saving a new Entry with Bloqs field and some added Bloqs as Draft: Fail
- Saving an existing Entry with Bloqs field and some added Bloqs as Published: Fail
- Saving an existing Entry with Bloqs field and some added Bloqs as Draft: Fail

Any ideas?