Be sure to checkout our newest add-on Reading Time Pro!

Compatibility updates:

  • Publisher is EE5 compatible, but it does not currently support the Fluid field (it's in the works).

Ticket: Bloqs Save Error

Status Resolved
Add-on / Version Bloqs 4.1.0
Severity
EE Version 5.3.0

Cara Ernest

Oct 23, 2019

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}
#1

BoldMinded (Brian)

Oct 24, 2019

Comment has been marked private.

#2

Josh Brodleit

Oct 24, 2019

That did it. Tested it on both MYSQL versions and appears to be working perfectly.

Login to reply

Contact

For add-on support, please use the Support section. General inquries and pre-sale questions can be sent to support@boldminded.com.