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: Site ID Error In Latest Bloq Version W/ Simple Cloner Module

Status Resolved
Add-on / Version Bloqs 4.0.0
Severity
EE Version 3.5.3

Justin Albano

Jun 05, 2018

Description:
I am receiving a SQL error complaining about an unknown column `site_id` in the `field list`.

I am using Bloqs 3.0 perfectly fine in another site, in conjunction with the same version of Simple Cloner, so i thought i would check with you first on potential hot-fixes I may be able to apply, or advice on how to downgrade from 4.0.0 -> 3.00 safely?

Thank You!

Best,

Kevin Carpenter
GRAYBOX

FIRST ERROR / Full Error:

Warning:
Illegal string offset ‘tree_order’
user/addons/bloqs/ft.bloqs.php, line 346

NOTICE:
Undefined property: stdClass::$site_id
user/addons/simple_cloner/ext.simple_cloner.php, line 430

EXCEPTION CAUGHT:
SQLSTATE[42S22]: Column not found: 1054 Unknown column ‘site_id’ in ‘field list’:
INSERT INTO `exp_blocks_block` (`blockdefinition_id`, `site_id`, `entry_id`, `field_id`, `order`) VALUES (41, NULL, 3161, 22, 1)
ee/legacy/database/drivers/mysqli/mysqli_connection.php:122

SECOND ERROR:

SQLSTATE[42S22]: Column not found: 1054 Unknown column ‘site_id’ in ‘where clause’:
SELECT bd.id as bd_id, bd.shortname as bd_shortname, bd.name as bd_name, bd.instructions as bd_instructions, b.id as b_id, b.order as b_order, ad.id as ad_id, ad.shortname as ad_shortname, ad.name as ad_name, ad.instructions as ad_instructions, ad.order as ad_order, ad.type as ad_type, ad.settings as ad_settings, a.id as a_id, IFNULL(a.data, ‘’) as a_data FROM exp_blocks_block b LEFT JOIN exp_blocks_blockdefinition bd ON b.blockdefinition_id = bd.id LEFT JOIN exp_blocks_atomdefinition ad ON bd.id = ad.blockdefinition_id LEFT JOIN exp_blocks_atom a ON a.block_id = b.id AND a.atomdefinition_id = ad.id WHERE b.field_id = 22 AND entry_id = 3155 AND site_id = 1 ORDER BY b.order, ad.order
ee/legacy/database/drivers/mysqli/mysqli_connection.php:122

Detailed steps to reproduce the issue:
1. The first error appears when trying to clone an existing Page entry with Bloqs Data attached via the Simple Cloner ‘clone entry’ button, in the Simple Cloner Tab via the Simple Cloner module.
2.
3.

#1

BoldMinded (Brian)

hi Justin. The site_id column was removed in 4.x, so the developer of Simple Cloner would have to make this update. Bloqs does not have any Simple Cloner related code in it.

#2

Justin Albano

Brian,

Is there a way to rollback the Bloqs module from 4.0.0 to 3.x.x to get around this issue?

I am not experiencing this issue using 3.x.x and the same version of Simple Cloner.

Nonetheless, i have reached out to the developer of the Simple Cloner module, especially now that i am receiving DIFFERENT errors after attempting to update Simple Cloner from 1.2 -> 2.0.

Thanks for the help.

Best, Kevin

#3

BoldMinded (Brian)

None of my addons, or anyone else’s that I know of including EE itself, account for rolling back. The only way to roll back is to restore from a previous database dump (which is what EE’s roll back does).

#4

BoldMinded (Brian)

Closing this b/c its not a bug with Bloqs. Simple Cloner will need to make updates now that the site_id column no longer exists.

Login to reply