In one case on my local development environment the page fails to save after I add a new bloq. In my local development server I’m using MYSQL 5.7 but on remote I’m using 5.6. I’m thinking that may be part of the issue.

Developer Log Notice

Bloqs save error: 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 ':visible WHERE id = 195' at line 1:
UPDATE exp_blocks_block SET `order` = 1, `parent_id` = 0, `depth` = 0, `lft` = 1, `rgt` = 2, `visible` = :visible WHERE id = 195#0 /Volumes/dev/localhost/hadley.local/public_html/library/ee/legacy/database/drivers/mysqli/mysqli_driver.php(112): CI_DB_mysqli_connection->query('UPDATE exp_bloc…') #1 /Volumes/dev/localhost/hadley.local/public_html/library/ee/legacy/database/DB_driver.php(270): CI_DB_mysqli_driver->_execute('UPDATE exp_bloc…') #2 /Volumes/dev/localhost/hadley.local/public_html/library/ee/legacy/database/DB_driver.php(180): CI_DB_driver->simple_query('UPDATE exp_bloc…') #3 /Volumes/dev/localhost/hadley.local/public_html/library/user/addons/bloqs/libraries/EEBlocks/Database/Adapter.php(1033): CI_DB_driver->query('UPDATE exp_bloc…') #4 /Volumes/dev/localhost/hadley.local/public_html/library/user/addons/bloqs/libraries/EEBlocks/Database/Adapter.php(714): EEBlocks\Database\Adapter->query('UPDATE exp_bloc…', Array) #5 /Volumes/dev/localhost/hadley.local/public_html/library/user/addons/bloqs/libraries/EEBlocks/Controller/PublishController.php(583): EEBlocks\Database\Adapter->setBlockOrder(195, 1, 48, 1, Array, Array, 0) #6 /Volumes/dev/localhost/hadley.local/public_html/library/user/addons/bloqs/ft.bloqs.php(364): EEBlocks\Controller\PublishController->save(Array, 48) #7 /Volumes/dev/localhost/hadley.local/public_html/library/ee/legacy/libraries/api/Api_channel_fields.php(410): Bloqs_ft->post_save(Array) #8 /Volumes/dev/localhost/hadley.local/public_html/library/ee/EllisLab/ExpressionEngine/Model/Content/FieldFacade.php(210): Api_channel_fields->apply('post_save', Array) #9 /Volumes/dev/localhost/hadley.local/public_html/library/ee/EllisLab/ExpressionEngine/Model/Content/ContentModel.php(76): EllisLab\ExpressionEngine\Model\Content\FieldFacade->postSave() #10 /Volumes/dev/localhost/hadley.local/public_html/library/ee/EllisLab/ExpressionEngine/Model/Channel/ChannelEntry.php(412): EllisLab\ExpressionEngine\Model\Content\ContentModel->onAfterSave() #11 [internal function]: EllisLab\ExpressionEngine\Model\Channel\ChannelEntry->onAfterSave() #12 /Volumes/dev/localhost/hadley.local/public_html/library/ee/EllisLab/ExpressionEngine/Service/Model/Model.php(825): call_user_func_array(Array, Array) #13 /Volumes/dev/localhost/hadley.local/public_html/library/ee/EllisLab/ExpressionEngine/Service/Model/Query/Update.php(51): EllisLab\ExpressionEngine\Service\Model\Model->emit('afterSave') #14 /Volumes/dev/localhost/hadley.local/public_html/library/ee/EllisLab/ExpressionEngine/Service/Model/DataStore.php(282): EllisLab\ExpressionEngine\Service\Model\Query\Update->run() #15 /Volumes/dev/localhost/hadley.local/public_html/library/ee/EllisLab/ExpressionEngine/Service/Model/DataStore.php(248): EllisLab\ExpressionEngine\Service\Model\DataStore->runQuery('Update', Object(EllisLab\ExpressionEngine\Service\Model\Query\Builder)) #16 /Volumes/dev/localhost/hadley.local/public_html/library/ee/EllisLab/ExpressionEngine/Service/Model/Query/Builder.php(71): EllisLab\ExpressionEngine\Service\Model\DataStore->updateQuery(Object(EllisLab\ExpressionEngine\Service\Model\Query\Builder)) #17 /Volumes/dev/localhost/hadley.local/public_html/library/ee/EllisLab/ExpressionEngine/Service/Model/Model.php(361): EllisLab\ExpressionEngine\Service\Model\Query\Builder->update() #18 /Volumes/dev/localhost/hadley.local/public_html/library/ee/EllisLab/ExpressionEngine/Model/Content/ContentModel.php(225): EllisLab\ExpressionEngine\Service\Model\Model->save() #19 /Volumes/dev/localhost/hadley.local/public_html/library/ee/EllisLab/ExpressionEngine/Controller/Publish/AbstractPublish.php(376): EllisLab\ExpressionEngine\Model\Content\ContentModel->save() #20 /Volumes/dev/localhost/hadley.local/public_html/library/ee/EllisLab/ExpressionEngine/Controller/Publish/Edit.php(527): EllisLab\ExpressionEngine\Controller\Publish\AbstractPublish->saveEntryAndRedirect(Object(EllisLab\ExpressionEngine\Model\Channel\ChannelEntry)) #21 [internal function]: EllisLab\ExpressionEngine\Controller\Publish\Edit->entry('48') #22 /Volumes/dev/localhost/hadley.local/public_html/library/ee/EllisLab/ExpressionEngine/Core/Core.php(241): call_user_func_array(Array, Array) #23 /Volumes/dev/localhost/hadley.local/public_html/library/ee/EllisLab/ExpressionEngine/Core/Core.php(110): EllisLab\ExpressionEngine\Core\Core->runController(Array) #24 /Volumes/dev/localhost/hadley.local/public_html/library/ee/EllisLab/ExpressionEngine/Boot/boot.php(151): EllisLab\ExpressionEngine\Core\Core->run(Object(EllisLab\ExpressionEngine\Core\Request)) #25 /Volumes/dev/localhost/hadley.local/public_html/manage.php(153): require_once('/Volumes/dev…') #26 {main}